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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
amolt
Resolver I
Resolver I

How can I update the PowerBi semantic model schema when I make changes to the source structure?

Hi, 

In Microsoft Fabric, I initially created a schema in a warehouse.

I use this warehouse to create a report using PowerBi Desktop. From this point on, I can no longer see the schema changes I make in the warehouse. If I add a column to a dw table, I can't see it in the PowerBI model.
Is this normal?
How can I update the PowerBi semantic model schema when I make changes to the source structure?
What's more, even when I delete the table from the semantic model, and add it again, I get back exactly the same structure as before, without the new column...

 

Thanks for your help

1 ACCEPTED SOLUTION

Hi @Greg_Deckler , 

Thanks for your answer.

I don't know if this will solve the problem, but in the "Home" tab of dw Fabric, in the "Settings" menu, you can change the default model settings.

amolt_0-1708448530620.png

 

 

And activate automatic synchro.

amolt_1-1708448562441.png

 


I've yet to test it.

View solution in original post

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@amolt Been struggling with this as well. The default model was supposed to be able to sync with the lakehouse, keeping it up-to-date with changes made. Used to be turned on by default. Now it seems like the default is the opposite, it is turned off. But now I can't even find the option any longer to keep the two in sync. Frustrating.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg_Deckler , 

Thanks for your answer.

I don't know if this will solve the problem, but in the "Home" tab of dw Fabric, in the "Settings" menu, you can change the default model settings.

amolt_0-1708448530620.png

 

 

And activate automatic synchro.

amolt_1-1708448562441.png

 


I've yet to test it.

@amolt Ah, I found it again. You go to the settings for the default SQL Analytics Endpoint and enable syncing the default semantic model.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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