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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
zahirmohideen
Helper I
Helper I

Reports from more than one PBI semantic model

Hello All

 

How do I create reports using multiple power bi semantic models ?

Currently , I have a PBI semantic model from Oracle .
Have bunch of reports generated from the above semantic model .

 

Also , I have few other semantic models from MS SQL Server and Maria DB
Have few reports genrated from thse semantic models as well.

 

Now , the requirement is combine the reports from semantic models from Oracle , SQL Server and Maria DB
I don't want to recreate the semantic model ; instead reuse these models.

 

Please advise.

2 ACCEPTED SOLUTIONS
Tutu_in_YYC
Resident Rockstar
Resident Rockstar

Hey,
the only way (afaik) to connect multiple semantic models would be Chaining. Have a look at the following link.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#chaining

It may not be a straight forward implementation, but it will allow you to use data from different semantic models.

View solution in original post

Idrissshatila
Super User
Super User

Hello @zahirmohideen ,

 

yes you can connect to several semantic models using the following connector
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Idrissshatila
Super User
Super User

Hello @zahirmohideen ,

 

yes you can connect to several semantic models using the following connector
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Tutu_in_YYC
Resident Rockstar
Resident Rockstar

Hey,
the only way (afaik) to connect multiple semantic models would be Chaining. Have a look at the following link.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#chaining

It may not be a straight forward implementation, but it will allow you to use data from different semantic models.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors