Multiple Access files, one for each year.

[ContabilidadBI]

Hi!

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!

[v-yuezhe-msft]

@ContabilidadBI,

After you connect to each Access database file in Power BI Desktop, you can combine data of each query into a table using append query feature.

Regards,
Lydia