Skip to main content

Power BI

Completed

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.

Administrator on 10 Jun 2021 18:51:09

Column profiling and quality data can be copied and pasted from Power Query via the GUI or right click options today.

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

Herry Bel 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

Power BI User 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

Stretcharm 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

Power BI Ideas Admin 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

Paul Southerland 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.