- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Add Caller ID to Teams Voice Call Queue Report
Hey All,
We are using the template provided by Microsoft for reporting on our on-call usage and quality. I would like the ability to include the phone numbers we are recieving the calls from. Would anyone know how I can include the incoming caller ID anywhere in this report? Even if we are just viewing it in the "Data View" that would be enough.
Any input would be appreciated.
Cheers,
Tanner 🙂
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

What is your data source ? Excel file for example ?
I can't understand the Microsoft template use in your case.
Can you elaborate the steps that you did to build the report ?
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Now I understand better the situation. Based on the Word document provided, there is no such column representing the phone numbers (and this is probably due to security matters).
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks for your continuing help 🙂
My data source is:
https://api.interfaces.records.teams.microsoft.com/Teams.VoiceAnalytics/getanalytics
I am not sure where this is pulling the data from, but I assume it connects directly with Teams Voice?
I did not create this report, I downloaded a template from this Microsoft webpage:
Download Power BI Query Template For Teams Voice Applications (Auto Attendant and Call Queue) from O...
Cheers,
Tanner 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Now I understand better the situation. Based on the Word document provided, there is no such column representing the phone numbers (and this is probably due to security matters).
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Can you make sure that the incoming caller ID data is available in your data source. If it is not already included in the data, you may need to modify your data collection process to include this information.
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Is there normaly a location where this data will be stored if it is in my data source already? Or possibly a way to search this? I am unfortunately a complete beginner with this and did not create my data collection process. I used the template from Microsoft to create this, which auto created everything. If I were to try and modify the data collection, do you know what I need to include for Power Bi to collect this piece of data?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

What is your data source ? Excel file for example ?
I can't understand the Microsoft template use in your case.
Can you elaborate the steps that you did to build the report ?
Proud to be a Power BI Super User !
Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
04-01-2022 05:40 AM | |||
08-06-2024 09:06 AM | |||
12-19-2023 07:50 AM | |||
Anonymous
| 09-15-2022 03:59 AM | ||
07-16-2023 03:53 PM |
User | Count |
---|---|
132 | |
105 | |
85 | |
55 | |
46 |