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!
Share
Report
All responses (
Answers (
8,474
