Power BI Data Alert Cycle Through Filters to Teams Notification

Anonymous
2021-05-12T06:24:54.697+00:00

Hi all,

I am new to Power BI & Power Automate, any help would be much appreciated. I have successfully created a Data Alert on Power BI that would send me a message on Teams when a KPI measure reaches a certain threshold (Greater than 0). I have a 'store_name' filter that has 10 different stores and I want to cycle through each store to see if any of the stores will trigger the alert. How can I do this?

I've tried to use Power Automate and create a custom flow on Power BI but was unsuccessful.

Tested Custom Flow 1: (Successful)

  1. When a Data Driven Alert is Triggered
  2. Post a message as a flow bot to a user (preview)

Tested Custom Flow 2: (Failed)
Added store_name filter and KPI into Power BI (Power Automate Visual)

  1. On Power BI Button Click
  2. Apply to Each Store_Name
  3. Add Condition, if KPI (Greater than 0) then Send Message, else nothing. (Error Message Here)

Example:
'Store_Name' Filter

  • Store A
  • Store B
  • Store C

The value of the KPI changes as I select different stores from the filter. If I select Store B and it is above the threshold, I want it to send me a message on Teams notifying me Store B is above the threshold and requires attention.

Many thanks in advance.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
34,991 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,456 Reputation points
    2021-05-12T08:25:22.227+00:00

    Power Automate / Power BI / App / Flow related questions are not supported on this forum. It's better to reach out to experts in a dedicated forum over here:

    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums


    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    0 comments No comments