Forum Discussion
Use a shared excel workbook as a Data Source
Hi, Incipient
The most important thing is that you need to be granted access.
You need to have the correct access rights to the shared link and then please make sure that the credentials entered are correct and that the shared link has not expired.
Please refer to the information below for the procedure to connect data to PowerBI.
Connect Power BI to SharePoint List, SharePoint Folder, SharePoint Excel File
External Sharing in SharePoint Online
Loading Excel Files from Sharepoint
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the help Zeon,
The shared link cannot be added as a "sharepoint folder". I have read-only access to this excel document, and that's it. I don't have any acccess to the other organisations wider sharepoint, so I cannot add the folder using this method.
Hi, Incipient
It is not necessary to have access to the entire organization, it’s enough to access a single file
Try to get data from web.
https://www.youtube.com/watch?v=XuLnSYjmsJo
time stamp:5:37
https://www.youtube.com/watch?v=EdHKPkzgjL8
time stamp:4:35
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you for the reply. None of these apply to accessing a source from another organisation with a shared link.