The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Use DAX Studio and run the DMV queries that reveal the internal IDs of the columns.
Use DAX Studio and run the DMV queries that reveal the internal IDs of the columns.