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
Posts in Category ‘little Tipps&Tricks’
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
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