Forum Discussion
Connecting to Excel on Sharepoint - getting browser error
One trick I uses is to connect the sharepoint shortcut to onedrive:
This lets you find and connect to the sheet you want through your file explorer.
Later change the file name in the data source settings to the url to pull from sharepoint.
Https://example.sharepoint.com/sites/example%20site
Use the %20 where spaces are in thr file folder names are.
Hi hellomark
Not sure if you get the correct URL for the file. A method to get the URL is via selecting the file, going to Details > More Details > Path. Click the copy icon to copy the file path then use the Web connector to connect to it. This will work.
In addition, which version of Power BI Desktop are you using? If you still have problem with above method, please update your Power BI Desktop to the latest version then try it again. Let us know if you still have questions.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi hellomark
Not sure if you get the correct URL for the file. A method to get the URL is via selecting the file, going to Details > More Details > Path. Click the copy icon to copy the file path then use the Web connector to connect to it. This will work.
In addition, which version of Power BI Desktop are you using? If you still have problem with above method, please update your Power BI Desktop to the latest version then try it again. Let us know if you still have questions.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!