Forum Discussion

DAFONSO's avatar
DAFONSO
Frequent Visitor
3 years ago
Solved

Change the excel workbook data source for the folder

Hi I start my project with a single excel file and i'm building and adapt all in a power query. And now i will have the same file every month, so instend i copy past for the bigger excel file, I wa...
Data Protection
Need Help
Tips and Tricks
DAFONSO's avatar
DAFONSO
Frequent Visitor
3 years ago

Thank you very much some_bih 

Fix my problem in other way, I will try to explain 

1- I put all the excels files in a folder

2- Then i add the folder to my project

3- Then i go to the power query, press mouse right click, and go to "Advanced Editor" 

4- I copy all between "Let" and "In" and close 

5- I go to the file i want to replace my source and go to the same process, but instand copy, i paste between "Let" and "in"

6- Then a close and aplay, and for me work. I stay with all the work i made and power query and now i have my source in folder. 

 

Thank you for the help !