Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Querying Scorecards historical data

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?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,Anonymous 
    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,Anonymous 
    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.