I’m going to show how to export data from visuals in Power BI Desktop that’s too big to be downloaded by the native functionality and therefore returns this error-message: Check (…) Read more
Posts in Category ‘Power BI’
Text.RemoveBetweenDelimiters function for Power BI and Power Query
While Power Query has a native function to fetch text between 2 delimiters in Power Query, there is no such function that removes the text instead. Therefore I’ve created a (…) Read more
Debug DAX variables in Power BI and Power Pivot
When you’re dealing with a beast like DAX you can use any help there is, right? So here I show you how you can debug DAX variables who contain tables (…) Read more
DAX CALCULATE Debugger
CALCULATE is the most powerful function in DAX, as it allows you to change the filter context under which its expression is evaluated to your hearts content. But with big (…) Read more
The full Table.ContainsAnywhere function for Power Query in Power BI and Excel
In a previous post I introduced the concept of a function that searches for an occurrence of a character or string within all columns of a table. Here I share (…) Read more
Bug in Power BI R Scripts “package … was installed with different internals”
Today I spent many hours hunting an R-script error in Power BI and before Steph Locke came up with a solution for this, I came across a couple of posts (…) Read more