When you use an API with a paging mechanism (like the example from this blogpost), you’ll might work with a field that contains the address for the next page. You (…) Read more
Posts Tagged ‘Power BI’
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
Create a load history or stage in CDS instead of incremental load in Power BI
If you’ve been following my blog for a while, you might have noticed my interest in incremental load workarounds. It took some time before we saw the native functionality for (…) Read more
Power BI “Store datasets in enhanced metadata format” warning
Edit October 2020: This feature is now generally rolled out, so there is no way to go back to the old format any more. From what I’ve heard, the problems (…) 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
Calculating doubling times with DAX in Power BI
In this article I show methods to calculate the doubling time with DAX in Power BI. Doubling time is an indicator used for exponential growth scenarios. It indicates how much (…) Read more