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
Allow us to rename fabric data agents published to m365
If we use deployment pipelines to promote fabric data agents between dev, test/UAT, and prod fabric workspaces, we need to keep the name of the fabric agent the same in each workspace. If we want to ...PeterDaniels6 hours agoAdvocate IIINew183Views0likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen7 hours agoAdvocate INew294Views47likes2CommentsSupport Encrypted Sensitivity-Labeled Excel Files in Power Query
Description Currently, Power Query Online and Power Query in Excel are unable to access encrypted Excel files. Excel files with sensitivity types other than Public or Non-Business can be encrypted a...ewarstdhyjugkhi8 hours agoMicrosoft EmployeeNew22Views6likes0Comments