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