Cannot convert the value null to type table

1

Running on the pre Jan 2018 version of powerBI, worked with Dremio ODBC driver + Dremio 1.4.4
I upgraded PowerBi and now I can’t connect with error
We cannot convert the value null to type Table.

From the log
2018-01-25 15:13:35,060 [25959b5f-a22b-7469-f449-4dcd4eea0d00:foreman] INFO query.logger - {“queryId”:“25959b5f-a22b-7469-f449-4dcd4eea0d00”,“schema”:"",“queryText”:"[Get Catalogs] Catalog Filter: pattern: “%”\nescape: “\\”\n.",“start”:1516922015059,“finish”:1516922015060,“outcome”:“COMPLETED”,“username”:“dremio”,“commandDescription”:“metadata; direct”}
2018-01-25 15:13:35,100 [25959b60-786e-dccb-a404-7fa65094e500:foreman] INFO query.logger - {“queryId”:“25959b60-786e-dccb-a404-7fa65094e500”,“schema”:"",“queryText”:"[Get Columns] Catalog Filter: pattern: “DREMIO”\nescape: “\\”\n, Schema Filter: pattern: “Workspace”\nescape: “\\”\n, Table Filter pattern: “Clickstream\\_Analytic”\nescape: “\\”\n, Column Filter pattern: “%”\nescape: “\\”\n.",“start”:1516922015099,“finish”:1516922015100,“outcome”:“COMPLETED”,“username”:“dremio”,“commandDescription”:“metadata; direct”}

2

@rwidjaja we were able to reproduce this issue internally. Thanks for the information. We’ll reach out when we have an update.

3

@rwidjaja

The ODBC driver has been updated to fix this issue with the latest versions of Power BI. If you would like to use a newer build of Power BI, please head over to Dremio’s download page to get the latest ODBC driver.

Let us know if you run into any further issues. Thanks.

1 Like
4

@rwidjaja

Just a note. If you are doing a fresh install of PowerBI (as opposed to an upgrade from a previous Power BI version), you may encounter an issue where Power BI cannot find the Dremio Connector. This is a known issue we are tracking with the March build of Power BI. A workaround for this issue for now is to copy the Dremio.mez file from “C:\Users[USER]\Documents\Microsoft Power BI Desktop\Custom Connectors” to “C:\Users[USER]\Documents\Power BI Desktop\Custom Connectors”.

5

Thanks for that Josh.