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
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.
thanks
rakesh
Solved! Go to Solution.
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]))
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]))
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
62 | |
18 | |
16 | |
13 |