Earlier this year I published a few posts describing approaches for retrieving Power BI artifacts via PowerShell scripts. As a Power BI administrator, the scheduled
Author: Brett Powell
Technology consultant and developer focused on data and analytics.
Analysis Services DMVs in SSMS
In the previous post we looked at using Registered Servers in SQL Server Management Studio (SSMS) to quickly and easily connect to Power BI Premium
Power BI Premium Registered Servers
XMLA endpoint connectivity for Power BI Premium represents one the most significant steps in Power BI becoming an enterprise BI platform as it exposes Power
Time Dimension Table via Power Query
Given the nearly universal application of date and time dimension tables to business intelligence projects it’s generally understood that these tables should be maintained as
Power BI Paginated Premium Metrics Report
If your organization has provisioned Power BI Premium capacity then you’re probably already familiar with the Power BI Premium Capacity Metrics app for monitoring performance
Analyze SQL Agent Job History with Power BI
The purpose of this post is to share and describe a Power BI-based solution for analyzing SQL Server Agent job history data. SQL Server Agent
