Data Source Only showing one table

Hi,

What's the datasource? Can you show us a few screen shots?

Thanks

kcoyle11 If you're connecting via ODBC and straight from power bi desktop entering connection strnig then you can try going through DSN option where create system DSN first and use that in power bi destkop. If you are already using DSN then avoid that route and enter connecting string for ODBC straight in power bi. You can try both ways to see which ones fix your problem. I have seen this worked for me previously when connecting to database for which there isn't in-built connector.

I am using a DSN for a Firebird Database.

Hi. I am facing the same problem as kcoyle11.

When I am using Power BI Desktop (Version: 2.36.4434.362 32-bit (junho de 2016)) it connects through ODBC to the Firebird database, but shows only one table (the first one). The database I am accessing has 466 tables.

I am using Firebird 2.5.1.26351 (Win32), Firebird ODBC 2.0.4.155_Win32. I have created a DSN in ODBC Admin. The test connection is successful either the connection using Excel 2016 and Access 2016 through ODBC. In both cases they show me all tables.

I have tried to use the "Connection string" instead of DSN, but it does not work either.

Could you help us in founding out the problem? Thanks.

Power BI Navigator ScreenshotAccess screenshot

Hi arify,

since the Power BI August version was released the problem with Firebird ODBC seems to be solved. Now all the tables are been showed when using Get Data instead of only one.

Thank you for your assistance.

My best,

Marco Paulo.