In this article I’ll show you how to create types from text in Power Query, enabling you to dynamically change types via functions for example. It’ll come out as a (…) Read more
Posts Tagged ‘M’
Performance tip for aggregations after joins in Power Query and Power BI
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
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
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
How to get more out of your Graph API custom connector in Power BI
Edit: Microsoft has announced that they don’t support querying MS Graph in Power BI: Lack of Support for Microsoft Graph in Power Query – Power Query | Microsoft Learn The (…) Read more