When you reference another query in Power Query you will automatically get the results of the final step. But what if you want to reference a step that sits within (…) Read more
Posts in Category ‘little Tipps&Tricks’
Convert DateTime to ISO 8601 date and time strings in Power Query
Often, when querying APIs it is required to enter date and time filters in ISO 8601 format . Today I show a quick way to convert DateTime to ISO 8601 string, (…) Read more
Performance tip to speed up slow pivot operations in Power Query and Power BI
Pivot operations in are a very handy feature in Power Query but they can slow down refresh performance. So with some bittersweet pleasure I can tell that I found a (…) Read more
Automatically detect and change the types of all columns at once in Power Query
Today I want to share quick tip on how to automatically detect and change all column types at once in Power Query. Background Very often, when you expand a column (…) Read more
Tips to download files from webpages in Power Query and Power BI
When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the (…) Read more
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