Showing results for 
Search instead for 
Did you mean: 
DLamarche Frequent Visitor
Frequent Visitor

Table fields sorted in ascending order!

Hi all. I'm new to all this BI business.

I am annoyed that all my fields in their tables in Model view are sorted in ascending order!!!

I didn't notice that in previous update.

When looking at the content of a table in Data view they are in the order they were in the .csv file

I like to have all my PK's at the top and the FK's immediately below. Now they are all over the shop!

Please anyone can explain if there is a option somewhere that can disable this (I have looked at the BI Options but there are so many, I didn't find any thing there).



Daniel L.


Sorted Fields.jpg

Super User
Super User

Re: Table fields sorted in ascending order!

@DLamarche I dont think there is any option to keep it in original sorting order, please put this as an idea on ideas forum if doesn't exists already.

Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.

Helpful resources

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 352 members 3,231 guests
Please welcome our newest community members: