Box Status

Connect Folder in BOX to Excel via Power Query

Completed
Follow
New post
James Regent

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....

1

Comments

5 comments

Date Votes
  • Rona

    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! 

    1
    Comment actions Permalink
  • João de Melo Martins

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

    0
    Comment actions Permalink
  • Bouslah, Zitouni Zinedine

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

    0
    Comment actions Permalink
  • 住本 美由紀

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

    0
    Comment actions Permalink
  • James Regent

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

    0
    Comment actions Permalink

Please sign in to leave a comment.