Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / Dynamically find and filter header rows and promote them in Power Query
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

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

Posted
Updated
ByRuth Pozuelo Martinez

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?

Reader Interactions

Let us know your thoughts...

Table of Contents