You’re offline. This is a read only version of the page.
9
I have created a Spreadsheet that gets data from an Internal Website, which is working fine, and data is refreshing. However I am wanting to incorporate this data into PowerBi, and arrange for it to be refreshed every hour, i've used Automate and added in a script to refresh data sources.
I've therefore saved the data within OneDrive, and created a recurrence flow, which then goes and runs the script. Which on the face of things, the flow says its worked however it doesn't.
I'm presuming that, its because Excel Online doesn't appear to like PowerQuery Refresh - and was wondering if anyone else has overcome such a hurdle previously.
If you have larger datasets & need to do simpler auto-updates on a recurring basis without opening the workbook, then you may want to check this template for batch updating & creating table rows:
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
