The native Table.Contains-function in Power Query tells you if one or more strings are included in one or more of its columns. But you have to be specific about which (…) Read more
Posts in Category ‘Power BI’
How to cancel your Power Query refreshes fast in Power BI and Excel
If you’re working with large data or complex queries that take a long time refresh, cancelling one of those refreshes can even take longer time, especially, if the query has (…) Read more
Easy way to retrieve Teams data in Power BI via Flow (and other data from the Graph)
In a previous post I’ve described how to use a custom connector to retrieve data from the Microsoft Graph API. But this requires to register an App and adjusting the (…) Read more
Query folding on JoinKind.Inner gotcha for Power BI and Power Query
If you query databases who support query folding, you’re probably very aware of every step you take and check if folding happens with every new step like so: Folding will (…) 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
Export data from Power BI using Microsoft Flow
Edit 5th May 2019: Unfortunately this method will not work in the Power BI service! Edit 23rd August 2021: Pedro del Melo Cabral Sousa has found a workaround how to (…) Read more