Forum Discussion

WillemC's avatar
WillemC
Resolver I
9 years ago
Solved

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.   Nex...
Need Help
Show and Tell
  • WillemC's avatar
    WillemC
    9 years ago

    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).

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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). :smileyhappy:

 

Regards

WillemC's avatar
WillemC
Resolver I
9 years ago

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).

  • Jesusdario26's avatar
    Jesusdario26
    Frequent Visitor
    4 years ago

    buenas noches puedes hacer un video de como conectar 

    InterBase y power bi por favor [email protected]