Import Teams Call Records into Power BI via anonymous access

Michael Kane 20 Reputation points
2024-05-10T08:17:37.7733333+00:00

Hi

I have been asked to create a dashboard for a business unit which uses Microsoft Teams for inbound calls, through a queue system, and outbound calls direct from the client.

An app has been registered for Power BI in our Azure tenant and the following permissions applied:

  • callRecords.Read.All
  • User.Read
  • User.Read.All

All have been granted admin consent.

I have successfully tested retrieval of an access token using the app client/ secret via Python.

I then used the endpoint: https://graph.microsoft.com/v1.0/communications/callRecords as the URL for a web import in Power BI and set the 'Authorization' header using the token.

Note: I have also tested using a full M query which includes the steps to retrieve a token from https://login.microsoftonline.com/" & <tenantId> & "/oauth2/v2.0/token and use this to make the API call.

On committing, either returns a bad request error.

If I remove the callRecords element of the above URL, there is no error and I get back a list of endpoints, including the one already noted above, available within communications.

I would be grateful for any help to resolve this so I can obtain the data I need to complete the required dashboard.

Thanks

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,788 questions
0 comments No comments
{count} votes

Accepted answer
  1. CarlZhao-MSFT 37,626 Reputation points
    2024-05-10T08:52:56.67+00:00

    Hi @Michael Kane

    The /communications/callRecords endpoint is only available for beta endpoint. For the v1.0, you can only get one specific call record.

    GET /v1.0/communications/callRecords/{id}

    Hope this helps.

    If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful