Merging many tables into one?

Power BI Data Model
1

What are the potential pitfalls of merging many tables into a single table? What are the best practices and things to look out for when merging many tables into a single table?

2

Hi @powerbideveloper,

Just to confirm merging (adding columns) or appending (adding rows)?

3

Hi @Melissa! Merging not appending.

4

Hi @powerbideveloper,

Thanks. When performing multiple merges, I think the two most common issues are:

  • unwanted/unintended duplication of records and
  • performance issues (making sure your table has a primary key can improve performance)

If you have an option to outsource these merges to SQL or whatever you have in the backend, I would start there. Some articles you might like to review:

I hope this is helpful.

2 Likes