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
So, pay attention. The Answer is C
"Previously we auto added all tables and views in the Warehouse to the default Power BI semantic model. Based on feedback, we have modified the default behavior to not automatically add tables and views to the default Power BI semantic model. This change will ensure the background sync will not get triggered. This will also disable some actions like "New Measure", "Create Report", "Analyze in Excel".
If you want to change this default behavior, you can:
Manually enable the Sync the default Power BI semantic model setting for each Warehouse or SQL analytics endpoint in the workspace. This will restart the background sync that will incur some consumption costs."
In your workspace you will have the Warehouse or SQL analytics endpoint and that is where you need to do the setting. So, I will go with A. If you go with C it is like saying you do the setting in that page but when you say A it points out where exactly in the page you need to do that setting.
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.
A small detail: Fabric has since changed this setting, and now it comes off by default.
If anything you would need to turn it on, but the place where you do that is still the same.
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.
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.
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
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.
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.
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.
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.
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
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.
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.
Sync the default Power BI semantic model : toggle on/off
Add objects from the warehouse to the default Power BI semantic model. Also, update the model with any new objects added to the warehouse. You can use this model to build reports faster with warehouse data. (in semantic model settings)
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
gfors
Highly Voted 11 months, 1 week agoManuelG00
9 months ago4f3a33d
4 months, 2 weeks agoPriyanka007
8 months, 3 weeks ago2fe10ed
Highly Voted 10 months, 1 week ago2fe10ed
10 months, 1 week agoJane5
Most Recent 3 days, 16 hours agoaks2304
1 week agogoldy29
1 month, 1 week agoMultiCloudIronMan
3 months, 1 week ago4f3a33d
4 months, 3 weeks agoAhmadpbi
7 months, 3 weeks agoPegooli
7 months, 4 weeks ago6d1de25
8 months agob6daab0
8 months, 4 weeks agoEvincible
9 months, 1 week agoDarioReymago
9 months ago[Removed]
9 months, 2 weeks agoPiyushT
9 months, 2 weeks ago282b85d
9 months, 2 weeks ago00e2928
10 months, 1 week agodp600
10 months, 2 weeks ago282b85d
9 months ago