Forum Discussion
Kudo Commander"Connected" Scorecard goal not refreshing
I have two Scorecard goals set up in a premium workspace. They are identical except for the source of their "current value." One goal (Goal A) points to a a published model that's a SQL query against a table in a SQL server managed instance in Azure.
The other (Goal B) points to a published model that's built on tables published to a data warehouse in a premium workspace. This model is refreshed daily via a Power Automate flow.
Both models refresh daily prior to the scorecard refresh. Only Goal A refreshes in my Scorecard. I can manually refresh Goal B in the Scorecard, and the data updates, but the Scorecard clearly isn't seeing the refreshed data each morning for Goal B.
No, there isn't any RLS involved in either data source.
Hi MarkPalmberg,
At this point I recommend opening a ticket to Microsoft. If data is correct in the model, and the scorecard just won't update, something is wrong and we don't have enough telemetry data to troubleshoot.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
8 Replies
- tayloramy
Super User
Hi MarkPalmberg,
What is the delay between the semantic model refresh nd the scorecard refresh? Is there a chance that the semantic model isn't quite finished before the scorecard starts?
It might be worthwhile to move the semantic model sitting on the warehouse to be a DirectLake model instead of an Import model, that way it will always be up to date with the warehouse and won't need to be refreshed.
I'm also seeing some other community posts indicating that scorecards sometimes just fail because they feel like it.
https://community.fabric.microsoft.com/t5/Service/Scorecard-Unable-to-refresh-Usage-Metrics-on-a-Scorecard/m-p/4413024If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
MarkPalmbergThanks for taking the time to reply, tayloramy . I've got ~2 hours built in between the update of the data warehouse tables and the refresh on the Scorecard model; I'd be surprised (but not TOO 😉 ) if timing were the issue.
I hadn't thought of the DirectLake/Import switch. I can try that, but the freshness of the underlying data doesn't seem to be the problem.
I'm also seeing some other community posts indicating that scorecards sometimes just fail because they feel like it.
Yeah, I saw that. I've authored Scorecards in the past in which the connected targets updated reliably from models based on SQL server queries, so it appears that either something about Scorecards has changed or they just don't like Fabric data warehouse data tables. I think I'll test again with a different DW table and see if I get the same behavior.
Thanks again for the reply.
- tayloramy
Hey MarkPalmberg,
If you have a 2 hour delay, I agree that that should not be the issue there.
Here's another thought, if you explore the model can you see the updated data, even if the scorecard can't?
THat will tell you if the issue is actually with the scorecard, or if it is with the model not getting updated.If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.