This post describes how to split a pbix into a model and report file using a PowerShell Script. This means any report can quickly be split into a data model file and live connection report file.
This article is the second part in a series on API calls. It will look at some best practices and considerations when using API calls in Power Query.
This article examines using the advanced editor in Power Query to better handle when things go wrong. It will also allow custom actions to be triggered using Power Automate, allowing the rest of the data to be refreshed while alerting the owner by email of data source errors.