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