Change Source file from Network Drive to Sharepoint

[Anonymous]

Hi ,

I have a report build based on excel from network file server. I want to move the report to be based on Sharepoint.  The file sturcture is the same. How can I change the source in M query from Network Drive to Sharepoint url  ?

regards

Anbu 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can edit the RUL here to change the file path.

let
    Source = Excel.Workbook(Web.Contents("https://xxxx.xxxxx.com/sites/asnew/Shared%20Documents/Book1.xlsx"), null, true),
    Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data]
in
    Table1_Table