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