CODEWITHSUNDEEP
excelrefreshonedrivepowerquery
Pavan Sharma
Pavan Sharma

Reputation: 1

Excel refresh fails on OneDrive for Business

My excel workbook has the following solution implemented:

The solutions is to loop through multiple excel files on OneDrive into one. The excel has the following sheets:

Sheet1(Home Page): This has a table with a Key-Value pair. Key stands for the department and value is the path of the files on SharePoint

Home Sheet

Sheet2: This sheet has the data from all the files mentioned in the Sheet1.

This is implemented using the power query. I’ve created a custom function in Power query to loop through the files in the table mentioned above and get the data. The function to pull the data looks like this:

Function Definition to Get data

This solution works perfectly when I refresh from my excel desktop. When I place the file on one drive and open the same excel on the browser and hit refresh connection I see the following error:

Error when refreshing the connection of browser

Inputs on troubleshooting this error will be appreciated.

Upvotes: 0

Views: 1680

Answers (1)

teylyn
teylyn

Reputation: 35945

Excel Online does not support Power Query. You can have a data model and use pivot tables based on that data model in Excel Online, but you cannot refresh Power Queries or external data sources when you open the file in the browser.

Upvotes: 1

Related Questions