Forum Discussion
Using power automate to send emails when data values reach threshold
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.
Two questions. First will this work without having powerbi pro? Also I was just trying to test this but am unsure of what to put in the "Query Text" box.
Not sure what you mean by "Power BI Pro" - please clarify.
You put your DAX query in there, as described in the article. You can use Performance Analyzer to "borrow" the DAX query that is used for a particular Power BI visual, or you can construct your own.
Thank you so much. I just mean that some features are locked for me like exporting power bi reports as files on power automate.
Should I use the data from direct query or imported?
"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!!