Power Query Refreshes in Excel Web

Occasional Visitor

As I understand it, Refreshing Queries in Excel Online is now a possibility, provided the data sources are within the workbook. This was great news because it made aggregations of tables easy. However, when I go to refresh online, I get an error saying this workbook is not in the cloud despite it being in OneDrive.


The specific error is:

Power Query queries in Excel for the Web can’t be refreshed in workbooks saved in a third-party cloud location.


How do I solve this? The document is in OneDrive and all queries are referring to a source table in the workbook.



0 Replies