Forum Discussion
Teams Callqueue data, how to get the data
Super UserHi wim1981 ,
This is a very common situation with that specific template. Since you are opening a .pbit (Power BI Template) file, it is completely empty by design until it successfully connects to your tenant's data stream.
For the Teams Auto Attendant & Call Queue (V3.x) reports to work, simply opening the file isn't enough. You need to ensure three specific prerequisites are met on your machine and tenant.
1. The Custom Connector (Crucial Step) This report relies on a specialized connector called MicrosoftCallQuality.mez. It does not come built-in with Power BI Desktop.
Check: Go to your Documents\Power BI Desktop\Custom Connectors folder.
Action: If that folder is empty or doesn't exist, you need to download the connector from the Microsoft Download Center (where you got the template) and place the .mez file there.
Restart: After placing the file, restart Power BI Desktop. You might need to enable "Allow any extension to load without validation" in File > Options > Security > Data Extensions.
2. The Permissions Even with the connector, your user account needs specific permissions to pull this data. You typically need to be assigned one of these roles in M365:
Teams Communications Support Specialist
Teams Communications Support Engineer
Global Reader (sometimes insufficient for granular data)
3. Data Latency If you just set up the Call Queues today, note that CQD data usually has a slight delay (24-48 hours) before it populates in the historical reports.
Summary: Make sure the .mez file is in your Documents folder and that you are logged in with a user who has Teams Admin rights. When you open the template again, it should ask you to sign in and then start loading the data.
Hope this gets your data flowing!
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Hi burakkaragoz : Thanks for the quick response. I will certainly check your steps to see if it resolves my problem.
- burakkaragoz
Sounds good wim1981 !
Take your time to go through the steps. The missing .mez file is almost always the culprit in this scenario, so I am confident that will get you connected.
Let us know how it goes once you test it!
Hi burakkaragoz .
I don't see the folder Power BI Desktop\Custom Connectors in Documents.
Also when i open the template and i go into the query builder, i can get all the data from Callqueues. But when i clikc close and use, the parts where the data supose to be shown in the main screen don't show any data. How do i populate it via the data pane on the right?
