Teams Callqueue data, how to get the data

Question

Hi,&nbsp;i want to get Teams Call Queue statistical data. I have a template named&nbsp;Teams Auto Attendant &amp; Call Queue Historical Reports V3.2.2.pbit. But when i want to generate reports with this template, there is no data?&nbsp;How can i efficiently use this template to get reports of a Call Queue?&nbsp;ThanksWim

burakkaragoz · Answer

Hi wim1981&nbsp;,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 &amp; 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 &gt; Options &gt; Security &gt; 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 SpecialistTeams Communications Support EngineerGlobal 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.

burakkaragoz · Answer

Hi wim1981&nbsp;,That is actually great news!If you can see rows of data inside the "Query Builder" (Power Query Editor), it means the connector is working and your permissions are correct. You can ignore the folder issue for now since the connection is already successful.Why are the visuals empty? Since this is a Template (.pbit), the visuals are already pre-built. You usually do not need to drag fields from the right pane. If the visuals are blank (showing empty charts), it is almost certainly a Filtering Issue, specifically with Dates.Please check these 2 things:1. The Date Slicer (Most Likely) Teams CQD data is not real-time; it typically has a 24-48 hour delay.Look for the Date Range slicer on the report page.If it is set to "Last 1 Day" or "Today", the report will be blank because the data hasn't arrived yet.Fix: Change the date slider to look at Last 30 Days or pick a date range from last week. The visuals should instantly pop up!2. The "Refresh" Button Sometimes Power Query sees the preview, but the Report Model hasn't loaded it yet.Click the Refresh button in the Home ribbon one more time to force the data from the query editor into the visuals.Regarding the Folder: If you ever need to find it manually in the future, you have to create it yourself. Windows doesn't create it by default. You would manually create a folder named Custom Connectors inside Documents\Power BI Desktop. But again, since your data is loading, you are good to go!Try adjusting that Date Slicer and let me know if the charts appear!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.

wim1981 · Answer

Hi,&nbsp;yes. The situation is now that i get the data, but the program is so slow that there are no graphs displaying or generating. I think its because my pc is nog strong enough.&nbsp;

wim1981 · Answer

Hi&nbsp;burakkaragoz&nbsp;: Thanks for the quick response. I will certainly check your steps to see if it resolves my problem.&nbsp;

burakkaragoz · Answer

Sounds good wim1981&nbsp;!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!

Forum Discussion

Teams Callqueue data, how to get the data

9 Replies

Related content

Activator Teams Alert

Data agent Into Teams via copilot studio

How to integrate Fabric Data Agent into Teams?

Setting up Microsoft Teams and Outlook 365 Connections

Grab data from Teams channel's posts