Forum Discussion
since error is during refresh in online
We are currently facing an issue during dataset refresh in Power BI Service. Although the refresh is completing successfully, multiple warnings related to column sorting are appearing.
This issue was not occurring earlier, and the dashboard was refreshing without any warnings.
Could you please help us understand the root cause and how to resolve it?
Refresh completed with warnings.
- Column reference to '<oii>monthEnd</oii>' in table '<oii>MTBF_emergency-data</oii>' cannot be used with a variation '<oii>Date</oii>' because it does not have any.
- Cannot order '<oii>Table (12304)</oii>'[<oii>Column (3133138)</oii>] by [<oii>Column (3071437)</oii>] because at least one value in [<oii>Column (3133138)</oii>] has multiple distinct values in [<oii>Column (3071437)</oii>]. 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.
- Cannot order '<oii>Table (12304)</oii>'[<oii>Column (3262554)</oii>] by [<oii>Date (12354)</oii>] because at least one value in [<oii>Column (3262554)</oii>] has multiple distinct values in [<oii>Date (12354)</oii>]. 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.
- Cannot order '<oii>Table (3496803)</oii>'[<oii>date day (3497565)</oii>] by [<oii>Date (3497539)</oii>] because at least one value in [<oii>date day (3497565)</oii>] has multiple distinct values in [<oii>Date (3497539)</oii>]. 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.
- Cannot order '<oii>Table (3786608)</oii>'[<oii>week start mmdd (3787716)</oii>] by [<oii>week start (3787710)</oii>] because at least one value in [<oii>week start mmdd (3787716)</oii>] has multiple distinct values in [<oii>week start (3787710)</oii>]. 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.
- Cannot order '<oii>Table (3996874)</oii>'[<oii>date day (3998294)</oii>] by [<oii>Date (3998268)</oii>] because at least one value in [<oii>date day (3998294)</oii>] has multiple distinct values in [<oii>Date (3998268)</oii>]. 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.
- Cannot order '<oii>incidents (3019951)</oii>'[<oii>Status (3190955)</oii>] by [<oii>status sort (3160850)</oii>] because at least one value in [<oii>Status (3190955)</oii>] has multiple distinct values in [<oii>status sort (3160850)</oii>]. 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.
6 Replies
- SaiTejaTalasila
Super User
Hi San_7566895852 ,
It looks like the warnings are caused by invalid Sort by Column relationships in your Power BI model-some columns don't have a unique one-to-one mapping with their sort columns, or they're stored as text instead of proper Date/Time types. To fix them, check the data types, remove or correct the "Sort by Column" settings, and use a proper Date or mapping table to enforce valid ordering.
Thanks,
Sai Teja
- cengizhanarslan
Super User
Sort by Column configurations in your model have broken because the sorting column no longer has a unique one-to-one mapping with the column being sorted.
- AnonymousNot applicable
hi San_7566895852 ,
I would take a moment to thank cengizhanarslan and SaiTejaTalasila , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions
- San_7566895852Regular Visitor
Sure I will check and try to fix the issue based on your solution and update you
- AnonymousNot applicable
Hi San_7566895852 ,
Could you please confirm if you had a chance to review the information shared.
Let us know if it helped or if you need any further assistance.
We are happy to help.
- AnonymousNot applicable
Hi San_7566895852 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you