Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |