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

Hello,

 

When you are setting your data source, under 'advanced options' you can add an SQL statement. I simply added

 

select * from iAgentPerformanceStat  

 

or

 

select * from mApplicationStat  

 

Depending on what data you are looking for. (Agent or Application data)

 

I hope this is helpful

 

RR