Microsoft
DP-600 · Question #90
You have a Fabric tenant that contains a Microsoft Power BI report. You are exploring a new semantic model. You need to display the following column statistics: - Count - Average - Null count…
The correct answer is D. Table.Profile. The Table.Profile function provides an overview of the data in a table, including basic statistics like count, average, null count, distinct count, and standard deviation for numerical columns.
Submitted by joshua94· Apr 18, 2026Explore and analyze data
Question
You have a Fabric tenant that contains a Microsoft Power BI report. You are exploring a new semantic model. You need to display the following column statistics:
- Count
- Average
- Null count
- Distinct count
- Standard deviation
Which Power Query function should you run?
Options
- ATable.schema
- BTable.view
- CTable.FuzzyGroup
- DTable.Profile
How the community answered
(29 responses)- A3% (1)
- C3% (1)
- D93% (27)
Explanation
The Table.Profile function provides an overview of the data in a table, including basic statistics like count, average, null count, distinct count, and standard deviation for numerical columns.
Topics
#Power Query#Data Profiling#Column Statistics#Semantic Model
Community Discussion
No community discussion yet for this question.