Skip to main content

Does anybody have a solution that works to connect a folder in BOX to excel using power query? I havent been able to find any legit solutions on here nor via any other trouble shooting sites.


I have a bunch of files in a folder in my organization's box drive that I want to connect to excel via power query. I try to copy the path of the folder via the box website and "connect via web" in excel with that URL, but it just previews the log-in page and does not pick up any of the files.


Ideally I would like it so that anybody can update the files in the box which would then automatically update the power query.


Any advice/solution would be a great help...there are lots of resources how to do this with onedrive/sharepoint but nothing for box....

Hi James, 


Welcome to Box Community and glad to help! 


We've created a new case and a member of our team will contact you through email, please keep an eye out. 


Thanks for posting! 


Hi Rona, Can I have this solution too? Thanks!


Hi Rona, Would it be possible to have this solution too? many thanks, Z.


Hi Rona,We are also facing the same problem. Please tell me the solution as well.


Hi all, unfortunately the solution was "there is no solution" because its third-party and told to ask Microsoft instead.


Reply