Insert a value into a table every refresh time

[Manalytics]

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!

[v-xjiin-msft · Accepted solution]

Hi @Manalytics,

Generally, in Power BI desktop SQL query can only be embedded into a source statement. And it is used to import data not modify.

So it is not possible to do Insert into/update in Power BI desktop. But you can do it at SQL side, then import the table into Power BI desktop.

Thanks,
Xi Jin.