Querying Scorecards historical data

[edpredpeanut]

I've created Metric Score Cards from my Power BI Workspace.   I now have a month's worth of data.  Capturing daily numbers in the score card.   Example, # of projects last week was 230.  # of projects this week is 250.  What I need is to be able to query that data in my Power BI Dashboard and show in a card "Last Week 230, This Week 250" in (2) individual cards.  But I do not know how or where to query the information.   I know somewhere this data has to be stored in a dataset.  Because when I add a Metric (Preview) score card to my dashboard I see a graphical representation of that data.   I don't need a months worth of data.  I just need the data.  Thoughts?

[OldDogNewTricks]

I have some related ideas here:  Scorecard updates - Microsoft Fabric Community  Feel free to vote if you think they would help.

[Anonymous · Accepted solution]

Hi,@edpredpeanut 
I am glad to help you.

According to your description, you want to capture the number of views of a report in a scorecard and display this data in the report.

Here is the official documentation on adding scorecard data to a report, hopefully it will help you.
url: Create a metrics visual in a Power BI report - Power BI | Microsoft Learn
You need to publish the report to the service which shows the data of the metrics, you can see the relevant report views and other scorecard information.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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