Skip to main content

Power BI

New

Export Column Profiles as a Table

Vote (44) Share
Matt Allington's profile image

Matt Allington on 11 Apr 2019 04:25:36

my customers love the new column profiling feature in Power Query. With the GA today, it is even better. One thing I have been asked for a few times now is the ability to export the column profile data as the result of a query. Ideally this could be exported to Excel for further investigation, or simply return it to ta table in Power BI for further investigation.

Comments (5)
Matt Allington's profile image Profile Picture

235019fa 1b0e-4d8b-ab24-aea09ea12fd6 on 06 Jul 2020 00:01:17

RE: Export Column Profiles as a Table

I think the way to keeping the 2650 or any inkjet printer cheerful and printing for quite a while is to utilize it all the time. Sitting inert for a considerable length of time at a time isn't useful for inkjets. Run a couple of pages through it in any event once every week, if not more frequently, and you'll keep it fit as a fiddle.
https://www.hptechnicalsupportphonenumber.com/blog/how-to-fix-hp-printer-error-code-49-4c02/

Matt Allington's profile image Profile Picture

0582aef6 0638-47f7-acf7-a6b27b5163fc on 05 Jul 2020 23:56:13

RE: Export Column Profiles as a Table

Canon printer You need to follow some kind of techniques like you can upgrade your version for working in the analytics and Machine, I Would like the best Canon Printer. There are any issues regarding printer error problem and setup problem-solve with customer support.
https://www.canonprintersupport247.com/canon-printer-setup/

Matt Allington's profile image Profile Picture

7de092fd c230-46fe-8055-bab7f47faa87 on 05 Jul 2020 23:47:50

RE: Export Column Profiles as a Table

You can use the Table.Profile () M function to get a profile that can be exported

Matt Allington's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:46:24

RE: Export Column Profiles as a Table

I only disagree about the output for the query. I want to input the query into a power bi data flow as GUI generated m code and write it to Azure Data Lake gen 2 same as the other queries. Then I can read it from anywhere.

Matt Allington's profile image Profile Picture

b0bb1b2a 76f0-4c00-8264-3ddab3e1d0ac on 05 Jul 2020 23:46:21

RE: Export Column Profiles as a Table

The ability to export Column Profiling metrics for Six Sigma and Performance Excellence initiatives would be a great way to guide and measure the actual gains from business process improvement projects and inform greater improvement efforts.