Blog Post

Microsoft Teams Blog
4 MIN READ

Mapping External Users’ Locations with CQD Data and PowerBI

Siunie Sutjahjo's avatar
Siunie Sutjahjo
Icon for Microsoft rankMicrosoft
Apr 03, 2020
With the global crisis of COVID-19 and the impact on the global workforce, the ability to see utilization metrics from an external standpoint (for example: a user working from home) has become increa...
Updated Jan 26, 2021
Version 5.0
calling
microsoft teams
Praveenbandi's avatar
Praveenbandi
Copper Contributor
Jul 07, 2020

Hi Siunie Sutjahjo,

I have tried the same approach and trying build the report on external calls geographical analysis across the globe. I had downloaded IP2LOCATION-LITE-DB3.CSV, IP2PROXY-LITE-PX3.CSV and IP2PROXY-LITE-PX4.CSV files and appended at Query Editor and created Reflex column but this was able to map only 2% of the total streams.

Nirmal Sundara Raman, any comments on this

I am trying to build this report from couple of months but still I couldn't get the perfect solution. your help would be highly appreciated.

 

Regards,

Praveen