Export Column Profiles as a Table
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.
You can use the Table.Profile() M function to get a profile that can be exported
Daniel Bartley commented
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.
Paul Southerland commented
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.