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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
ezaidi
Helper I
Helper I

Adding another table from an existing semantic model in a hybrid model

I have a hybrid model power bi report where one of the data source points to an existing published semantic model (EDW). I did not originally bring all the tables from this semantic model into my power bi report. Now I found out that I was missing a table and decided to add that missing table from the same semantic model. After doing so, it added the table but under a different semantic model island (EDW 2). One thing i noticed is that original semantic model had a relationship between a table in the original model and the new added table however this newly added table does not have the relationship anymore and I cannot create it since they are two data model "Islands" and considered seperate. Is there a way to simply add another table to the existing semantic model without having to destroy everything and re-add all tables from the original semantic model including the new one.

1 ACCEPTED SOLUTION
Sergii24
Super User
Super User

Hi @ezaidi, in order to add tables to an existing semantic model, which is already in DirectQuery, instead of adding a new data source you need to work on the existing one.

Go to "Transform data" ->"Data source settings"

Sergii24_0-1730826323384.png

 

Select the data source you need and click "Change source..."

Sergii24_1-1730826541919.png

In the dialog box select the same data source you're already connected to, it will already have checked the tables that you're connected to. Simply select other table you need and click "load". It will bring the missing tables and create connections between them (if any present in the original semantic model).

Good luck with your project! 🙂

 

View solution in original post

2 REPLIES 2
Sergii24
Super User
Super User

Hi @ezaidi, in order to add tables to an existing semantic model, which is already in DirectQuery, instead of adding a new data source you need to work on the existing one.

Go to "Transform data" ->"Data source settings"

Sergii24_0-1730826323384.png

 

Select the data source you need and click "Change source..."

Sergii24_1-1730826541919.png

In the dialog box select the same data source you're already connected to, it will already have checked the tables that you're connected to. Simply select other table you need and click "load". It will bring the missing tables and create connections between them (if any present in the original semantic model).

Good luck with your project! 🙂

 

Wow this worked very well. I was breaking my head trying to figure this out. Thank you so much!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.