Power BI connection with CrateDB

CrateDB
1

I am attempting to connect CrateDB to Power BI. I have followed the documentation online (Reports with CrateDB and Power BI Desktop — CrateDB: How-Tos), but I keep getting an error from Power BI saying “ODBC: ERROR [08001] timeout expired.”

Is there any documentation on how to fix this? I have not been able to find anything for this problem.

Thank you!

2
  • Did you add the DSN in Windows and does testing the DSN work?
  • Which CrateDB version are you using?

We have a guide in the documentation:

3

I am running the 4.7.1 version of crate.

I followed that guide when I originally setup the DSN using the ODBC Data Source Administrator. Testing the DSN through the administrator causes the configure window to stop responding and the test never finishes.

4

And you are using the newest PostgreSQL ODBC driver?
https://odbc.postgresql.org/ ?

5

Yes, I download the most recent version from the MSI directory they recommended.

6

Oh, actually I think you can just use the default PostgreSQL connection in PowerBI by now and don’t even have to setup a separate DSN:

image
image1196×484 52.4 KB

I will have to ask a buddy running Windows :slight_smile:

Testing the DSN through the administrator causes the configure window to stop responding and the test never finishes.

That definitely is strange. I just tried adding a DSN for a 4.7.1 cluster and it worked out of the box

1 Like
7

I was able to get it to work using the PostgreSQL database. Thank you for the recommendation!

2 Likes