Forum Discussion

ravsha85's avatar
ravsha85
Frequent Visitor
2 years ago
Solved

Fabric Default Sematic model

In a scenario where I create a Custom Sematic model from the sql end point (Default) and build reports on top of it, any changes to the Default tables (Table name change/Column name change) do not re...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, ravsha85 

    Thanks for Anonymous reply. Changing a table name in the default semantic model doesn’t automatically propagate to the downstream custom models. The reason for this behavior lies in how semantic models are constructed. The default semantic model is closely tied to the physical structure of the data (tables, columns, etc.). When you rename a table, it affects the underlying metadata, but the custom models don’t automatically adjust to this change. As a result, when you refresh the downstream models after a table name change, they encounter errors or don’t show the modified table model.

    Unfortunately, there isn’t a direct workaround within Fabric to automatically handle table name changes in custom models.
    Workaround:
    1. Manual Updates, whenever you rename a table in the default model, manually update your custom semantic model to reflect the new table name.
    2. Scheduled Refresh, set up a regular schedule for refreshing your custom models. This way, you can proactively manage any changes in the default model.
    Configure scheduled refresh - Power BI | Microsoft Learn
    3. Explore scripting or automation tools that can detect table name changes and apply them to your custom models.

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

ravsha85's avatar
ravsha85
Frequent Visitor
2 years ago

Thanks Anonymous  I see that when we add or delete a column from the default sematic model we can do a manual refresh to reflect it in the downstream Sematic models, However if I change a Table name Eg:Table1 to Table2 in my default and if I refresh the downstream models it errors out or dosent show the modified table model, Is this how it is?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, ravsha85 

Thanks for Anonymous reply. Changing a table name in the default semantic model doesn’t automatically propagate to the downstream custom models. The reason for this behavior lies in how semantic models are constructed. The default semantic model is closely tied to the physical structure of the data (tables, columns, etc.). When you rename a table, it affects the underlying metadata, but the custom models don’t automatically adjust to this change. As a result, when you refresh the downstream models after a table name change, they encounter errors or don’t show the modified table model.

Unfortunately, there isn’t a direct workaround within Fabric to automatically handle table name changes in custom models.
Workaround:
1. Manual Updates, whenever you rename a table in the default model, manually update your custom semantic model to reflect the new table name.
2. Scheduled Refresh, set up a regular schedule for refreshing your custom models. This way, you can proactively manage any changes in the default model.
Configure scheduled refresh - Power BI | Microsoft Learn
3. Explore scripting or automation tools that can detect table name changes and apply them to your custom models.

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum