Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
CloudMonkey
Post Prodigy
Post Prodigy

Power BI databases in two departments

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

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

 

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

 

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.