Skip to main content

Power BI

New

Remove default semantic model

Vote (29) Share
Frithjof Vassbø's profile image

Frithjof Vassbø on 27 Mar 2024 05:41:04

  • The default semantic model takes up unnecessary real estate in the Fabric workspace. If I don't want the default semantic model, I should be able to remove it.


  • The default semantic model is confusing, because you cannot modify it through the default semantic model item, instead you need to look inside the SQL Analytics Endpoint to modify the default semantic model.


  • The default semantic model doesn't support server timings and some other features in DAX studio. For this, you need to create a new custom semantic model.


  • The default semantic model cannot be manually refreshed, so you cannot clear it's cache for performance testing. For this, you need to create a new custom semantic model.


Bottom line: the default semantic model is annoying and should be removed.

Comments (6)
Frithjof Vassbø's profile image Profile Picture

Arjan Fraaij on 21 Jan 2025 11:27:14

RE: Remove default semantic model

Also using a notebook to create a Lakehouse based on import sempy.fabric as fabricIt creates default semantic models outside the normal structure of Lakehouse creation like--- LakehouseName----- SemanticModelNameExample:--- Lakehouse1---- Lakehouse1When you now delete the Lakehouse also the default semantic model is deleted.To somekind of reason the sempy.fabric.create_lakehouse does create the default Semanticmodel not in this structure and when deleting the Lakehouse the semanticmodel still exists.Needing to delete the workspace to remove it.No issue for development but can not be done in production workspaces.With sempy.fabric it also was possible to end with multiple semanticmodels having the same name, seeing in my development workspace:Lakehouse3Lakehouse3Lakehouse3

Frithjof Vassbø's profile image Profile Picture

Chris Wright on 13 Nov 2024 14:23:08

RE: Remove default semantic model

Microsoft, please get rid of this unnecessary use of resources

Frithjof Vassbø's profile image Profile Picture

Thomas Evans on 13 Nov 2024 12:55:36

RE: Remove default semantic model

Thanks for posting! Microsoft, please get rid of this unnecessary use of resources.

Frithjof Vassbø's profile image Profile Picture

Jefferson Bauer on 13 Nov 2024 12:33:25

RE: Remove default semantic model

Thanks for posting this. I don't like the default semantic model either. We never use it. We create a new one every time from the lakehouse. I wish they would remove the L shape grouping with the default semantic model and SQL Analytics endpoint as well. It takes up too much real-estate and dirties up an otherwise beautiful organization of items. There are other ways to get to the SQL analytics endpoint. I say get rid of the L shape grouping and access the SQL analytics endpoint through the ... "more options". Or it isn't unreasonable to just access the SQL analytics endpoint using the toggle dropdown in the upper right corner of the lakehouse. Many of us are using SSMS anyway.Or allow users to configure the L grouping option on or off. To us it is very annoying to have many lakehouses in a workspace and it take up this much space.

Frithjof Vassbø's profile image Profile Picture

Jonathan Boarman on 25 Oct 2024 15:21:25

RE: Remove default semantic model

Agreed ... this consumes un-necessary resources and is contributing to global warming. And that is a bad thing. Don't do bad things Microsoft! :)

Frithjof Vassbø's profile image Profile Picture

Vladimir Kvaratshelya on 18 Apr 2024 18:30:51

RE: Remove default semantic model

Remove default semantic model