Pivot Table using Dataflow Gen2

[jashfabric]

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.

[v-nikhilan-msft · Accepted solution]

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.

[jashfabric]

Thanks @v-nikhilan-msft for your quick help as always.