Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MilkyDipper
New Member

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 🙂 

2 ACCEPTED SOLUTIONS

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

View solution in original post

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

View solution in original post

5 REPLIES 5
MilkyDipper
New Member

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 🙂

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
AmiraBedh
Resident Rockstar
Resident Rockstar

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

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?

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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors