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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
tegar
Frequent Visitor

Power BI not showing column name in error message but the number

I have face an error ordering, I can handle how to resolve the ordering issue

but I can find which table and column that must fixed. The condition is I have a lot of table and column in my dataset

 

The error message said:

Cannot order 'Query1 (2557772)'[Column (4258683)] by [Index (4255204)] because at least one value in [Column (4258683)] has multiple distinct values in [Index (4255204)]. For example, you can sort [City] by [Region] because there is only one region for each city, but you cannot sort [Region] by [City] because there are multiple cities for each region.

 

is there any clue what column is pointed by that number

 

Thank you

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Use DAX Studio and run the DMV queries that reveal the internal IDs of the columns.

View solution in original post

2 REPLIES 2
tegar
Frequent Visitor

Thank a lot @lbendlin ,

now I can find the table and column

lbendlin
Super User
Super User

Use DAX Studio and run the DMV queries that reveal the internal IDs of the columns.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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