Unable to refresh the dataset in Power BI using Power Automate flow

(0) Share

Report

Posted on by CU22110541-1

Hi, I have a table created in my Power BI. I created a button which triggers a Power Automate flow that refreshes the dataset and a card to view the last refreshed date and time. When I publish and try to run it by clicking the button, it's not refreshing. But when I click refresh Refresh icon from Power BI, it's getting refreshed. I don't understand where I'm missing. Can anyone help me to resolve this issue?

Thanks in advance.

Categories:

General Discussion

2.png

All responses (1)

Answers (0)

lbendlin 7,854 on at

Like (0)

Report

Unable to refresh the dataset in Power BI using Power Automate flow

" which triggers a Power Automate flow that refreshes the dataset and a card to view the last refreshed date and time. "

No, that's not what it does. It requests a refresh. Then it continues the flow without waiting for the result.

The refresh may or may not happen, it can take an arbitrary amount of time, and when it finishes it can be successful or it can fail.

All of this is asynchronous. If you want to wait for the refresh to finish you need to implement your own polling process in Power Automate.

NOTE: Allowing report users to request dataset refreshes is a VBI (Very Bad Idea) for the reasonse explained above. Best case scenario will be a membership in the 429 club.