Refreshing Power BI based on KPI Value

Hello,

I am trying to see if the flow I am attempting to build will work. What I want to happen is that my Power BI dataset refreshed at 9am, but since we have occasional data delays, I want the flow to check one of my KPIs. If the KPI equals zero, the dataset refreshes again. I want it to refresh until the KPI is greater than zero. Is something like this possible with power automate? Here's a little more detail, if needed:

The data: So the KPI I want to "read" is daily sales for yesterday. If the data is ready, it will give me a value anywhere from 1K - 12K. If there is a delay, the KPI will be 0.

Current Flow: So my current flow will take the PDF of the report refreshed at 9am, attach it to an email, and send it to a specific list of people. This works 90% of the time, but if there is a delay in data at 9am, then the report will send out with just zeros for sales.

Goal: I want to create a flow that will "read" the Sales KPI and have the report refresh again if Sales were 0, but stop if they are greater than zero. I keep hitting deadends with this.

Thanks in advance!

Categories:

Business Process Flows

Quick Links

Leaderboard