“Chris Webb's BI Blog: Why Is Power BI Running My SQL Query Twice?” - Ilgar Zarbaliyev's Nuzzel Newsletter for Tue, Jul 7

When you import data from a relational database like SQL Server in Power BI you have the option of entering your own SQL query to use as a starting point: Here's the M code for a query that does this: If you're confident writing SQL this might seem…

I recently had the requirement to save the monthly Dataset of a Power BI Report. I remembered a blog post by Chris Webb on how to use Power Automate to access the Power BI Rest API. The following post describes how I use this to create a monthly…