Accessing Auto Attendant & Call Queue Data Progamatically

[tvalente]

Hi All,

The area I work in, is interested in analysing Auto Attendant and Call Queue data. As below I was able to follow the instructions and use the template Power BI report to access the data.

Auto Attendant & Call Queue Historical Report - Microsoft Teams | Microsoft Docs

Two issues:

1) The report only stores 28 days of data. I would like to view longer historical

2) When published to power BI report server, I have issues getting report server to refresh the report using the credentials that successfully refresh the report inside of the template. 

I have tried to use the Graph API, to connect and retrieve the call data. However, the Graph API seems to only allow access to call information generated through the API (ie make a call using Graph, take the resulting generated ID and then retrieve the data). I want to analyse calls made/received by people not code/machines.

How do I programmatically access the  call data as per the template. I am using Python as my preferred language.

Thanks All,

Tiago

[Anonymous]

HI @tvalente,

#1, this is a known limitation of this template usage, these limitations are enabled on the datasource side so you can't do custom with them at the power bi side.

Auto Attendant & Call Queue Historical Report - Microsoft Teams | Microsoft Docs

#2, this should be a power bi template report so I think you need to publish it to power bi service side instead of power bi report server.

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power B...

Regards,

Xiaoxin Sheng

[tvalente]

Thanks we don't use Power BI service but report server currently.

Is there another way to access the raw data and insert into a database. This way we can analyse historical as well. This 28 day period is a big limitation. Most businesses want to analyse trends over years not 28 days.

[Anonymous]

Hi @tvalente,

In fact, these date range limitations are defined by the service itself. If they did not provide a corresponding interface, you can't do customized with getting records date ranges. Perhaps you can try to directly get data from the underlying data source instead of the shared API.

Regards,

Xiaoxin Sheng