Is it possible to connect Power BI to a kdb database via ODBC driver?

3
votes

I am unable to connect to a kdb+ database in Power BI via the qodbc3 ODBC driver. After selecting Get Data -> Other -> ODBC and selecting a qodbc driver connection that I know works (used without issue by Tableau) I get stuck at the navigator window and there is no option to load a table.

Image of Power BI Navigator window with no option to load table

My concern is that kdb driver is not compatible with Power BI which is causing Power BI to not be able to find database tables.

1
odbcpowerbikdb
Whlist it might be possible, it'll probably be completely useless - KDB only have very limited support for SQL and i suspect that, since you're using Power BI, you'll require all sorts of SQL funkiness. – Manish Patel

1 Answers

2
votes

Although this option was not available back when the question was asked, today's solution to this problem would be to use the Simba ODBC Driver:

https://code.kx.com/q/interfaces/odbc-simba/

The primary target for this release is support for:

  • Tableau (certification compliance included)
  • PowerBI
  • Excel