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, @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

  • marcopaulo's avatar
    marcopaulo
    New Member
    10 years ago

    Frown sent.

    Please tell me if you do not get it.

     

    Thanks.

     

    • kcoyle11's avatar
      kcoyle11
      New Member
      10 years ago

      Did anyone find anything more on this?

      • arify's avatar
        arify
        Microsoft Employee
        10 years ago

        Hi kcoyle,

         

        We'll investigate why the Firebird ODBC driver is acting like this :) Meanwhile, you can turn off the HierarchicalNavigation, and it should work fine. To do that:

         

        Go to "Get Data" > "Blank Query" and then type this to the formula bar:

        = Odbc.DataSource("dsn=YOURDSNNAME")

        Thanks