keep the same row order from power query to power bi table

[sidyahmed_pbix]

data from power query we have null, null from the first two rows in the column COMPT_GENERAL

data from the power bi table they have not the null.

Can someone helpe me to find solution please.

[Hariharan_R]

Hi @sidyahmed_pbix 

You have 2nd and 4th row is the first 2 rows in Power query. Power query just show sampling for 1000 rows so it will not show all the rows. You can use sort option to sort the columns. if you still want to see as same as Power query then you can create a Index column in Power Query and use that column for sort by column for COMPT_GENERAL.

Sort

Index Column

Sort by column

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[sidyahmed_pbix]

I need to export it after the cost the index column will appear in the csv file I tried this solution it works but the fact the index is found in the file after export poses a problem for the customer