Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I want to profile every single data table I have in my powerbi report. By data profile I mean somehting like this:
are there ways to make a data profile view in powerbi? dax measure or calculated columns?
alternatively, you can also recommend other data quality tools that can handle such tasks since I find it bit difficult to achieve this result in powerbi.
As far as I know, there is no elegant way. You may try Table functions.
HI,
could you please provide some examples on how to do with table functions in DAX?
Try the table Profile command.
Add a step based on the previous step or use the advanced editor
= Table.Profile(Source )
https://msdn.microsoft.com/en-us/query-bi/m/table-profile
https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/