Forum Discussion
How to create data alerts in Power bi
- 1 year ago
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.
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.