Data driven alert with direct query data

[Heinrich]

Hello

Is it possible to trigger alerts when data is in direct query or mixed mode?
Changing mode is not feasible, because of size of data.
If no how can that be done?
Regards
Juan

[v-csrikanth]

Hi @Heinrich 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards
Cheri Srikanth

[Heinrich]

Hello @v-csrikanth 
Sorry.
I resolved it with another approach. I design a visual with filter "show all below value of 10" and then run a flow. 

This made the trick

Have a great day
Heinrich

[v-csrikanth · Accepted solution]

Hi @Heinrich 
Yes the referring document is for creating a dataflow.
Please refer the below link for PA flows.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-flow-integration

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[Heinrich]

Hello @bhanu_gautam 
Hope you are doing well. Thank you very much.
This is the explanation to dataflow: Creating a dataflow - Power BI | Microsoft Learn right?
How to do that with Power Automate?

[bhanu_gautam]

@Heinrich In Power BI, triggering alerts directly on data in DirectQuery or mixed mode is not natively supported. Power BI alerts are typically set on dashboards and are based on data that is imported into Power BI. 

You can create a dataflow to pre-aggregate or pre-process your data and then import the results into Power BI. This way, you can set alerts on the imported data Or you can use Power Automate