How to Prevent Implicit Measures in Power BI

Design and build semantic models
Answer Correct answer: A, B — Use Microsoft Power BI Desktop or Tabular Editor to set the DiscourageImplicitMeasures property on the semantic model.

You have a Fabric tenant that contains a semantic model. You need to prevent report creators from populating visuals by using implicit measures. What are two tools that you can use to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.

  1. Microsoft Power BI Desktop Correct Answer
  2. Tabular Editor Correct Answer
  3. Microsoft SQL Server Management Studio (SSMS)
  4. DAX Studio

Community Votes

AB
100%

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

Community Insight

This question tests your knowledge of semantic model configuration properties, specifically identifying which tools can set the DiscourageImplicitMeasures flag.

Discover the two tools capable of preventing report creators from using implicit measures in a Microsoft Fabric semantic model. This guide confirms Power BI Desktop and Tabular Editor as the correct solutions.

Choosing DAX Studio or SSMS, assuming they can alter model properties, whereas they are strictly for querying/diagnostics and database management respectively.

Community Discussion (11 comments)

XiltroX 👍 15 Selected: AB
Answer is A and B. You can prevent user-defined implicit measures by turning them off in PBI Desktop or Tabular Editor.
a_51 👍 8 Selected: AB
A,B turn enable discourage implicit measure for the semantic model. https://learn.microsoft.com/en-us/power-bi/transform-model/model-explorer#discourage-implicit-measures https://docs.tabulareditor.com/api/TabularEditor.TOMWrapper.Model.html#TabularEditor_TOMWrapper_Model_DiscourageImplicitMeasures
goldy29 👍 1 Selected: AB
Only Power BI Desktop and Tabular Editor allow for schema-level changes to a Power BI dataset, so you can add, modify, or delete tables, columns, and relationships in the data model.
NRezgui 👍 1 Selected: AB
A. Microsoft Power BI Desktop B. Tabular Editor
Rakesh16 👍 1 Selected: AB
A & B is the answer
woliveiras 👍 2 Selected: AB
Just tabular editor and PowerBI can prevent user defined implicit measures
282b85d 👍 1 Selected: AB
A. Microsoft Power BI Desktop: Power BI Desktop allows you to control and manage how measures are used within your reports. By carefully defining and using explicit measures within your data model, you can ensure that report creators use only these predefined measures instead of creating implicit measures automatically. B. Tabular Editor: Tabular Editor is a powerful tool for managing and editing Power BI and Analysis Services tabular models. It allows you to enforce best practices, such as disabling implicit measures, by modifying the model's properties and ensuring that only explicit measures are available for use in reports.
stilferx 👍 3
IMHO, A & B. SSMS - big NO, Dax Studio - only for DAX programming.
estrelle2008 👍 4 Selected: AB
Microsoft Power BI Desktop and Tabular Editor are your go-to for creating explicit measures.
Momoanwar 👍 3 Selected: AB
Ssms have nothing to do here and dax studio not alter model
IshtarSQL 👍 3 Selected: AB
AB: To prevent report creators from populating visuals using implicit measures in a Power BI semantic model within a Fabric tenant, you can utilize the following tools: 1. Tabular Editor: 2. Power BI Desktop (Data Model View):

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

Power BI Desktop and Tabular Editor both provide interfaces to modify the DiscourageImplicitMeasures property of a semantic model. In Power BI Desktop, this is done via the Model explorer by selecting "Discourage implicit measures". In Tabular Editor, this is achieved by setting the DiscourageImplicitMeasures property to true on the Model object. Both tools effectively prevent report creators from auto-summarizing columns, forcing the use of explicit measures.

Why the Other Options Are Wrong

Microsoft SQL Server Management Studio (SSMS) is primarily for relational database management and while it can connect to Analysis Services, it is not the appropriate tool for configuring Power BI semantic model properties like discouraging implicit measures. DAX Studio is a diagnostic and query optimization tool used to trace and analyze DAX queries; it cannot modify model metadata or properties.

Community Comment Notes

The community strongly agrees on Power BI Desktop and Tabular Editor, noting that they allow "enable discourage implicit measure for the semantic model" as a_51 pointed out. Others correctly observed that "SSMS - big NO" and "Dax Studio not alter model", reinforcing that these tools lack the capability to change model-level properties.

Official Reference

https://learn.microsoft.com/en-us/power-bi/transform-model/model-explorer#discourage-implicit-measures

Exam Strategy

When asked about tools that modify semantic model properties, eliminate diagnostic or querying tools like DAX Studio and database management tools like SSMS. Focus on semantic model authoring tools like Power BI Desktop and Tabular Editor.

Related Analysis

You have a Fabric tenant that contains a lakehouse named Lak

S-Grade

You need to create a data loading pattern for a Type 1 slowl

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