Scorecard

[Timppa]

Hi, I'm new to the forum and I have a problem. We are using Power BI scorecard in the app.powerbi.com environment and now I need to display a column that shows the latest change to a goal. Is there a way to do that? We have a lot of goals and manually searching for the latest update/change is not easy.

[DataVitalizer · Accepted solution]

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 💡

🟩 Follow me on LinkedIn

[Timppa]

Hi @DataVitalizer and thanks for the reply. Can you tell me if it is possible to connect the semantic model of the scorecard to Power BI desktop? Would that allow me to create my own separate report that I could use to track when a goal has been updated?

[DataVitalizer]

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 💡

🟩 Follow me on LinkedIn

[Timppa]

I made some changes to the records I want information about (i.e. changed information) and it works! So this is ok.

[Timppa]

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.

[v-achippa]

Hi @Timppa,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @DataVitalizer for the prompt response. 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa