Forum Discussion
How to create data alerts in Power bi
Hi, Currently we don't have fabric account and we can't create the data alerts using activator so I need some help to create data alerts in power bi with PDF attachement.
1. If there is no data in report i don't want want send an email trigeers, if data presents send an alret with PDF attachement.
2. If the values is below 20000 i want send data alerts with PDF attachement.
How can we acheive the above requirements.
Hi Anonymous,
Can you please try below steps.Create a power bi report which will return the data with the values is below 20000
Then Start Creating a power automate flow.
1. Take new Scheduled Cloud Flow.
2. In the Recurrence activity set your Scheduled time intervals.
3. Click + New Step → Search "Power BI" → Select "Run a query against a dataset".
1. Select the workspace and dataset which you have created previously.
2. add below Dax Query change you table and column name as per your requirements.
EVALUATE
ROW("RowCount", COUNTROWS(FILTER('CustomerData', 'CustomerData'[CustomerID] < 20000)))
4. Click + New Step + Condition to check if there are any rows with above condition add the body('Run_a_query_against_a_dataset')?['results'][0]?['tables'][0]?['rows'][0]?['[RowCount]'] is greater than 0
5. Inside True condition add Export To File for Power BI Reports activity, select your report.
6. add next step as Send an email (V2) and configure your email. From the Advanced parameters add attachment and from dynamic functions, select file content from previous step.Your power automate function looks as below.
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
6 Replies
Hi Anonymous,
Can you please try below steps.Create a power bi report which will return the data with the values is below 20000
Then Start Creating a power automate flow.
1. Take new Scheduled Cloud Flow.
2. In the Recurrence activity set your Scheduled time intervals.
3. Click + New Step → Search "Power BI" → Select "Run a query against a dataset".
1. Select the workspace and dataset which you have created previously.
2. add below Dax Query change you table and column name as per your requirements.
EVALUATE
ROW("RowCount", COUNTROWS(FILTER('CustomerData', 'CustomerData'[CustomerID] < 20000)))
4. Click + New Step + Condition to check if there are any rows with above condition add the body('Run_a_query_against_a_dataset')?['results'][0]?['tables'][0]?['rows'][0]?['[RowCount]'] is greater than 0
5. Inside True condition add Export To File for Power BI Reports activity, select your report.
6. add next step as Send an email (V2) and configure your email. From the Advanced parameters add attachment and from dynamic functions, select file content from previous step.Your power automate function looks as below.
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.Power automate
Hi Anonymous
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Anonymous
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.Hi Anonymous
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
