Pulling history of sorecard metric

[thomma]

Hi all, 

Does anyone know if there's a possibilty to query the history of scorecard metrics into Desktop? I've got a couple KPI's running in scorecards and would like to visualize them through time using the history logged in the scorecard. One solution I was thinking about myself was creating a power automate flow and write the data to an online Excel sheet, but I imagine there might be an easier way.

Thanks in advance!

Thomma

[Ritaf1983]

Hi @thomma 
I don't think that we have something generic to keep the history of the scorecards.
There is an idea about the issue, please vote for it ( I voted 🙂 )

https://community.fabric.microsoft.com/t5/Custom-Visuals-Ideas/Scorecard-Historical-Data-Load/idi-p/...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[thomma]

Hi @Ritaf1983,

Thanks for your response, I will vote for the idea. Do you know of other possibilities/workarounds to still query the data into desktop or is it entirelly not possible?

[Ritaf1983 · Accepted solution]

Hi @thomma 
I don't use scorecards, because have a problem with cards of all types. 
I wrote here why :

https://community.fabric.microsoft.com/t5/Community-Blog/When-Big-Numbers-Become-Big-Problems/ba-p/3...

But,  Yes, I have indeed used Power Automate to save snapshots of changing metrics and then load them into reports that track the historical progress of those metrics. This is exactly what you described in your first question.

The method that I used is described in the linked video.
https://www.youtube.com/watch?v=ZTkbC8zhA5k

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly