title: Excel refresh fails on OneDrive for Business
body: <p>My excel workbook has the following solution implemented:</p>
  
  <p>The solutions is to loop through multiple excel files on OneDrive into one. The excel has the following sheets:</p>
  
  <blockquote>
    <p>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</p>
  </blockquote>
  
  <p><img src="https://i.stack.imgur.com/RBN0v.png" alt="Home Sheet"></p>
  
  <blockquote>
    <p>Sheet2: This sheet has the data from all the files mentioned in the Sheet1.</p>
  </blockquote>
  
  <p>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:</p>
  
  <p><img src="https://i.stack.imgur.com/sOxrk.png" alt="Function Definition to Get data"></p>
  
  <p>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:</p>
  
  <p><img src="https://i.stack.imgur.com/JaThg.png" alt="Error when refreshing the connection of browser"></p>
  
  <p>Inputs on troubleshooting this error will be appreciated.</p>