Forum Discussion
Log tables in PowerBI SQL Database
Deletes are not logged. The item is removed from the catalog table and the ExecutionLogStorage table as well. Since executionLog3 is a view onto these it vanishes from there as well.
There are no events recorded in the underlying ExecutionLogStorage table.
If you want to keep track of who created/amended or deleted what when you probably need to implement some kind of versioning on the catalog table.
I'm not sure I've ever seen anything useful about audit of report create/edit/delete in the SSRS tables thus far.
Makes sense. Thanks. I could see a use if you were trying to audit the changes made to published objects. Especially if you have acase of objects being deleted. Having that information at hand could help identify the problem users and identify a training opportunity.
We run a powershell script every 30 mins that extracts any new/amedned reports. Doesn't extract who did it of course. But if someone needs to roll stuff back and or needs to recoversomehting that's been deleted the its useful to have.