Forum Discussion
Using Power BI for multiple similar databases
Anonymous , My advice would be to consolidate these into a database with company id/tenant id in each table and have new keys to join with other tables. so that you can have one key join in power bi
Else , say you have Table A for 2 companies.
Bring both on them to power BI, Add company id column if not available at the source. Create concatenated key
key = [Company ID] & " - " [Table ID]
or
key = [Company ID] *1000000000 + [Table ID] // multiple to make sure table can not overlap with company if
Merge two table A in power query. Do the same for other tables
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Anonymous , My advice would be to consolidate these into a database with company id/tenant id in each table and have new keys to join with other tables. so that you can have one key join in power bi
Else , say you have Table A for 2 companies.
Bring both on them to power BI, Add company id column if not available at the source. Create concatenated key
key = [Company ID] & " - " [Table ID]
or
key = [Company ID] *1000000000 + [Table ID] // multiple to make sure table can not overlap with company if
Merge two table A in power query. Do the same for other tables
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Thanks Amitchandak. Going to test it.