I am thinking about two or three dynamic dimension tables in power query. As after importing the fresh csv scenario file, in case of some new technologies or Year may be added or deleted to the existing dimension tables, then will old reference csv file will cope these changes.
Scenario: Currently, I imported the csv files from folder and developed the queries (Dimension Tables and Fact Table based on it.
Difficulty: As I import new scenario with some changes (the dimension tables are not reflecting these changes). I have to manually make new tables and merging them with Fact Table). It might be the issue with my workflow.
Requirement: Is it possible that that after creating new csv file, the same dimensions could be retrieved (referenced) from New Master File?