BenchMark Quizzes by MDFT Pro

You work for MDFT Pro and use their Fabric tenant that contains a Microsoft Power BI report. You are exploring a new semantic model.

You need to display the following column statistics:

Which Power Query function should you run?

Choose the correct answer from the options below.

Explanations for each answer:

Table.Schema is incorrect. Table.Schema returns the structure of a table including column names and data types, but does not provide statistical information about the data within those columns.
Table.Profile is correct.
Table.View is incorrect. Table.View is used to create custom views of tables with modified behavior, but does not provide statistical analysis of the column data.
Table.FuzzyGroup is incorrect. Table.FuzzyGroup is used for grouping similar values using fuzzy matching algorithms, not for calculating column statistics.

Learn more about the Table.Profile function:

Practice Exam