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

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.

  • Randyr's avatar
    Randyr
    Frequent Visitor
    9 years ago

    I got it!   I just changed it to a simple SQL query.   SELECT * from iAgentPerformanceStat

     

    Thank you for the help!!

    • hugoberry's avatar
      hugoberry
      Responsive Resident
      9 years ago
      Aha, so probably using the query without quotes would have worked as well:)
      Glad that you've sorted this
    • Anonymous's avatar
      Anonymous
      Not applicable
      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