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
[ Ссылка ]
Twitter
[ Ссылка ]
Access Analytic
[ Ссылка ]
![](https://s2.save4k.ru/pic/tl4oFDDF59A/maxresdefault.jpg)