Forum Discussion
Accessing Excel file on OneDrive for Power BI report
I've seen multiple tutorials and video's where accessing and Excel file on OneDrive for Business for a Power BI report seems to work fine. I must be missing something. I use the Get Data / sel...
v-deddai1-msft
Community Support
Community SupportHi dherman201 ,
It's a limitation now. The new version of the Web connector (currently available in Power BI Desktop) automatically creates a Web.BrowserContents query. Such queries currently only support anonymous authentication. In other words, the new Web connector can't be used to connect to a source that requires non-anonymous authentication. This limitation applies to the Web.BrowserContents function, regardless of the host environment.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for the info. So, it appears this works if you use the SharePoint connector rather than the web connector. When I tried, it prompted me to log in in Power BI.
However, I found this worked in my environment but did not work for another user in their environment. I'm assuming it would be dependent on the security set up within the SharePoint site?
It seems however you need to connect to the root of the SharePoint site or at least to the root of your one drive.
so for example I had to use
so for example I had to use
my.sharepoint.com/personal/myname_mycompany_com/
I'm not really sure what this URL means as to the whole sharepoint implementation. What is the best practice? If a user has access to their One Drive what would limit them to access from Power BI. I belive the error posted is "Access is forbidden"
I'm not really sure what this URL means as to the whole sharepoint implementation. What is the best practice? If a user has access to their One Drive what would limit them to access from Power BI. I belive the error posted is "Access is forbidden"
Thanks for your help. Trying to sort this out.