3 Replies Latest reply on Aug 22, 2017 10:17 AM by Natalia Alvarez

"Invalid order-by expression" Tableau Desktop 9.2 Error

rayni.kertadjaja Feb 10, 2016 7:34 AM

Greetings,

We recently started getting this error after upgrading our Tableau Desktop version to 9.2.

We are realizing that it is in one specific Data Source - we have 5 in one workbook and only 1 is throwing this error. When we grabbed the SQL code and ran it directly against the database using SQL Studio and the like, the query runs just fine. Also, there is no ORDER BY clause in the code. We can also re-create the Data Source using the same tables and joins, and no error is generated.

For now, re-creating the Data Source is the workaround, but we were wondering if anyone else has run into this issue and know why it's occurring so that we can avoid it moving forward.

Thank you so much!

1. Re: "Invalid order-by expression" Tableau Desktop 9.2 Error

Dan Cory Feb 12, 2016 1:51 PM (in response to rayni.kertadjaja)

I'm sorry to hear you are having problems. Please contact Tableau Support so they can investigate.

Thanks,
Dan
Like Show 0 Likes(0)

Actions
2. Re: "Invalid order-by expression" Tableau Desktop 9.2 Error

Allyson Murphy Aug 10, 2017 12:28 PM (in response to rayni.kertadjaja)

I know this is an old question but maybe this will help someone else. I received the same error and it was because I had conflicting conditions assigned for a set I created.

For example, I wanted to group student majors into an "other" category if there were less than 10 students in any major. The problem arose because I set that condition but also unknowingly had the option selected to take the "Top 10" majors. This created conflicting group by conditions. Once I unchecked the "Top 10" option I no longer received the error.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
3. Re: "Invalid order-by expression" Tableau Desktop 9.2 Error

Natalia Alvarez Aug 22, 2017 10:17 AM (in response to Allyson Murphy)

Just wanted to thank you for this post =), I was having this problem and it never crossed y mind that the set could be causing it, this pointed me in the right direction.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

"Invalid order-by expression" Tableau Desktop 9.2 Error

1. Re: "Invalid order-by expression" Tableau Desktop 9.2 Error

2. Re: "Invalid order-by expression" Tableau Desktop 9.2 Error

3. Re: "Invalid order-by expression" Tableau Desktop 9.2 Error

Actions

More Like This