Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Post Patron
11 months ago
Solved

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 ...
Need Help
  • Royel's avatar
    Royel
    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!

     

Cookistador's avatar
Cookistador
Super User
11 months ago

Hello,

 

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)