Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Accessing Metric Scorecard History.

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.. ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

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


    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

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


      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.