Forum Discussion
Required help
I have a dataset where first 6 records are not useful. I wanted to instruct PowerBI to use 7th row as header. How would i do that?
Can someone please help me.
Hi Bansi008,
In Query Editor, remove the first six rows, then use the top row (originally your seventh row) as your headers. You might have to remove some default Applied Steps from the right pane first.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
1 Reply
Hi Bansi008,
In Query Editor, remove the first six rows, then use the top row (originally your seventh row) as your headers. You might have to remove some default Applied Steps from the right pane first.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.