Forum Discussion
Using power automate to send emails when data values reach threshold
I've been trying to create a flow that happens using power bi data, and continues even after the power bi button has been clicked. I essentially have a table of live data, and I want to be notified i...
With the May update you can now run DAX queries against datasets from Power Automate without the need for a custom connector. There is no threshold trigger option so you need to resort to polling (which Power Automate does behind the scenes anyway).
https://powerbi.microsoft.com/en-us/blog/unlocking-new-self-service-bi-scenarios-with-executequeries-support-in-power-automate/
"Should I use the data from direct query or imported? "
That is no longer relevant at this point as you are querying the Power BI dataset in the Azure cloud.
"Should I use the data from direct query or imported? "
That is no longer relevant at this point as you are querying the Power BI dataset in the Azure cloud.
thank you so much this has been a real help!!