Forum Discussion
Teams Call Quality Dataflow
I have the Teams CDQ power bi reports setup but they only give you 30 days worth of stats. I was wondering if anyone figured out a way to send this data to a DataFlow so I can keep a year or more worth of data? I have some managers that would like to use this data for yearly employee reviews.
I have also built out Real Time Dashboards in Power BI with call queue info by using a PowerShell Script running on a windows server to pull Teams data and send it to the Power BI API. Works great! Now just need to figure out to keep all this data.
Hi NickTT
Have you considerd using Power Automate to export the data on a rolling period.
Maybe on a friday night back it up to SharePoint/DataVerse/Excel etc
If you arent sure how to write a dax query there is an easy way to grab some prewritten stuff.
Download the pbix file.
On View toggle on Performance analyzer
Click refresh visuals
Expand the visual you want the code for (or make one first) and click copy query
Paste this into Power Automate:
Then add the step exporting this data to your chosen storage!
2 Replies
Hi NickTT
Have you considerd using Power Automate to export the data on a rolling period.
Maybe on a friday night back it up to SharePoint/DataVerse/Excel etc
If you arent sure how to write a dax query there is an easy way to grab some prewritten stuff.
Download the pbix file.
On View toggle on Performance analyzer
Click refresh visuals
Expand the visual you want the code for (or make one first) and click copy query
Paste this into Power Automate:
Then add the step exporting this data to your chosen storage!
A dataflow isn't what you want here, that'll refresh the same way as a semantic model query - you need to store it somewhere, like in a SQL server. If you don't have a real database to put it in, you can use a SharePoint library and store as CSVs, but that's usually a last resort.
