Forum Discussion

NickTT's avatar
NickTT
Helper III
1 year ago
Solved

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 wor...
Dataflow
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    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!

     

SamWiseOwl's avatar
SamWiseOwl
Super User
1 year ago

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!