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
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.