Free Preparation Discussions
MENU
Microsoft DP-600 Exam - Topic 3 Question 14 Discussion
Topic #: 3
You have a Microsoft Power Bl semantic model.
You need to identify any surrogate key columns in the model that have the Summarize By property set to a value other than to None. The solution must minimize effort.
What should you use?
To identify surrogate key columns with the 'Summarize By' property set to a value other than 'None,' the Best Practice Analyzer in Tabular Editor is the most efficient tool. The Best Practice Analyzer can analyze the entire model and provide a report on all columns that do not meet a specified best practice, such as having the 'Summarize By' property set correctly for surrogate key columns. Here's how you would proceed:
Open your Power BI model in Tabular Editor.
Go to the Advanced Scripting window.
Write or use an existing script that checks the 'Summarize By' property of each column.
Execute the script to get a report on the surrogate key columns that do not have their 'Summarize By' property set to 'None'.
You can then review and adjust the properties of the columns directly within the Tabular Editor.
Leonardo
10 months agoBerry
10 months agoFelicitas
10 months agoReena
10 months agoLaurene
10 months agoDulce
11 months agoLauran
11 months agoDaron
11 months agoYuriko
11 months agoFloyd
11 months agoPilar
11 months agoRosina
11 months agoCorazon
11 months agoThad
11 months agoMitsue
11 months agoCarrol
12 months agoLayla
12 months agoMelodie
2 years agoIola
2 years agoLynda
2 years agoTesha
2 years agoSol
2 years agoShay
2 years agoMaryrose
2 years agoMarjory
2 years agoSonia
2 years agoRebbecca
2 years agoPamela
2 years agoBlythe
2 years agoVirgie
2 years agoMerilyn
2 years agoDelila
2 years agoLuke
2 years agoJeniffer
2 years ago