cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
WillemC Regular Visitor
Regular Visitor

Connect to InterBase database

I got an Interbase server on a VMware.

On my local machine, I created a System-DSN, connecting to the Interbase database through the InterBase ODBC driver.

The ODBC connection is succesful.

 

Next I'm trying to connect to this InterBase in Power BI.

I'm selecting Get Data --> Other --> ODBC --> select my Data source name (DSN)

Next I'm asked for the credentials, so I filled these out.

Then the Navigator Pane shows up.

I see ODBC (dsn=myserver)[1] --> MyServer but nothing underneath it.

 

If I right click on MyServer and select 'load' then three fields are loaded. e.g. Description, Kind, Name

Can Power Bi succesful create to a Interbase database? Or am I doing something wrong?

I don't have any experience with InterBase databases, so perhaps I'm doing something wrong.

 

odbc1.JPG

 

 odbc2.JPG

 

 

odbc3.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
WillemC Regular Visitor
Regular Visitor

Re: Connect to InterBase database

Today I did an different approach.

In my SQL Server I've attached the InterBase database as a Linked Server.

So I create some views in another database in SQL server, and then connect PowerBI to this SQL server.

 

I think that this is giving me a more stable and powerfull solution.

I can combine different databases more easily and SQL server shows the table structure better (since PowerBi doesn't show the tables from the interbase at all).

4 REPLIES 4
v-ljerr-msft Super Contributor
Super Contributor

Re: Connect to InterBase database

Hi @WillemC,


Can Power Bi succesful create to a Interbase database? Or am I doing something wrong?

I don't have any experience with InterBase databases, so perhaps I'm doing something wrong.


According to your description above, Power BI has connected to your InterBase through the ODBC driver successfully without any error. As there is no any data returned to Power BI, there could be some configuration issue on the source side. I would suggest you also post this issue on the InterBase forum or ODBC forum for better assistance on it. Smiley Happy

 

Regards

WillemC Regular Visitor
Regular Visitor

Re: Connect to InterBase database

Hello @v-ljerr-msft,

 

Thank you for your reply.

I fixed the problem in some sort of way.

 

In IBConsole I also added the server and database and made sure it connected there.

Then, when I create a select * from table in Power BI, the results pop up.

For some reason, when I leave the query field empty, I still don't get an overview from the available tables like it would when I connect to a sql server.

 

Don't know if this is standard behaviour when you connect through ODBC, or that this is a flaw in Power BI?

v-ljerr-msft Super Contributor
Super Contributor

Re: Connect to InterBase database

Hi @WillemC,



Great to hear the problem got fixed!

 

Based on my understanding, the behavior could vary when connecting through different ODBC drivers, as different drivers may not work in the same manner(like ODBC Driver for SQL Server and ODBC Driver for InterBase in this case). Smiley Happy

 

Regards

WillemC Regular Visitor
Regular Visitor

Re: Connect to InterBase database

Today I did an different approach.

In my SQL Server I've attached the InterBase database as a Linked Server.

So I create some views in another database in SQL server, and then connect PowerBI to this SQL server.

 

I think that this is giving me a more stable and powerfull solution.

I can combine different databases more easily and SQL server shows the table structure better (since PowerBi doesn't show the tables from the interbase at all).