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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
RAKESH1986
Helper II
Helper II

how to Skip top Row in Mquery

Hi,

 

could you help me how i can remove this top row.. i have multiple files and I want to remove top row to make next line as header.

RAKESH1986_0-1679048397705.png

 

thanks

rakesh

 

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

You are on the right track.

Anything you can do to a table, you can do to a table when it's a row in a list.  So if you create a test table in another query, you can get power query to generate the syntax for you.

In this case you want

Table.PromoteHeaders(_ , [PromoteAllScalars=true]))

 

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

You are on the right track.

Anything you can do to a table, you can do to a table when it's a row in a list.  So if you create a test table in another query, you can get power query to generate the syntax for you.

In this case you want

Table.PromoteHeaders(_ , [PromoteAllScalars=true]))

 

KeyurPatel14
Responsive Resident
Responsive Resident

Hi @RAKESH1986 ,
You can use Table.PromoteHeaders inside your function.
I hope this will solve your problem and if this helps you then please give it a kudos and accept it as a solution.
Thank you.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors