Issues with Rwfresh Dataset from a Power automate Flow

[Orlando_Tuga]

In Power Bi i am uppon a trigger refreshing a dataset in power BI. The problem is that it's running and does not stop or finishes it. What can it be?
I am a Workspace Admin; I have a Power BI Pro Licence; All is ok with the credentials to refresh the file (excel) from Share Point; On the dataset in powr bi service i can refresh now; No licence for Azure

Really stressing here, anyone have an idea 

[tayloramy]

@Orlando_Tuga how long is that delay set for? Can you try running it without any delay just to see if it will trigger the refresh? 

[Orlando_Tuga]

I did it without and now only have 30 seconds

[tayloramy]

Was it able to successfully start the refresh of the semantic model? 

[Orlando_Tuga]

Yes and tried now as it was and it suceeded and in fact refreshed the data. Strange i made no change, is it because i have linits in refresh from my licenece (Pro) or other ???

[tayloramy · Accepted solution]

@Orlando_Tuga Very interesting. I don't believe there are any limits in refreshing from the API the way PowerAutomate does it. 

Glad it is working now though. 

Perhaps there was a misconfiguration on the wait activity? 

If you found this useful, consider giving Kudos. If I solved your problem or answered your question, mark this post as the solution. 

[tayloramy]

@Orlando_Tuga can you send us a screenshot of what your powerautomate flow looks like? That might help assist in the troubleshooting

[Orlando_Tuga]

[Orlando_Tuga]

very basic and easy way just to ensure the triger does the dataset Refresh

[v-tejrama]

Hi @Orlando_Tuga ,

I appreciate your concern and want to provide clarity. When you initiate a dataset refresh via Power Automate, it simply sends the command to Power BI to start the refresh; the flow does not monitor or wait for its completion. This is why it may appear as though the process is ongoing without finishing.

To ensure your flow continues only after the refresh is complete, you should leverage the Power BI REST APIs to check the refresh status before moving forward. Please confirm if the dataset is located in a Pro or Premium workspace, and whether the issue is with the dataset refresh not completing in the service or just the flow not stopping. This information will allow us to identify the best next steps.

Thank you,

Tejaswi.

[Orlando_Tuga]

The location is pro and the workflow does not stop, keeps running forever.

[GilbertQ]

Hi @Orlando_Tuga 

Please be aware that when kicking off a semantic model refresh using Power Automate, it will start the refresh but not monitor it to see when it is completed. If you want to make sure your next step only continues in Power Automate when the refresh is completed, you would need to use the Power BI REST Apis.

[Orlando_Tuga]

I have tried but for some reason my license does not allow me acces to it (Power BI REST Apis)

[tayloramy]

Hi @Orlando_Tuga, 

Can you provide some more details? 
What does your PowerAutomate flow look like? 
Is the semantic model sitting in a pro workspace or a premum workspace?

Is it the refresh that starts and never stops, or the PowerAutomate Flow? 

Providing these details will help the community answer your questions faster. 

If you found this helpful, consider giving some Kudos. If I solved your problem or answered your question, mark this post as the solution. 

[Orlando_Tuga]

I tried many ways and a very simple one; When a file is created or modified (Properties only) (Share Point) -> Refresha a Dataset (Power BI) -> Delay (30 sec.). The workspace is a pro workspace i beleive since i have a pro licence and i have created it.