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

Dynamically find and filter header rows and promote them in Power Query

Dynamically find or filter a column header and promote them in power query is a very common requirement, specially if you are importing data from excel or pdfs for example.

Table of contents:

00:00 Describe the use case
01:00 Find the header row solution
03:00 Outro

Watch the tutorial:

Dynamically find header rows and promote them in Power Query
Was this helpful?
Previous Filter your Power Query columns by ANY CONDITION!
Next Avoid filtering issues in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents