This post contains a PowerShell script that triggers a refresh process for three Power BI datasets. Additionally, this script is called/executed as part of automated
Author: Brett Powell
Technology consultant and developer focused on data and analytics.
Group Email Notification for Dataset Refresh Failure
The owners of Power BI datasets have the option to receive an email notification if a scheduled refresh fails. While this feature is helpful, given
Power BI Workspace Scripts
If you’re a Power BI administrator you’re probably already familiar with the Power BI Management module of PowerShell cmdlets. Additionally, as an alternative to PowerShell,
Analysis Services Monitoring Report v1.0
In addition to the TMSCHEMA DMVs utilized by the Tabular Model Schema Reference v1.1, several of the ‘DISCOVER’ DMVs such as DISCOVER_CONNECTIONS can be useful
Models on a String
Let’s say you’re a senior BI developer responsible for several Analysis Services Tabular instances (Dev, Test, Prod), each of which may host multiple databases. Each
Azure BI Resource Management via SSIS and PowerShell
In this week’s episode of Insight Quest, Brett, a BI consultant from Frontline Analytics, has been assigned tasks related to the programmatic management of Azure
