Prevent Automatic Table Sync to Default Semantic Model in Fabric

Design and build semantic models
Answer Correct answer: A — Configure the SQL analytics endpoint settings to disable automatic sync of new tables to the default semantic model.

You have a Fabric tenant that contains a lakehouse named Lakehouse1. You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse. What should you configure?

  1. the SQL analytics endpoint settings Correct Answer
  2. the semantic model settings
  3. the workspace settings
  4. the Lakehouse1 settings

Community Votes

A
63%
B
37%

63% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

The default Power BI semantic model sync setting is located in the SQL analytics endpoint settings, not the lakehouse or semantic model settings, which is a common trap.

To prevent new tables from automatically syncing to the default semantic model in a Microsoft Fabric lakehouse, you must configure the SQL analytics endpoint settings. This page explains why this specific location controls the synchronization behavior.

Choosing the semantic model settings (B) or Lakehouse settings (D) because it seems logical to configure the target object, but the sync toggle is actually on the SQL analytics endpoint.

Community Discussion (22 comments)

gfors 👍 25
Read the question carefully: "You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse." The answer is in the article https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models but "Sync the default Power BI semantic model". The correct answer is there A
2fe10ed 👍 13 Selected: A
I've confirmed it on Fabric, and the correct answer is A. To change this setting, you need to open the settings of either the SQL analytics endpoint object of a Lakehouse or the warehouse object of a warehouse.
Jane5 👍 1 Selected: A
i have checked on Fabric
aks2304 👍 1 Selected: B
The correct answer is: B. the semantic model settings Explanation: To prevent new tables added to a lakehouse (e.g., Lakehouse1) from being automatically included in the default semantic model, you need to configure the semantic model settings. The semantic model is responsible for defining how data is exposed for reporting and analytics. By adjusting these settings, you can control whether new tables are automatically added to the model or require manual inclusion.
goldy29 👍 1 Selected: B
you need to modify the semantic model settings for the lake house. This allows you to control whether new tables are automatically included in the model.
MultiCloudIronMan 👍 2 Selected: A
Based on the information from the Microsoft Fabric documentation, it appears that configuring the SQL analytics endpoint settings is indeed the correct approach to prevent new tables added to Lakehouse1 from being automatically included in the default semantic model
4f3a33d 👍 5 Selected: A
Tested in Fabric; go to > SQL Endpoint > ... > Settings > Default Power BI semantic model > Sync the default Power BI semantic model > On | Off Add objects from the lakehouse to the default Power BI semantic model. Also, update the model with any new objects added to the lakehouse. You can use this model to build reports faster with lakehouse data.
Ahmadpbi 👍 1
A is correct .. SQL analytics endpoint settings.. I checked this option in a workspace I have. It seems off by default. It shows like below: Sync the default Power BI semantic model Off Add objects from the lakehouse to the default Power BI semantic model. Also, update the model with any new objects added to the lakehouse. You can use this model to build reports faster with lakehouse data.
Pegooli 👍 2
I'm going for B it's chat GPT answer LOL Access the Lakehouse Settings: Navigate to the Lakehouse1 in your Fabric tenant. Go to the settings or properties of the Lakehouse1. Locate the Semantic Model Configuration: Find the option related to the semantic model or data modeling settings. Disable Automatic Addition: Look for a setting that mentions the automatic addition of new tables to the semantic model. Disable this setting to prevent new tables from being automatically added.
6d1de25 👍 3 Selected: B
B is correct
b6daab0 👍 1
Tested in Fabric. It's A.
Evincible 👍 7 Selected: B
To prevent new tables added to Lakehouse1 from being automatically added to the default semantic model of the lakehouse, you need to configure the semantic model settings. The semantic model in a Fabric lakehouse represents the logical data model and defines how the data in the lakehouse should be interpreted and used. By default, when new tables are added to the lakehouse, they may be automatically added to the semantic model as well. To prevent this behavior and maintain more control over the contents of the semantic model, you need to adjust the semantic model settings. This allows you to configure the lakehouse to not automatically include new tables in the semantic model, requiring you to manually add them if desired.
[Removed] 👍 3
You should configure B. the semantic model settings to prevent new tables from being automatically added to the default semantic model of Lakehouse1
PiyushT 👍 3 Selected: B
Open the lakehouse in Microsoft Fabric. Navigate to the semantic model section. Open the settings for the default semantic model. Look for an option that controls the automatic inclusion of new tables. This might be labeled as "auto-update" or something similar. Disable or adjust this setting to prevent automatic inclusion
282b85d 👍 3 Selected: B
Explanation: In Microsoft Fabric, the default behavior is to include new tables in the semantic model automatically. To control this behavior and ensure that new tables are not added automatically, you need to adjust the settings related to the semantic model.
00e2928 👍 3
correct answer is B By default, the semantic model in a lakehouse is set to automatically include new tables, but you can disable this behavior by modifying the semantic model settings. Specifically, you need to navigate to the semantic model settings for the lakehouse and find the option to disable the automatic inclusion of new tables.
dp600 👍 3 Selected: A
"Manually enable the Sync the default Power BI semantic model setting for each Warehouse or SQL analytics endpoint in the workspace"
Nefirs 👍 6 Selected: A
A - check here: https://learn.microsoft.com/en-us/fabric/data-warehouse/default-power-bi-semantic-model#add-or-remove-objects-to-the-default-power-bi-semantic-model
pppppppppie 👍 4
it should be SQL end point setting.
earlqq 👍 4
A is correct, there is "Sync the default Power BI semantic model" setting in sql endpoint.
clux 👍 3 Selected: D
I think you do that in the Warehouse setting, there is not a Warehouse option but since a warehouse is created when you create the Lakehouse, it should be option D https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models#sync-the-default-power-bi-semantic-model
luiruipu 👍 3
Correct answer is C. https://learn.microsoft.com/en-us/fabric/data-warehouse/semantic-models

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

The correct answer is A because the synchronization setting for the default Power BI semantic model is located within the SQL analytics endpoint settings. By navigating to the SQL analytics endpoint and turning off the "Sync the default Power BI semantic model" option, you prevent new tables added to the lakehouse from automatically populating the default semantic model. This architectural placement allows the endpoint to govern how data is exposed for reporting.

Why the Other Options Are Wrong

Option B is incorrect because the semantic model settings do not contain the toggle for automatic synchronization of new tables; they only control properties of the model itself. Option C is incorrect because workspace settings govern workspace-level configurations like access and storage, not specific lakehouse semantic model sync behaviors. Option D is incorrect because the lakehouse settings do not expose the default semantic model sync toggle; this control is specifically delegated to its SQL analytics endpoint.

Community Comment Notes

Multiple community members confirmed Option A by testing in the Fabric UI, noting that the sync setting is found under the SQL endpoint. As user 2fe10ed noted, "you need to open the settings of either the SQL analytics endpoint object". Another user provided the exact UI path: "SQL Endpoint >... > Settings > Default Power BI semantic model". Users who chose Option B mistakenly assumed the setting would logically reside on the semantic model object itself.

Official Reference

https://learn.microsoft.com/en-us/fabric/data-warehouse/default-power-bi-semantic-model

Exam Strategy

When managing default semantic models in Fabric, remember that the synchronization toggle is tied to the SQL analytics endpoint, not the lakehouse or semantic model directly. Look for settings related to the SQL endpoint when dealing with automatic model updates.

Related Analysis

You are analyzing the data in a Fabric notebook. You have a

A-Grade

You have a Fabric tenant that contains a complex semantic mo

A-Grade

You have a Fabric notebook that has the Python code and outp

A-Grade

Practice All DP-600 Questions

Access 115 questions with complete answers and detailed explanations.

View Full DP-600 Practice Test →

← Back to DP-600 Study Guide