Accessing dremio from Excel Powerpivot


Trying to read some data from Dremio into Excel Powerpivot.

Server=XX.XX.XX.XX;Port=31010;Provider=MSDASQL.1;User ID=XX;DSN=Dremio Connector; PWD=XX;AUTHENTICATIONTYPE=Basic Authentication;CONNECTIONTYPE=Direct;HOST=XX

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.

Any help would be appreciated.

Hi - just pushing this to the top.