If you're sharing or collaborating with other intermediate Power Query users and source data from large files, you don't want to send those large files back and forth if it doesn't change. Basically your transformation or analysis file is the changing item and when you share that file, the source for the data is going to change; hence you might get the dreaded DataSource.error message. There's a couple ways to deal with this error like replacing the source in the query steps and then refreshing. In this video, it'll cover a way to use the parameter feature in Power Query to set up a path to the source and reference that path in the query step.

SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

Excel Training ➜ https://www.exceltraining101.com/p/tr...

Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

If you find these videos useful and want to support my channel go to https://www.buymeacoffee.com/dough

#excel
#msexcel
#doughexcel

~~~~~~~~~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~~~~~~~~~