7 METHODS to change source data location in Power Query | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★

★ Check out the blog post ★

★ About this video ★
Maybe you’ve built some queries in a test environment, and now it’s time to start using them for real. The obvious question arises: How to change source data location in Power Query?

0:00 Introduction
0:47 #1 Edit the source step
1:24 #2 Change the M code (formula bar)
1:45 #3 Change the M code (advanced editor)
2:09 #4 Data source settings
2:59 #5 Worksheet cell parameters
4:02 #6 Queries as parameters
4:34 #7 Power Query parameters
5:21 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★

★ Where to find Excel Off The Grid ★

#MsExcel #PowerQuery

[IvanCortinas_ES]

Excellent tutorial Mark. Thank you for such interesting content.

[mojtabareyhani]

Thanks a lot for your great tutorial.
Please create a video about how can create a flexible and reusable power query structure.

[kenmcmillan]

Thanks for the review Mark. My goodness, you have an incredibly clear camera!! Super sharp image!!

[sankethingne]

i wasted my a lot of time to find how to do this and this video within minutes directed to the point
😊

[jamesregan]

This is a perfect tutorial on changing the data source, after seeing 6 this one is direct to the point on changing data sources thank you.

[iankr]

These are all sources on a network share. It's a whole lot more fun if you're working with files stored on SharePoint, as companies are increasingly doing these days. Microsoft needs to make this much simpler!

[rigobertogarcia]

Great, great and more great Mark. Thank you very much for your contributions that feed our professional development. Thank you

[abuibrahim]

Thanks for tutorial sir
Please answer my question sir
What happened if I just rename the data source?
Is there changing the data and all the stepped I run in my power query?

[chriswall]

The excel named range can be adapted to pick up where file is saved and pass that to PQ. Then data can be in a subfolder called data relative to where the PQ file is ... Your methods all rely on hard coded paths. We break them into serverpath projectpath and filename parameters then concatenate them in PQ for greater flexibility.

[Sumanth]

Excellent content.. Good for beginners.. however the one I switched to using the most is under the Data ribbon > Get data > Data source settings. I don't have to go to power query window.

[therevenant]

Will these methods work if the issue is that other users cannot refresh the file? For example, I have 3 different data sources driving queries in a tool that I need to make usable for my employees. But none of them can refresh the file because the filepath has my userid in the filepath. So would I need to create a named cell that contains a filepath that adjusts that userid section of the path depending on who is doing the refreshing, or am I overthinking it?

[ajayrathod]

How to create this for two excel files, one is for source excel file and other is mapping excel file

[dean.beenaliza]

How about changing the source from another workbook to the data in the current workbook which has the same raw data table?

[ximox]

Hi Mark, how you recommed to use a path_parameter of folder to open at once all the file in that folder.

[YWang-gryp]

I followed exactly your steps, but when I go to data source seting, the "Change Source" button is greyed out, please advise, thanks a lot!

[dianat]

In my power query, the source is a separate excel worksheet. How can I change it to an online source? I need it to connect directly to a salesforce report. I haven’t been able to find out how to change this. Please please please let me know if theres a way!! Thank youuu!

[arungupta]

Hi, What if the Source File is used for the Merge + Append + Group transformations with other files . but now the source file got Updated with Lots of Data and it is difficult to update the file and we need to replace the source file alltogether, with new file with same name, without affecting the previous output. Can it be done with "Parameters" Setting or something else. Please Advise.

[Regina.Falange]

What if I want to change the source from an external file's table to a table inside my document?