Forum Discussion

Randyr's avatar
Randyr
Frequent Visitor
9 years ago
Solved

ODBC Error with Cache DB

Hello,   I am brand new to Power BI and I am trying to pull data in from Avaya Aura Contact Centre which is an Intersystems Cache DB.  I am able to see the tables however when I select one of the t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Randyr,

    Glad to hear the issue is solved. You can accept your reply as answer, that way, other community members would benefit from your solutions once they get same issues.

    Thanks,
    Lydia Zhang

Randyr's avatar
Randyr
Frequent Visitor
9 years ago

Thank you Hugoberry, this makes perfect sense to me however I do not see anywhere in the Query editor where I can change this select query??

 

Sorry for being a newbie

hugoberry's avatar
hugoberry
Responsive Resident
9 years ago

It is hard to tell without having access to your query.

If you loaded the data from Get Data>ODBC  there is an Advanced option which you can use

  • Randyr's avatar
    Randyr
    Frequent Visitor
    9 years ago

    Thank you, yes that is what I am doing.  The Advanced options are blank, and if I leave them that way it will show me the tables but I get the error when I try to preview the data.

     

     

    If I go back and start again and try adding 

     

    select "Timestamp" , "ApplicationID" , "Application" , "CallsAbandoned" , "CallsAbandonedAftThreshold" , "CallsAbandonedDelay" ,  as you suggested, I see this now....before getting to the 'Navigator" window.

     

    • hugoberry's avatar
      hugoberry
      Responsive Resident
      9 years ago

      What happens if you escape the quotes?

      select ""Timestamp"" , ""ApplicationID"" , ""Application"" , ""CallsAbandoned"" , ""CallsAbandonedAftThreshold"" , ""CallsAbandonedDelay"" ,

      • Randyr's avatar
        Randyr
        Frequent Visitor
        9 years ago

        Thank you, adding escape quotes did not work unfortunately.