Forum Discussion
Teams Callqueue data, how to get the data
Hi burakkaragoz : Thanks for the quick response. I will certainly check your steps to see if it resolves my problem.
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!
- wim19819 months agoNew Member
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?
- burakkaragoz9 months ago
Super User
Hi wim1981 ,
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.- wim19819 months agoNew Member
Ok, i will test it. I am a newbe in Power BI hehe.