I successfully created a derived view right joining two tables from SQL Server and MySQL on Denodo Virtual DataPort. I connected the Denodo through ODBC on Excel and loaded the derived view created to Excel
The Result produced was right joined i.e, all data from one table and matched data from another, Infact, the query that was sent to Denodo Virtual DataPort was a select of “Derived view”, Excel did not generate any join queries to Denodo.
But, if you are facing something similar [AFX_ODBC_CALL(::SQLColumns(...)) + Denodo ODBC Driver = Exception](https://community.denodo.com/answers/question/details?questionId=90670000000XcigAAC&title=AFX_ODBC_CALL%28%3A%3ASQLColumns%28...%29%29+%2B+Denodo+ODBC+Driver+%3D+Exception ) I would use the full VQL query like “select field1,Field2 from <denodo_view>” on the Power Query window rather than using graphical method.
Hope this helps!