Data source from Excel to Sharepoint

[Anonymous]

Hey,

someone asked me to build a dashboard in Power BI. He wants to make connection with an excel sheet on sharepoint. I don't have and I don't get access to the sharepoint site. I only have the excel file on my local disk. 

How do I change the data source to his sharepoint when I want to deliver the dashboard?

greets 

[Vera_33]

Hi @Anonymous 

It is the same Excel file, right? you connect it in your local disk, and he wants to connect it in SharePoint which you don't have access. So you can ask him to change the Source

Current one is like

Excel.Workbook(File.Contents("C:\Users\XXXX.xlsx"))

Ask him to open the Excel file in SharePoint and opy the File path (File->Info) and delete the "?web=1", then change the Source to this, all the rest steps in the query are still working

Excel.Workbook(Web.Contents("https://company.sharepoint.com/sites/XXXX.xlsx"))