Merging multiple tables for yearly analysis

[Ratso]

Hi, very new to this forum amd power bi as a whole so excuse me if this question has already been asked and answered.

I have multiple monthly spreadsheets with the exact same data set (column headers) that require merging and analysing over a years activity.

These are imported as linked tables from access.

My issue is... these are huge files and can exceed over 30000 rows so importing and merging them into one table takes an absolute age.

My question is... is there an alternative way of combining all the data without having to merge so I can still present a years activity in the visualisations?

[Kasper31383]

In this situation "Merge" is not the fuction you are looking for. With tables that have identical column headers but different data, say months or years, you want to use the "Append Queries". The way i see it is is merge tacks on new columns from another data set, and append stacks columns from another data set.

[Ratso]

Shame, as when imported and then add a new month, re-analysis the same data takes forever.

Anyway I thought as much. Might try a access query to merge them all (still takes an age)and link the result in power bi.

Many thanks.

[Idrissshatila · Accepted solution]

Hello @Ratso ,

if you want to have them all in one table, you need to merge, that's the only way to do it in power bi.

you can try doing it outside power bi on the data source level if this is applicable.