Forum Discussion
YashikaAgrawal
Post Patron
Post PatronSharepoint 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 ...
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!
Cookistador
Super User
Super UserHello,
You may connect to the SharePoint online data using SharePoint folder connector in Power BI Desktop, use the URL below and use organizational account method.
https://xxxxx.sharepoint.com/sites/<sitename>
Then you have to navigate to find your files (you can apply some filter to find more easily)