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

      Greetings,

       

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

      tableauerror_invalidorderby.jpg

      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!