Forum Discussion
Solved
Merging multiple tables for yearly analysis
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 hea...
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.
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.