Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Please can you tell me how to link Power BI databases between 2 different departments? (e.g. the sales data is compiled in a finance department Power BI database and then a marketing database somehow receives this information as a table in their own database)
Currently the marketing department has to manually log into the finance department database, export a table visualisation to excel and then save the excel file in their own Power BI database.
Thanks,
CM
Solved! Go to Solution.
Hi @CloudMonkey,
In my opinion, you can import these databases to same power bi report, then create a transfer table to link two different source.(if current not contains these tables)
For example:
database 1: 'Item A','Item B'
database 2: 'item a','item b'
Transfer table:
Index, Desc A, Desc B 1, 'Item A','item a' 2, 'Item B','item b'
After finish create above transfer table, you can use it to link two database.(relationships: 'Desc A 'to database AND tables, 'Desc B' to database B tables)
Regards,
Xiaoxin Sheng
Hi @CloudMonkey,
In my opinion, you can import these databases to same power bi report, then create a transfer table to link two different source.(if current not contains these tables)
For example:
database 1: 'Item A','Item B'
database 2: 'item a','item b'
Transfer table:
Index, Desc A, Desc B 1, 'Item A','item a' 2, 'Item B','item b'
After finish create above transfer table, you can use it to link two database.(relationships: 'Desc A 'to database AND tables, 'Desc B' to database B tables)
Regards,
Xiaoxin Sheng
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |