Change data source from local folder to sharepoint

[Syndicate_Admin]

Good morning, I have to change the source of my data to stop reading it from my local disk and read it from sharepoint. The idea is to use the same excel file that I use from my local disk, but published in a share point. I know I have to go to the power query and in advanced editor change the source. My question is how much the code is modified and some recommendations in this regard.

Thank you

[christinepayton]

Hi there, I made videos for how to swap from local sources to SharePoint for files and folders. The technique is slightly different. 

Here's how to swap file sources:

https://youtu.be/2HZ8l23RXnc

And folder sources:

https://youtu.be/5SFxHffE2TA 

[Ena]

Glad I found this video. I believe I watched it before but was thrown off by "json". But watching it today, I saw the note that it would work for an Excel file as well. Three months after, you resolved my frustration! Thank you/

[christinepayton]

ha sorry, that's good feedback - I should just stick to Excel for everything, I just grabbed whatever sample data I had lying around when I did this. >.< 

[Idrissshatila]

Hello @Syndicate_Admin ,

it's all in the documentation here https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin