Forum Discussion
Changing data source from a file to a folder
Hello everyone, After finishing my dashboard, my chief told me to change the data source of my file. Currently, my model imports a single .csv file as the data source. I need to modify this ...
You need to use the folder connector: https://learn.microsoft.com/en-us/power-query/connectors/folder
The good thing is, that when combine the files, you can keep the same transformations as your original CSV, and those will apply to the rest of the CSVs in the folder (provided they are in the same format).
Thank you for your response.
By doing this, the initial source is changing and all of my measures and calculated columns are erased.
Second problem, I created other tables starting from the source file, so do I need to create them again ? I also need to change all my visuals because the columns come from the other file.
With me initial question, I search to know if it's possible to avoid doing every step again.
