I have prepared a chart in Excel, connected using Power Query. In Power Query I have used oData connection to get a SharePoint Online List to get the data.

Now I save the Excel into Office 365 Document library.

If I refresh the data in Excel File then I am able to refresh data in Excel file. But I am not able to refresh the data in Excel Online. I am getting the following error,

We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh: Query - ABC

Is it possible to refresh data in Excel Online directly? Or any other way to refresh data in Excel Online?


Clearest answer I've found to this is here:

SharePoint doesn't support refreshing Power Query data sources at the present time. Although it's true that SharePoint and SharePoint Online don't currently support Power Query refreshes, the error message you get is related to not being able to refresh from the Data Model which is something SharePoint Online isn't able to do (on-premise SharePoint can).

protected by Community May 10 '17 at 15:25

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.