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 Change column names dynamically with parameters in Power BI
Next Dynamically remove columns that contain a specific word in the header in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents