Exporting column profile

[t1agow]

Hello everybody

Is that possible export all column profile at the same time?
Or do something like that?

I have table with 68 columns and I want to have this data (not all columns, but some of them) to compare when I clean the database

Thank you in advance

[v-rzhou-msft · Accepted solution]

Hi @t1agow 

I think you can try Table.Profile() function to get data from column profile in Power Query.

For reference: Create a Profiling Report in Power BI: Give the End User Information about the Data

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@t1agow Not aware of any way to do that.