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
Blocker: Purview must scan Fabric Warehouse tables/columns or we will deprecate Purview
Purview + Fabric Warehouse ≠ enterprise‑ready governance. In our environment, the Fabric Warehouse is the system of record, but Purview can only catalog the warehouse container—not the tables or co...Joshua_Hernande2 hours agoNew MemberNew172Views1like1CommentPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes11 hours agoNew MemberNeed Clarification198Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v11 hours agoCommunity ChampionNeeds Votes36Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_11 hours agoNew MemberAbandoned27Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer13 hours agoAdvocate INew1.2KViews26likes2Comments