Insight Quest – Brett Powell's Data & Analytics Blog

BI Skill Principles

Perhaps the most important decisions business intelligence professionals make is determining which technologies to learn and to what extent or...

2 years ago

Power BI Fraud

This post discusses the forms, origins, and indications of fraud and misrepresentation in the context of Power BI consulting and contract enga...

3 years ago

Breaking Changes in Power BI

This post reviews the deployment of common changes to Power BI datasets and the implications for the availability of the affected objects for ...

3 years ago

Common Power BI Admin Scripts Part II

Today’s post builds on top of Power BI Admin Scripts Part I by describing five additional PowerShell scripts that Power BI service admin...

3 years ago

Common Power BI Admin Scripts Part 1

Between the Power BI PowerShell modules and the Power BI REST APIs administrators have a rich set of tools to efficiently administer Power BI ...

3 years ago

XMLA-Based PBI Dataset Refresh Automation

Now that read/write XMLA endpoints for Power BI Premium datasets are generally available, along with support for service principals, BI teams ...

3 years ago

Larry Bird vs. Lebron James

The following Power BI dataset and report has been developed to help compare basketball greats Larry Bird and Lebron James across team and ind...

3 years ago

Processes of Power BI

The following document describes several common Power BI processes and considerations for each: Processes of Power BI I hope you find this use...

4 years ago

Automated Index Partition Rebuilds

This post provides an example of a stored procedure which A) identifies the last two partitions of an Azure Synapse Analytics SQL pool table (...

4 years ago

Synapse Columnstore Index Analysis Template

This blog post describes a Power BI template that analyzes the quality of rowgroups within columnstore indexes in Azure Synapse Analytics. The...

4 years ago