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

    • 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?