Edit: There is currently no interest at Microsoft to change the current behaviour: http://community.powerbi.com/t5/Issues/Bug-Query-folding-not-working-with-non-SQL-datasource/idi-p/225100#M11611 . I found that this workaround works also pretty well (faster in most cases), as long (…) Read more
Posts in Category ‘Excel’
Import multiple files from Dropbox folder into PowerBI and Excel (via PowerQuery) at once
Edit 2nd October 2021: Unfortunately this method doesn’t work any more, as Dropbox now requires proper OAuth authentication. Below you’ll find a video where you can see how easy it is to (…) Read more
Unpivot by number of columns and rows in PowerBI and PowerQuery in Excel
Today I’m sharing with you one of my killer M(inja)-strikes: Unpivot a table by simply passing the number of columns that shall remain (at the left side of the table) (…) Read more
Performance Tip: Partition your tables at crossjoins where possible – PowerQuery PowerBI
Recently I’ve distributed some techniques for partial matches or relative joins between tables using PowerQuery or the query editor in PowerBI. They are very flexible and powerful – yet slow. (…) Read more
Goal seeking and XIRR in PowerBI and PowerQuery
If you want to solve Excels XIRR-function with M in PowerBI or PowerQuery you have to use a goal seeking algorithm. I tried it with a binary-search and the results were (…) Read more
Performance difference between Excel and PowerBI with M is huge!
I knew that the performance of M in the query editor of PowerBI was much better than in Excel, but only today I discovered the incredible difference we actually have (…) Read more