Power BI Scorecard Not Refreshing Metrics Automatically When Using RLS

[Linhvo2812]

Hi everyone,

I'm facing an issue with scorecards in Power BI Service and would appreciate some guidance.

We have a scorecard connected to several dashboards and reports in the same workspace. These dashboards use Row-Level Security (RLS). The goal is for users to click on a metric in the scorecard and view the related report for trends and more context.

The issue is:

• When our dataset refreshes and we go to the scorecard, the metric values (like Progress and Trend) do not update, even after clicking the refresh button at the top-right of the scorecard page.

• The only ways we’ve been able to see updated values are by:

  • Manually refreshing each metric, which is time-consuming (we have ~200 metrics).

  • Or removing RLS from the reports that feed the metrics (which we don’t want to do for security reasons).

Has anyone experienced this? Is there a way to automatically refresh all metrics in a scorecard even when RLS is enabled?

We’re looking for a solution that:

• Doesn’t require removing RLS.

• Doesn’t involve clicking “refresh” on each metric manually.

Thank you!

[OldDogNewTricks]

For anyone interested, please check out my idea for improvements here:  Scorecard updates - Microsoft Fabric Community

[Linhvo2812 · Accepted solution]

hi @v-csrikanth 

Thanks a lot for your time and suport, since Im not a developer and do not work with APIs and similar things, I dont think I can either understand the solution or try it out 🙂 But still, thanks for your support

[v-csrikanth]

Hi @Linhvo2812 

I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @Linhvo2812 
Sorry for the late response.
Thank you for being part of the Microsoft Fabric Community.

• Power BI’s built-in persistent filters feature only works when users are signed in with Azure AD accounts under the “Embed for your organization” scenario external or non-AAD users cannot leverage this out of the box
• To give all users a “persistent” experience, capture their filter or slicer selections in your app (for example, save to browser localStorage or your backend database).
• On each report load, use the Power BI JavaScript API’s setFilters method to reapply those saved filters programmatically
• Storing and restoring filter state yourself lets you support any user type—anonymous, guest, or external—without relying on Microsoft account logins.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[BhavinVyas3003]

Try Using Power Automate to trigger a "refresh all metrics" flow after dataset refresh. This automates metric updates while keeping RLS intact.

[OldDogNewTricks]

Do you happen to know the underlying API that Power Automate is triggering?  Or if this is availabe in Semanitic Link Labs?  I believe we have a related issue because our semantic models are Direct Lake mode, they are not being "refreshed" so I don't believe we are geting updated metric values from them into the test scorecard I built.

[OldDogNewTricks]

For anyone else looking for this, I found the APIs.  Unfortunatly they do not appear to support SPN authentication yet so I am unable to use.

Scorecards (Preview) - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Goals (Preview) - REST API (Power BI Power BI REST APIs) | Microsoft Learn