Automatically Add Lakehouse Tables to Default Semantic Model

DP-600 By islever Editorial Last updated

Design and build semantic models

Short answer

B From the settings pane of LH1, enable Sync the default Power BI semantic model to automatically add new tables.

Question

You have a Fabric tenant that contains a lakehouse named LH1. You create new tables in LH1. You need to ensure that the tables are added automatically to the default semantic model. What should you do?
  1. Disable Query Caching for the default semantic model.
  2. From the settings pane of LH1, enable Sync the default Power BI semantic model. Correct Answer
  3. Enable Refresh for the default semantic model.
  4. From the Endorsement and discovery settings of LH1, select Make discoverable.

Key Takeaways

The question tests configuring automatic schema synchronization for a lakehouse's default semantic model; the trap is confusing discovery or refresh settings with the specific sync toggle.

To automatically add new tables from a Fabric lakehouse to the default semantic model, you must enable the sync setting. This page explains why enabling 'Sync the default Power BI semantic model' is the correct configuration.

Common mistake: Choosing 'Make discoverable' (D) because it sounds like it makes tables visible, but it only affects data discovery and cataloging, not the semantic model schema.

Expert Analysis

Why the Answer Is Correct

Enabling the "Sync the default Power BI semantic model" setting in the lakehouse settings pane configures the system to automatically detect and add new tables and views to the default semantic model. This ensures that any schema changes or new objects in the lakehouse are reflected in the semantic model without manual intervention, satisfying the requirement in the question.

Why the Other Options Are Wrong

Disabling Query Caching (A) affects query performance but does not control schema synchronization or object addition. Enabling Refresh (C) updates the data within existing tables but does not add new tables to the model. Selecting Make discoverable (D) in the Endorsement and discovery settings promotes the lakehouse's visibility in the data catalog but does not modify the default semantic model's schema.

Community Comment Notes

Multiple commenters confirmed that the documentation explicitly supports Option B. As one user noted, you must "Manually enable the Sync the default Power BI semantic model setting that will automatically add objects to the semantic model." Another commenter provided the direct Learn documentation link validating this exact configuration step.

Official Reference

https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-default-semantic-model

This link opens the official vendor documentation in a new tab.

Exam Strategy

When a question asks about automatically adding lakehouse objects to a semantic model, look for the 'Sync' setting. Do not confuse data refresh, query caching, or catalog discoverability with schema synchronization.

Community Votes

B
100%

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

Discussion 3 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors, not of islever. The comments shown first are the most substantive of the thread — ranked by depth, community endorsement and relevance; expand the list below to read the rest.

From public community threads 3

  1. 4d8d76c 👍 3
    Manually enable the Sync the default Power BI semantic model setting that will automatically add objects to the semantic model. For more information, see Sync the default Power BI semantic model. Manually add objects to the semantic model. The auto detect experience determines any tables or views and opportunistically adds them. The manually detect option in the ribbon allows fine grained control of which object(s), such as tables and/or views, should be added to the default Power BI semantic model: Select all Filter for tables or views Select specific objects
  2. 403a308 👍 2 Answered B
    According to the documentation on Learn: "To add objects such as tables or views to the default Power BI semantic model, you have options: 1. Manually enable the Sync the default Power BI semantic model setting that will automatically add objects to the semantic model. For more information, see Sync the default Power BI semantic model. 2. Manually add objects to the semantic model. https://learn.microsoft.com/en-us/fabric/data-warehouse/default-power-bi-semantic-model
  3. MultiCloudIronMan 👍 2 Answered B
    B is correct

Reader comments & corrections

No reader corrections 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.

Fabric Deployment Pipeline Folder Structure Behavior

S-grade

Accessing OneLake Shortcuts in Fabric Notebooks

S-grade

Direct Lake Fallback to DirectQuery with Row-Level Security

S-grade

Displaying All Rows in Power BI Python Visuals

S-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