Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 r...
  • v-priyankata's avatar
    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.