topic Re: Pivot Table using Dataflow Gen2 in Dataflow

Pivot Table using Dataflow Gen2

jashfabric — Fri, 03 May 2024 04:43:11 GMT

Hey all

Can we create a pivot table using Dataflow Gen2 as we do in Excel? I want the exact Pivot table, but not able to acheive it. Any examples would help.

Appreciate yoru help.

Re: Pivot Table using Dataflow Gen2

Anonymous — Fri, 03 May 2024 06:59:21 GMT

Hi jashfabric
Thanks for using Fabric Community.

A Pivot Table has different layouts. Typically the "compact" view is something that goes beyond just a pivot table and goes into the visualization aspect. Power Query matches the "tabular view" layout that a pivot table can have in Excel. We do recommend using other tools, such as pivot tables or Power BI, for analytical purposes as Power Query is primarily aimed to be a Data Preparation tool.

Below is the documentation on how to pivot columns in Power Query:

Pivot columns - Power Query | Microsoft Learn

Hope this helps. Please let me know if you have any further questions.

Re: Pivot Table using Dataflow Gen2

jashfabric — Mon, 06 May 2024 09:58:09 GMT

Thanks Anonymous for your quick help as always.