Forum Discussion
kcoyle11
10 years agoNew Member
Data Source Only showing one table
Hello I am connecting to a data source through odbc connection. The connection previously worked fine but it is now showing only one of the tables in the Database. Any ideas??
marcopaulo
10 years agoNew Member
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