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:
Share
Report
All responses (
Answers (
