I’m able to create a successful test connection. And I can even list the different tables. But I can’t execute any queries (syntax error) and even selecting an entire table does not work (“Object reference not set to an instance of an object.”)
I’m able to import tables into Tableau without issues.
@cklar Dremio has released a new ODBC driver and Power Pivot is supported. It is available here:
The syntax error usually is related to not setting the Quoting property to BRACKET. By default the Dremio driver treats double-quotes as the quoting character but Power Pivot uses square brackets. Please configure your Dremio DSN to add Quoting=BRACKET to the Advanced Properties.
Note that in the updated driver, encryption is enabled by default and can be toggled in the Advanced Properties tab.