Data Profiling similar to what is offered in tools like Talend Data Preparation Tool. You can select a column for example and it gives you quick insights on (Invalid data, empty rows, summary statistics on the column, a frequency distribution of all value sin the column, if the column is an integer data field it will give a nice box plot summarizing the data distribution)
7 Comments
- We’re glad to let you know that this feature is now Generally Available. Please refer to the Power BI Desktop April release announcement for more details: powerbi.microsoft.com/en-us/blog/power-bi-d.. Thanks for your feedback!
- Really waiting for data profiling capabilities in PBI - will make it a complete tool
- related: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32763295-profiling-column-values
- 1) on the hope that powerbi can become a core tool for ml/ai projets too, 2) and now that we have filtering & sort also for pbi data view, this would be terrific/must have tool see inspectors capabilities from azure ml workbench ideally, have this data profile capability both on powerquery view (sample, during data prep) & powerbi data view (final, full data, fast), should be the same backend supporting both IMO, allowing for much fast improvements
- There is already some features in M command Table.Profile See also https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/
- This would be an incredibly helpful tool!
- Status added:Completed
