This blog describes a few simple, easy-to-implement techniques that can be used to increase the performance and scalability of Power BI reports which utilize DirectQuery
Author: Brett Powell
Technology consultant and developer focused on data and analytics.
Synapse SQL Monitoring Template
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.
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
