Answer-first summary for fast verification
Answer: Tabular Editor
The correct answer is Tabular Editor. While Microsoft Power BI Desktop can be used to manually perform the required changes, it does not support programmatically making those changes. Tabular Editor, on the other hand, allows you to use C# scripts to automate such modifications. This includes setting properties like hiding columns, setting Nullable to False, specifying Summarize By options, marking columns as key columns, and setting Available in MDX to False. ALM Toolkit and DAX Studio do not provide the necessary functionality for this specific task.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a Fabric tenant administrator with a semantic model containing 15 tables, your task involves programmatically updating each column whose name ends with the word "Key." The updates required for these columns are:
• 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 tool or method should you use to accomplish this?
A
Microsoft Power BI Desktop
B
ALM Toolkit
C
Tabular Editor
D
DAX Studio
No comments yet.