This blog post describes a Power BI template that analyzes the quality of rowgroups within columnstore indexes in Azure Synapse Analytics. The template provides two
Category: Power BI
Power bi pro guide to Azure synapse analytics
The Power BI Professional’s Guide to Azure Synapse Analytics, a white paper I wrote describing the Synapse Analytics platform and its benefits and use cases
Simple DirectQuery Performance Tips
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
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
