Forum Discussion
YashikaAgrawal
11 months agoPost Patron
Sharepoint issue
Hi Team, https://xxxx-my.sharepoint.com/:x:/r/personal/xxxxxxxxxxxx_com/Documents/Documents/Doc_contry.xlsx?d=w1b954b39842a414abdc7658469b0a534&csf=1&web=1&e=6lM8nM Above is the link ...
- 11 months ago
Hi YashikaAgrawal lets do this
Step 1: Open your excel file in Excel App
Step 2: Copy Path
From Excel App Click File -> Info -> Copy Path
Step 3: Get Data in Power BI Desktop
Get Data -> Web -> Pest here
Note: You need to remove ?web=1 after the name of the file
Now you are ready to load data from sharepoint.
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
MasonMA
11 months agoSuper User
I normally use SharePoint Folder connector.
For the link, paste the URL up to
https://xxxx-my.sharepoint.com/personal/.../Documents/Documents.
This will show you all files in that folder/library. Then filter down to Doc_contry.xlsx and expand into sheets/tables as usual.