Power BI and Power Automate - Automatic Alerts

Power Automate Power Platform
1

We have a Power BI application which is live and we are getting involved with Power Automate as a matter of some urgency.

Our application gets its data from a SQL database where the data is collected in real time from a variety of machines and we have a number of performance statistics and we will use Power Automate to send a variety of messages to engineers etc. We are quite comfortable with our ability to do this.

We would also like to use Power Automate to collect data directly from the SQL database and automatically send out alerts in the event of one of the machines having a “critical error” which makes the machine unusable / dangerous.

Firstly, is this possible and if so how can we go about it?

Thanks in anticipation

Paul Boyes

2

HI @PaulBoyes

As you already have Power BI solution in place then you can use it’s dataset to connect to Power Automate to get triggers for your email notification.

Based on your “Critical Error”
You can implement Power Automate in the same solution or can build another solution.

Below document related to this might help you.
Trigger a cloud flow from any Power BI report - Power Automate | Microsoft Docs

Thanks
Mukesh

3

Hi @PaulBoyes, did the response provided by @MK3010 help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

I hope that you are having a great experience using the Support Forum so far. Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

4

Hi @PaulBoyes, we’ve noticed that no response has been received from you since the 4th of June. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.