Free Preparation Discussions
MENU
Microsoft DP-600 Exam - Topic 4 Question 10 Discussion
Topic #: 4
You have a Fabric tenant that contains a semantic model. The model contains 15 tables.
You need to programmatically change each column that ends in the word Key to meet the following requirements:
* Hide the column.
* Set Nullable to False.
* Set Summarize By to None
* Set Available in MDX to False.
* Mark the column as a key column.
What should you use?
Tabular Editor is an advanced tool for editing Tabular models outside of Power BI Desktop that allows you to script out changes and apply them across multiple columns or tables. To accomplish the task programmatically, you would:
Open the model in Tabular Editor.
Create an Advanced Script using C# to iterate over all tables and their respective columns.
Within the script, check if the column name ends with 'Key'.
For columns that meet the condition, set the properties accordingly: IsHidden = true, IsNullable = false, SummarizeBy = None, IsAvailableInMDX = false.
Additionally, mark the column as a key column.
Save the changes and deploy them back to the Fabric tenant.
Jill
10 months agoKeneth
10 months agoSalley
10 months agoRenea
10 months agoBuddy
11 months agoRosio
11 months agoFidelia
11 months agoLaquita
11 months agoCortney
11 months agoTrinidad
11 months agoDelpha
11 months agoFelix
11 months agoLatrice
11 months agoAmos
12 months agoLaurel
12 months agoAntonio
12 months agoOlene
2 years agoFannie
2 years agoSalena
2 years agoArminda
2 years agoPearlie
2 years agoAudry
2 years agoJacob
2 years agoArt
2 years agoCatalina
2 years agoLakeesha
2 years agoNohemi
2 years agoPearly
2 years ago