Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
t1agow
Regular Visitor

Exporting column profile

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

 

t1agow_0-1636477483637.png


Thank you in advance

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @t1agow 

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

1.png

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.

View solution in original post

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

Hi @t1agow 

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

1.png

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
Super User
Super User

@t1agow Not aware of any way to do that.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.