The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
Solved! Go to 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
For anyone interested, please check out my idea for improvements here: Scorecard updates - Microsoft Fabric Community
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
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.
Hi @Linhvo2812
Sorry for the late response.
Thank you for being part of the Microsoft Fabric Community.
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.
Try Using Power Automate to trigger a "refresh all metrics" flow after dataset refresh. This automates metric updates while keeping RLS intact.
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.
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
User | Count |
---|---|
37 | |
14 | |
12 | |
11 | |
8 |
User | Count |
---|---|
49 | |
36 | |
22 | |
21 | |
18 |