Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change Source file from Network Drive to Sharepoint

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 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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