Forum Discussion
Data driven alert with direct query data
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
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.
5 Replies
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
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.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 SrikanthHello 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
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?
