Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Call SQL procedure every time the report is viewed

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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