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 if certain values are repeated over a set number of times. This obviously would implement count. My main issue is that I want this to be done live, using direct query, so that as soon as a certain value has a count greater than the threshold I am sent an email. My problem is that the build in power automate visual only activates when the button is clicked, I want this flow to be more scheduled, refreshing every minute or second if possible.
I've tried a lot of work arounds including the do until action, and trying to schedule a flow. The problem with a scheduled flow is it needs a data value to reach a goal, I want to see even after one value reaches a threshold if any others reach that 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.
8 Replies
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/
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.
Anonymous please create a new post.