Accessing Metric Scorecard History.

[edpredpeanut]

I am trying to access Metric Score card data history to pull into a Power BI dashboard to show week over week changes.  but I can not find a way to access the data.   please see screen shots below..

One my workspace..  I click the below Icon.

Takes you to a spot you can add scorecards.  below is an example of a scorecard name that has multiple scorecards in it.

Inside I have created several score cards..

 Inside the score cards there is a "history" tab showing all the days the scorecard was refreshed.

It is this data that I am trying to pull into my dashboard as a dataset so I can do week over week analysis on it..  but I can't find "Where" and "How" to pull the data..

Thanks in Advance to those smarter than me...

[v-jtian-msft]

Hi,@edpredpeanut . I am glad to help you.
I hope that the following link will be of help to you
The following link has a detailed description of how to use the monitoring report to use the metrics, which I hope will be helpful to you.
URL:
Monitor report usage metrics - Power BI | Microsoft Learn
Monitor usage metrics in workspaces (preview) - Power BI | Microsoft Learn

In Power BI Desktop you can also access the semantic model used for the reports containing the monitoring metrics.

Using metrics visual to present metrics data in Power BI Desktop
URL:
Create a metrics visual in a Power BI report - Power BI | Microsoft Learn

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.

[edpredpeanut]

Carson..

Thank you for the suggestion.  when I perform the above it pulls in the values I am looking for but...    the table it creates says "This table cannot be shown because it is not in import mode".   When I go to the properties of the table and Advance mode to change the storage mode the option to select anything is grayed out.

[v-jtian-msft · Accepted solution]

Hi,@edpredpeanut . Thank you for your reply.
It seems that you have successfully been able to get the monitored report access data, I have the following suggestions for your current problem
According to my query to the official documentation, it is confirmed that when using the semantic model as a data source in power BI desktop, the data is connected in real time and therefore some of the features in the left navigation bar are disabled.
Here is the documentation about it:
url:
Connect to semantic models in the Power BI service from Power BI Desktop - Power BI | Microsoft Lear...

I suggest you choose to analyze the report in excel, analyze the data in excel and export the data so that you can see the detailed 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.