Automatically check-in new value scorecard

Hi experts,

i need help with automatically checking in new values in my scorecard.

I created a report that connects to a mysql table which is populating itself each 10 minutes with a random number. The scorecard is connect to a visual which simply does a countrows. I enabled the refresh and after every automatic refresh, i can see the the number going up in the scorecard. So far so good.

But i want to track the changes, so i thought: let's use power automate to create a check-in. So i created the flow:

When current value of a goal changes > Create a new check-in

As soon as the value is updated by the refresh, the flow activates and it runs the first one perfectly, but the second returns:

Manually updating connected metric value is not allowed.

So i tried changing the second step to Update a check-in, but again no succes. Does anyone knows how to automatically check-in this new value?

Tnx in advance,

Robin