Forum Discussion
Power Query beginner question
HotChilli, thank you for your help. I eventually got a book and worked it out.
Community ChampionPower Query has the set of Applied Steps on the right hand side.
So, if you select Query1 (in the list of queries on the left hand side) , click on the Source step in Applied Steps, you should see in the formula bar a power query instruction which includes a filepath. Edit the filepath to be the location and name of the new file, and select the tick icon to confirm.
If the file is similar format with the same transforms, it should work OK.
----
Longer term, you might want to investigate using Get files from folder, and I would encourage you to work through a tutorial from microsoft powerbi site.
I tried your suggestion. I ended up with one sheet showing my original transformed data and another sheet showing the new, untransformed data. I copied the path, then just clicked out into open space, then loaded clicked Close and Load. This may not have worked because I didn’t know what you meant by “Select the tick icon to confirm”.
Regarding the Get Files from Folder option, I tried that prior to my post. The data in the file didn’t display in the Power Query editor. What did display was the name of the file, its extension, dates accessed, modified, and created, as well as the path. I used the Get Files from Workbook option because it was suggested to me by way of a response to a question I posted on My Online Training Hub's YouTube channel. If there is a specific tutorial on the PowerBI site to assist me, I like to check it out. Can you send the link?