Forum Discussion
Importing an Excel sheet from Teams/Sharepoint
Hi All, I've recently been tasked with importing some data into PBI from Teams which I haven't done for about 6 months. The last time I copied the link from sharepoint, deleted the query after the .xlsx and removed the /:x:/r from the middle of the link and it all worked. This time it isn't working, does anyone know what I'm doing wrong?
Michael_Bass , I remember I opened excel in the excel desktop app and then got the url and delete a part of it and used -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
or
2 Replies
- amitchandak
Super User
Michael_Bass , I remember I opened excel in the excel desktop app and then got the url and delete a part of it and used -https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-onedrive-business-links
or
Thanks amitchandak that's worked, I appreciate the help!
