You’re offline. This is a read only version of the page.
Hi,
I use Power automate to refresh an excel table that is connected to Power BI every day.
This is via a 'Run Script' prompt that refers to a script containing Workbook.refreshAllDataConnections().
This has always functioned very well. However, as of today, I receive the below error.
Has Microsoft changed the possibility to use Workbook.refreshAllDataConnections() or might there be something else?
The error message:
"We were unable to run the script. Please try again.
Runtime error: Line 5: Workbook.refreshAllDataConnections() is not supported in Power Automate.
clientRequestId: 566bd94c-36fd-4090-aa5c-cc47459f3b53"
Hi Yutao,
It's been almost a year! Where have we been with this issue? Refreshalldataconnections is key in script with Power Automate... How Microsoft can miss that! We need it please!
When you say "only Power BI connections", will you exclude Power Query in Excel? Both are in DAX languages and almost the same queries though...
AS OF MONDAY 15TH MAY I HAVE NO ERROR MESSAGE ANYMORE. HOWEVER THE REFRESH SIMPLY DOESN'T PERFORM A REFRESH. THE SCRIPT DOES WORK FINE WHEN IT IS NOT CALLED FROM POWER AUTOMATE.
New issue created: https://powerusers.microsoft.com/t5/Using-Connectors/Running-office-script-with-Workbook-refreshAllDataConnections/td-p/2153099
It seems that this has been resolved for a while, but a bug has come back for refreshing a PowerBI connection with workbook.refreshAllDataConnections
Workbook refreshAllDataConnections: There was an internal error while processing the request.
Apologize! This was indeed a regression on our side, and it should be fixed now. Please let us know if you are still having issues with refreshing Power BI data connections.
Thanks for your patience and support!
P.S.: Just to be clear, currently only the Power BI data connections can be refreshed through the workbook.refreshAllDataConnections() API. We have been working to support refreshing the other data connection types, but currently we don't have a concrete timeline to share yet. Thanks again for your patience and support!
The solutions proposed in the other thread do not work for me either. I think the command is debunk, but I do not know if Power is planning to fix the issue.
Hello,
Did you find any solution to this problem?
I'm getting the same issue, and i can't find the "Refresh Workbook" in Power Automate
I have just found another thread (that was also created yesterday) that refers to the same issue and has a proposed solution.
#1
WarrenBelz
146,518
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,692
Most Valuable Professional
Share
Report
All responses (
Answers (