Future-proof Sharepoint data source

[laurachung]

Hi all,

I'm looking for the best way to future-proof the connection to my Excel data source (which sits in Sharepoint) so that my links don't break when a folder name is changed or the Excel document is moved.

Is there a way to link Power BI to Document ID rather than a folder path so when documents are moved around these links don't break? Is there a different solution out there?

Not sure if this is helpful, but below is how it's currently pulling the data:

let
    Source = SharePoint.Files("https://companyname.sharepoint.com/personal/user_name/", [ApiVersion = 15]),
    #"All Project Costs xlsx_https://companyname.sharepoint.com/personal/user_name/Documents/Dashboarding/" = Source{[Name="All Project Costs.xlsx",#"Folder Path"="https://companyname.sharepoint.com/personal/user_name/Documents/Dashboarding/"]}[Content],
    #"Imported Excel" = Excel.Workbook(#"All Project Costs xlsx_https://companyname.sharepoint.com/personal/user_name/Documents/Dashboarding/"),
    Sheet1_Sheet = #"Imported Excel"{[Item="Sheet1",Kind="Sheet"]}[Data],

Thanks in advance.

[amitchandak · Accepted solution]

@laurachung , I doubt that is possible. But follow this way suggested by guyinacube so that can be modified easily.

https://www.youtube.com/watch?v=XIq5vN5oPf8

[laurachung]

Thanks for the reply Amit. 

Really great idea in the YouTube video - whilst it might be a bit time consuming to adapt to my specific problem, I think it's a good thing to put in practice for the root sharepoint folder.