You work for MDFT Pro, a well-known training agency, and 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?
Table.FuzzyGroup is incorrect. Table.FuzzyGroup performs fuzzy grouping, not statistical profiling.
Table.Profile is correct. Table.Profile returns column statistics including count, average, null count, distinct count, and standard deviation.
Table.view is incorrect. Table.view creates a filtered view without statistical calculations.
Table.schema is incorrect. Table.schema returns table structure metadata, not statistical summaries.