Skip to main content
Microsoft Idea

Power BI

Needs Votes

add Table.Profile() columns to dataflow entity view

Vote (6) Share
Fred Kaffenberger's profile image

Fred Kaffenberger on 03 Dec 2020 14:22:57

When you expand the entity, you can currently see field name and data type.

I'd like to see these added as columns: Min, Max, Average, StandardDeviation, Count, NullCount, DistinctCount.
With Table.Profile(), all work with text or number except Average and StandardDeviation.

This would help creators with data validation and would help consumers with details about the entity before loading.

Comments (1)
Fred Kaffenberger's profile image Profile Picture

Nick Appleby on 03 Mar 2022 09:28:53

RE: add Table.Profile() columns to dataflow entity view

#RADACAD post has the details around additional agg'sCreate a Profiling Report in Power BI: Give the End User Information about the Data - RADACADWould be great to get an EmptyString count also