Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
Hi @thomma
I don't use scorecards, because have a problem with cards of all types.
I wrote here why :
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
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 🙂 )
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
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?
Hi @thomma
I don't use scorecards, because have a problem with cards of all types.
I wrote here why :
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
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |