How to Prevent Implicit Measures in Power BI

DP-600 By islever Editorial Last updated

Design and build semantic models

Short answer

AB Use Microsoft Power BI Desktop or Tabular Editor to set the DiscourageImplicitMeasures property on the semantic model.

Question

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

Key Takeaways

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.

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

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

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

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.

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.

Discussion 11 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 11

  1. XiltroX 👍 15
    Answer is A and B. You can prevent user-defined implicit measures by turning them off in PBI Desktop or Tabular Editor.
  2. a_51 👍 8
    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
  3. estrelle2008 👍 4
    Microsoft Power BI Desktop and Tabular Editor are your go-to for creating explicit measures.
  4. IshtarSQL 👍 3
    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):
  5. stilferx 👍 3
    IMHO, A & B. SSMS - big NO, Dax Studio - only for DAX programming.
Show 6 more comments
  1. Momoanwar 👍 3
    Ssms have nothing to do here and dax studio not alter model
  2. woliveiras 👍 2
    Just tabular editor and PowerBI can prevent user defined implicit measures
  3. 282b85d 👍 1
    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.
  4. goldy29 👍 1
    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.
  5. NRezgui 👍 1
    A. Microsoft Power BI Desktop B. Tabular Editor
  6. Rakesh16 👍 1
    A & B is the answer

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