Power Platform Community Forum Thread Details

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.

Categories:

Using flows