Forum Discussion

cham's avatar
cham
Icon for Post Patron rankPost Patron
7 years ago
Solved

Get Excel sheet data from SharePoint

Hi,

 

I want to get Excel data from SharePoint. How can I get that? 

 

I have Excel sheet uploaded into SharePoint. I choose get data and select web and enter the URL of the Excel sheet which is in the SharePoint. But it did not work.

 

Can I know the process of how can we get the Excel sheet data from SharePoint?

 

Regards,

Cham

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    7 years ago
    Hi cham,

    Did you made the copy of the Web link from sharepoint?

    If yes be aware that in the end of the file there are some characters you need to take out. Delete all characters after the xlsx should be after a "?".

    Regards,
    MFelix

3 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago
    Hi cham,

    Did you made the copy of the Web link from sharepoint?

    If yes be aware that in the end of the file there are some characters you need to take out. Delete all characters after the xlsx should be after a "?".

    Regards,
    MFelix
    • cham's avatar
      cham
      Icon for Post Patron rankPost Patron
      7 years ago

      Hi MFelix 

       

      I have published my Power BI report into Portal. And I have uploaded my Excel sheet into SharePoint.

       

      I got that excel sheet using "Get Data" and I select files and I conneceted to SharePoint and connect my excel sheet to Power BI.

       

      I want to know how can I connect that excel sheet with the Power BI report I uploaded. Because I want to put sheduled refresh whcih I can do the refersh automatically.

       

      When I publish the report into Portal in workbooks it show the sheet which I used for that report. But I want to connect SharePoint sheet with the Power BI report.

       

      Thanks,

      cham