Forum Discussion
Power Query Editor not available for certain data connections
I have an excel file that users in a different department will be maintaining. Normally, I have built dashboards from files saved locally on my machine and prepped the data using the power query edit...
Thanks for your response! After looking more into this, the easiest way for our organization is to share files through Box.com. I don't see any dedicated connector for this and I've tried to connect using the "web" connector as shown below. Any file on our company's Box domain requires us to authenticate with a user name and password. It looks like the web connector doesnt support this as it stated "web.browsercontent currently supports only anonymous credentials".
Are you aware of any other way to use an excel file from a shared Box.com link as the data source in Power BI?