Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Transferring data source but cannot add more than one data source

I would like to get the data from other path as i changed the file place, but after clicking data source setting, it seems that only  one data source can be changed. However, in the Power Query, i have several data source need to changed. how could i deal with this issue?

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Do not connect to individual files. Connect to folders (ideally Sharepoint Folders)  and then handle the file addressing as part of your Power Query code.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, Anonymous ;

    You could set the data source.

    or connect the folder.

     


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Anonymous ;

    Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.