Forum Discussion
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).
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?
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
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).
buenas noches puedes hacer un video de como conectar
InterBase y power bi por favor [email protected]
