This blog post provides two Power BI templates (one import, one DirectQuery) which query common dynamic management views (DMVs) used to monitor Azure Synapse Analytics.
Author: Brett Powell
Technology consultant and developer focused on data and analytics.
Paginated Report Execution Time
One of the most common requirements for paginated reports, which are often printed or exported, is to note the date and time the report was
Parallel Power BI Scripts
PowerShell 7.0 was made generally available last month and one of it’s new features is pipeline parallelization for the ForEach-Object cmdlet. Scripts running on PowerShell
Dynamic Datasets Part I
The purpose of this post is to introduce a method of making the datasets embedded in paginated reports more dynamic. Specifically, multiple queries reflecting distinct
Power BI Warning Signs
The purpose of this post is to identify a number of behaviors and assumptions which may contribute to suboptimal Power BI projects and overall Power
Retrieve Power BI Pro Licensed Users
Managing the assignment of Power BI Pro licenses is a fundamental task of Power BI administrators. The Power BI admin, the BI team, and possibly
