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.
7 Comments
- pdsoutherland2New MemberThe 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.
- pbiideas1New MemberI 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.
- phil_stretch_arNew MemberYou can use the Table.Profile () M function to get a profile that can be exported
- syama5490New MemberCanon 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/
- belherryNew MemberI 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/
- nishalitNew Member
Column profiling and quality data can be copied and pasted from Power Query via the GUI or right click options today.
- fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Matrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente15 minutes agoRegular VisitorNew74Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2116 minutes agoNew MemberNew14Views4likes1CommentFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb18 minutes agoNew MemberNew26Views1like1CommentTable Visual — Rounded Corners and Pill-Style Cell Backgrounds
Add the option to display cell background colors as rounded rectangles or pill-shaped labels within the native Table visual. Currently, applying a background color fills the entire cell with a solid...urawizardharry26 minutes agoRegular VisitorNew22Views1like1CommentBulk changing column names in Visualizations Pane
We often use raw/api column names or measures with a set nomenclature to be consistent and to keep track of them but we do not want to display these names in the visuals. Currently we have to change ...vishal14019726 minutes agoFrequent VisitorNew12Views1like1Comment