Forum Discussion

haniizz's avatar
haniizz
Icon for Helper II rankHelper II
2 years ago
Solved

Change source from local Excel to SharePoint Site

Dear Community heroes:   I need to change my source from a local Excel to SharePoint site Excel.. I tried to follow the answers in this community but I didn't get it. any one can help me with this ...
Need Help
  • christinepayton's avatar
    christinepayton
    2 years ago

    I have a couple video tutorials that walk through how to do this. It depends on if you're using the file connector or the folder connector. 

     

    Move file source to SharePoint folder: https://youtu.be/5SFxHffE2TA

    Move file source for a single file to SharePoint: https://youtu.be/wHzrBkbUBgM 

     

    You basically just update the path its looking for in the query, the trick is getting the correct path to use. 

haniizz's avatar
haniizz
Icon for Helper II rankHelper II
2 years ago

Hi aj1973 
thank you for your prompt response
Actually I'm not good in M language, if you can help me I'll appreciate, the copy and paste I feel like its going to take forever 

aj1973's avatar
aj1973
Icon for Community Champion rankCommunity Champion
2 years ago

If you can send me a sample of your excel file and the M code that you've applied to import it then it would be faster and easier. Thanks.