Use Power Automate to send Power BI alerts

How to set up an alert using Power Automate if an error occurs with your data after a scheduled refresh in Power BI. 🔽 More Info below 🔽

In this scenario I focus on new codes appearing in your data that don't yet exist in your mapping / dimension table.


00:00 Intro
00:20 The Scenario
01:55 Creating an Exceptions table (to help explain the measure)
03:20 Creating the Exceptions Measure
05:18 Creating the 1 or 0 trigger measure
07:00 Adding a button to jump to the report from the hidden page
08:30 Pin alert visual to Admin Only dashboard
08:50 Add Alert
09:25 Set up Power Automate notification
11:35 Testing it out and demonstrating on mobile phone


Follow me on LinkedIn
  / wynhopkins  

Twitter
  / wynhopkins  

Access Analytic
https://accessanalytic.com.au/