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

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]