Using power automate to send emails when data values reach threshold

[Anonymous]

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.

[lbendlin · Accepted solution]

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.../

[Anonymous]

Hello I am trying to achive somthing similar. in my run a query agains dataset i output a table with two columns. my question is how to reference the column 2 in the next step .

when the value is 

[lbendlin]

@Anonymous please create a new post.

[lbendlin · Accepted solution]

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.../

[Anonymous]

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. 

[lbendlin]

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]

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? 

[lbendlin · Accepted solution]

"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.

[Anonymous]

thank you so much this has been a real help!!