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!

     

Royel's avatar
Royel
Super User
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!