Showing results for 
Search instead for 
Did you mean: 

Multiple Access files, one for each year.



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!

Moderator v-yuezhe-msft

Re: Multiple Access files, one for each year.


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.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.