Forum Discussion
Solved
Power Query Understanding
Hi I am excel 2013 user and trying to get to grips with Power Query. I have 3 files - say Jan, Feb and Mar in the same format. I import the Jan file and in power query apply transformations as re...
Peter, no, I mean Source step (very first one), usually that's default name for the first step.
If you click on it in formula bar will be something like
Change file name here and Enter.
If you'd like to combine all files into one table that's what Abiola1 suggested. But even if that's the purpose I'd suggest to play before with queries one by one, just for training purposes.
Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape your data as needed. It allows you to set up a query once and then reuse it with a simple refresh. It's also pretty powerful.
Based on questions I suspect Peter already knows that.