This article was edited on 2nd Nov 2019. JoinKind.Local has been removed to avoid problems with merges on tables with primary keys: In this article you’ll learn how to speed (…) Read more
Posts Tagged ‘Power BI’
Parent-Child Hierarchies with multiple parents in Power BI with Power Query
I’ve written about a method to dynamically flatten parent-child-hierarchies also with multiple parents some while ago here. I’ve actually used this approach for Bill-of-materials cases and refined that approach in (…) Read more
Power BI administration made easy with Power BI REST API custom connector
Today I read the (as always) great article by Matthew Roche “Governing Power BI just got a little easier” and couldn’t find a description on how to get to this (…) Read more
Export large amount of data from Power BI desktop visuals
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
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