Call SQL procedure every time the report is viewed

[Anonymous]

Hello all

Every report we have offers usage metrics. Unfortunately this data is only stored 90 days and we already have a table in our database to store our views to any reports. There is also a stored procedure to write in said table.

Is it possible in Power BI to do something (in this case call procedure) every time a report is opened?

If not, any suggestions?

Many thanks

[Anonymous · Accepted solution]

HI @Anonymous ,

Nope, you can't do custom with usage metric function.
AFAIK, power bi will trace these requests to specific dataset and storage to azure side(not save to database side), so it is impossible to use sql storage procedure to trace these records.

Regards,

Xiaoxin Sheng