Power BI – Power Query/Query Editor Automated Source Control
I saw a blog post recently where Jay Killeen was talking about how he handles his Source Control for the Query Editor or Power Query. And this got me thinking of how I could automate this in a quick and easy manner. So below is how I achieved this. My solution below, uses a BAT file and 7zip, which means…
Power BI, Power Query
5
Excel–Power Query–Automating SSIS job duration report
Following on from our query to get our SSIS Job duration information, I decided to start using Power Query and see if I could use it to facilitate the automation of my reporting requirements. Detailed below is how and what I archived. Example · We are going to use our SSISDB to see if there have been any changes in…
Recent Posts
Tags
Azure
Azure Analysis Services
BI-NSIGHT
BI-RoundUp
Dataflows
DAX
Microsoft Fabric
Power BI
Power BI Premium
Power BI Premium Per User
Power BI RoundUp
Power Query
Power Query
SQL Server 2014
SQL Server Analysis Services
SQL Server Analysis Services Tabular
SQL Server Reporting Services
SSAS
Tabular Editor
Teams
Uncategorized