Forum Discussion
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 ...
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
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
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