This is an old post. Meanwhile we can implement proper incremental refresh with Power BI licenses: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh Warning – edit 03-Jan-18: This method doesn’t work in the service unfortunately. Please upvote the (…) Read more
Dynamic & bulk type transformation in Power Query, Power BI and M
This is just a quick code-share-of-the-day of different scenarios for dynamic type transformation of multiple columns at once. The syntax to transform the format of 2 columns (“Column1” and “Column2”) in (…) Read more
Dynamic Power Query X-mas tree in Excel
Wishing my faithful readers peaceful and happy holidays. Hope you enjoy my jumping Power Query X-mas tree: It changes his size or decoration randomly every time you press refresh: Totally auto-M-agically 😉 (No (…) Read more
How to store tables longer than 1,1 Mio rows in an Excel-sheet using Power Query and JSON
If you are working Power Query, you might come into a situation where you would like to make tables accessible from outside that file, that are longer than the 1,1 Mio rows (…) Read more
Dynamic duration calculation using DAX in Power BI and Power Pivot
While it is fairly easy to calculate the difference between 2 dates in DAX using DATEDIFF, it is a bit more demanding if you want to exclude weekends and holidays (…) Read more
Analyzing events with a duration in DAX – further simplification
Alberto Ferrari has recently published a very smart concept how to analyze events with a duration in DAX, which you should read here, if you haven’t done yet. It simplifies (…) Read more