Forum Discussion

kcoyle11's avatar
kcoyle11
New Member
10 years ago

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??
Need Help
marcopaulo's avatar
marcopaulo
New Member
10 years ago

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

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    Hi,

     

    Can you send us a frown? We'll need some traces. Also, can you turn off HierarchicalNavigation? The way to do that is: Go to Advanced editor and change HierarchicalNavigation=true to false.

     

    Thanks

    • marcopaulo's avatar
      marcopaulo
      New Member
      10 years ago

      Hi, @arify. Thank you for your reply.

       

      Sorry, but what is a "frown"? How can I sent it to you? Also, I can not find where to apply your instruction "Go to Advanced editor and change HierarchicalNavigation".

       

      Please give more instructions.

      Thanks.

       

      • arify's avatar
        arify
        Microsoft Employee
        10 years ago

        Oh, sorry for the unclear reply.

         

        Here's how you send a frown email:

         

         

        In the email you can mention this thread & put the screenshots.

         

        About the other thing, this is a simpler way: Go to "Get Data" > "Blank Query" and then type this to the formula bar:

        = Odbc.DataSource("dsn=YOURDSNNAME")

        Thanks