We are using a legacy ERP system, that runs on a proprietary database engine.
An ODBC driver specifically for this database engine is available.
The ODBC connection is set up and we use Power BI to connect to that DSN.
After selecting the ODBC option we select the DSN and hit OK.
At the Navigoter screeen we see the database tables.
But when we select a table we receive the following error:
DataSource.Error: ODBC: ERROR [HY000] SQLPrepare: Drive not capable -- ORDER BY is not supported
Fair enough, we use a legacy database and a proprietary ODBC driver, so we should not use ORDER BY in the query.
But we are only at the stage to show a preview of the data.
Is it a setting in Power BI by which we can control if an 'order by' is used in the query to retrieve the data preview?
And also at the Query Editor.
Does the issue happen to all tables or specific report?
When you select the ODBC DSN, please write a query to return the table data to see if the same issue occurs?
Best Regards,Qiuyun Yu