The default Power BI semantic model for a Lakehouse is automatically synchronized with its corresponding SQL analytics endpoint. This endpoint is responsible for discovering tables in the Lakehouse and exposing them for querying and modeling. The setting to control whether new tables are automatically added to the default semantic model is located within the configuration of the SQL analytics endpoint. By navigating to the SQL analytics endpoint settings, you can disable the "Sync the default Power BI semantic model" option, which prevents any further automatic updates and stops new tables from appearing in the model.

A. the semantic model settings

These settings manage the model's internal structure (e.g., measures, relationships) but do not control the automatic discovery of new tables from its data source.

B. the Lakehouse1 settings

These settings pertain to the Lakehouse storage layer and its properties, not the synchronization behavior of the associated SQL endpoint or the default semantic model.

C. the workspace settings

Workspace settings apply to the entire workspace (e.g., permissions, Git integration) and do not offer granular control over individual artifacts like a specific default semantic model.

1. Microsoft Learn. (2024). Default Power BI semantic models in Microsoft Fabric. "The default semantic model stays in sync with the lakehouse by automatically initiating a sync whenever a new table is created in the lakehouse. You can disable this behavior in the settings of the SQL analytics endpoint."

Reference: Default Power BI semantic models in Microsoft Fabric

2. Microsoft Learn. (2024). SQL analytics endpoint. "In the SQL analytics endpoint

select Settings in the ribbon. ... Sync the default Power BI semantic model: This setting allows you to automatically sync objects from the SQL analytics endpoint to the default Power BI semantic model."

Reference: SQL analytics endpoint