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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
sidyahmed_pbix
Frequent Visitor

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

sidyahmed_pbix_0-1656085343763.png

 

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

 

sidyahmed_pbix_1-1656085385304.png

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

 

Can someone helpe me to find solution please.

 

2 REPLIES 2
Hariharan_R
Solution Sage
Solution Sage

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

Hariharan_R_0-1656086213832.png

 

Index Column

Hariharan_R_1-1656086237254.png

 

Sort by column

Hariharan_R_2-1656086272708.png

 

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


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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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