Forum Discussion
API refresh with Power Automate Flow unsuccessful even though the flow testing works
My PA flow refreshes the dataset whenever there's a refresh failure notification from Power BI. The flow run is successful but the actual refresh isn't successful. The error is "Error while processing dataset" but the funny thing is when I test my PA flow manually, it's successful every single time. Just wanna understand why this happens and if anyone else experienced the same issue?
2 Replies
You are requesting a dataset refresh way too frequently. The Power BI service is rejecting your requests, likely because another refresh is still in progress.
I doubt so because this dataset is refreshing only four times a day. And usually, the schedule refresh will fail 1 to 2 times a day so this flow gets activated. Anyway, the success rate of this flow has gotten close to 90% so it should be fine already. Thanks for the reply.
