Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |