Forum Discussion
Scorecard
Hi Timppa
Scorecards don’t have a built‑in “last change” you can only see updates in each goal’s history, If you need a column showing the latest update across all goals, you’ll have to capture those changes yourself (for example with Power Automate logging goal updates into a table) and then display that alongside your scorecard.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
You are welcome Timppa
No you can’t connect the scorecard’s semantic model to Power BI Desktop in a way that exposes goal history or “last updated” info because the scorecard model is very limited and doesn’t surface those details.
If you want to track when goals are updated, the supported approach is to log goal changes with Power Automate (using the When a goal changes trigger) into a table or dataset, and then build your own report in Desktop on top of that.
Did it work? 👍 A kudos would be appreciated
🟨 Mark it as a solution to help spread knowledge 💡
Hi and thanks. It took me a while to get around to trying it out. I made a function in Power Automate that checks the "When a goal changes" scorecard values and adds them to an Excel spreadsheet that is stored in a Teams workspace. The problem is that the data just doesn't update to that Excel file? So when I update the data on the scorecard, the data doesn't move.