CODEWITHSUNDEEP
powerbiquestdb
Nick Woolmer
Nick Woolmer

Reputation: 141

Can I use PowerBI with QuestDB?

I use PowerBI for exploratory data anaylsis and saw that QuestDB has Postgres connector support, but encountered some errors using it when I tried connecting the two.

enter image description here

Is PowerBI supported over Postgres wire or is there some other way I can use it with QuestDB?

Upvotes: 2

Views: 70

Answers (1)

Nick Woolmer
Nick Woolmer

Reputation: 141

EDIT: QuestDB now works with Power BI using the PostgreSQL connector: https://questdb.com/docs/third-party-tools/powerbi/

The below solution is still an option if preferred.



QuestDB does support Postgres wire protocol, but some third party applications try to use Postgres-specific features that aren't supported.

As a workaround, you can use the Web connector against the /exp endpoint, which allows you to run queries and export a CSV. For example, with a url like:

http://localhost:9000/exp?query=tables()

enter image description here

QuestDB has a Grafana plugin, and users report that other tools such as Azure Data Studio and JetBrains IDEs work.

Upvotes: 3

Related Questions