Forum Discussion
Restoring a Deleted Power BI Report
There is a table "Catalog" in Report Server database which stores information of all the items stored in PBIRS.
- Check there and see if Report is available or not.
- If not available then try to see if you have previously stored a database which has information of that report, and try to restore it and re-implement Encryption keys to the database again.
- If still not available then you can see if you can recover data from Transactions Logs.
Use ReportServer
GO
Select [Current LSN] , [Transaction ID], Operation, Context, AllocUnitName As TableName
FROM
fn_dblog(NULL, NULL)
WHERE Operation = 'LOP_DELETE_ROWS'
SELECT
[Current LSN], Operation, [Transaction ID], [Begin Time], [Transaction Name], [Transaction SID]
FROM
fn_dblog(NULL, NULL)
WHERE
[Transaction ID] = '0000:0020b15f' -- Transaction id from previous table.
AND
[Operation] = 'LOP_BEGIN_XACT'
Ref:
Right Way to Recover Deleted Records in SQL Server 2016, 2014, 2012 (data-recovery-solutions.com)
As Farhan mentioned, if its deleted from Catalog table there is no way to get that in current DB. Only way out is to restore if you have a backup!