Forum Discussion
Solved
Changing Excel sheet name in Power Query
Hi Everyone I have a Power Query data source that is drawing multiple excel files from the same folder. I need to add to the files in the folder to capture the latest monthly sales data for my or...
MichaelF1 The code change needed is to the Transform File function.
It should look similar to this:
This is where you can modify it as Vijay_A_Verma helpfully suggested.
MichaelF1 The code change needed is to the Transform File function.
It should look similar to this:
This is where you can modify it as Vijay_A_Verma helpfully suggested.
Hi, AlexisOlson
Yes, that's what I need. Thank you, I didn't know to look in the Transform File!
Thanks v much for your help
Michael