Get Excel sheet data from SharePoint

[cham]

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

[MFelix · Accepted solution]

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]

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

[cham]

Thank you so much.