I am going to create a data model which will have as the main table, one that is in 5 different Access files (one for each year data). They all have the same data structure of course and are in the same folder, it is just one file for each year. What is the best way to integrate them in 1 table with all the rows in Power BI so all the data transformations in the query editor will aply to all the data?
Thank you very much!! and sorry for my english.
Merry Christmas BTW!