New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

A practical and common case to practice table transformations in Power Query

How to transform pivot files into structured data for your analysis with Power BI.

Table of contents:

00:00 Intro
01:40 Get data
02:00 Prepare and unpivot the data

Watch the tutorial:

Unpivot complex data from Excel in Power Query
Was this helpful?
Previous Transpose, pivot or unpivot in Power Query?
Next How to fix the “Too many elements in the enumeration to complete…” pivot error in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents