Insert a value into a table every refresh time

Hi guys,

I'm using pbixrefresh using Python to refresh my PowerBI Dashboard and publish into my account in PowerBI Service.

Now I am trying to audit the number of times that my dashboard is refreshed (the Python script runs every hour).

I can do this using Python but I'm trying a different approach... and my question is to know if is possible using a Insert Into/Output in PowerBI Query. Basically i'm trying this on my dataset:

UPDATE [Reports_HP].[dbo].[TESTE_PBI_UPDATE]
SET  [ID] =  1

UPDATE [Reports_HP].[dbo].[TESTE_PBI_UPDATE]
SET  [ID] =  [ID] + 1
OUTPUT inserted.[ID]

And I can do the audit under SQL side.

But I'm getting this error:

Microsoft SQL: Incorrect syntax near the keyword 'UPDATE'.
Incorrect syntax near ')'.

This is possible?

Thanks!