Create alerts triggered by a table column value

[TiagoCoelho]

Is it possible to create alerts on PBI that looks into a specific table column into a report and trigger an alert that can be used by a PowerAutomation? if yes, how can we achieve that?

For example:

Imagine that I have this table and I wanted to create an alert everytime a "Speciality" gets volumes >500. Then my idea is to use these alerts to trigger a flow on PowerAutomate in order to send an notification to a specific user assigned to that "Speciality".

Is this possible to achieve? if yes, can you give me any tip on how can I do it?

Thanks

[v-robertq-msft · Accepted solution]

Hi, @TiagoCoelho 

As far as I’m concerned, you can only set alerts for the tiles on the dashboards in the Power BI service which are pinned from report visuals, and only on gauges, KPIs, and cards. You can even automate and integrate alerts with Power Automate. You can try it yourself in this Power Automate and Power BI article.

You can also follow this document to create and set an alert in the Power BI service:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@TiagoCoelho , I think, You can get data using power BI rest APIS and try something list this in power automate

https://docs.microsoft.com/en-us/rest/api/power-bi/