Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
KristofferAJ
Helper III
Helper III

Powerquery to go directly to a specific row in my data (instead of promoting headers multiple times)

Hi!

I have in several of my reports (if not all) promoted headers in various steps especially in excel reports where my raw data starts in row 11 for instance...

 

I wonder if there is a certain way to have powerquery to look directly in to "row 11" instead of me promoting headers 10 times in my powerquery?

KristofferAJ_0-1674476158209.png

 

1 ACCEPTED SOLUTION
Riddhi_06
Frequent Visitor

To optimise this problem,
1) In the Power Query, In the Home Section->select Remove Top Rows 
You can select that option and enter 11 , and then top 11 rows will be deleted
2) Apply Promoted Headers now . By this, promoted header step is applied only once

View solution in original post

2 REPLIES 2
Riddhi_06
Frequent Visitor

To optimise this problem,
1) In the Power Query, In the Home Section->select Remove Top Rows 
You can select that option and enter 11 , and then top 11 rows will be deleted
2) Apply Promoted Headers now . By this, promoted header step is applied only once

simple and perfect, thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.