Restoring a Deleted Power BI Report

[Anonymous]

Hello,

I created a Power BI report via "Integrate->Power BI->Visualize the list" menu from a Sharepoint List. This report has been lost and/or deleted somehow. Is there a way to check who deleted it, how to protect in the future and restore it back? (It was not in workspace since it was created via "Integrate" menu. 

(We are using on premise Power BI Pro lisance in the company.)

Thank you in advance.

BR,

[V-pazhen-msft]

@Anonymous 

In Power BI Workspace, it is not possible for now to restore a individual report is not possible in a workspace.

Microsoft Idea  · Restore reports or dashboards (powerbi.com)

But I am not sure with SharePoint, you may go to the SharePoint BI Forum see if there is any restoring feature.

SharePoint BI - Microsoft Tech Community

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello Dear Farhan,

Since we don't have Power BI Premium and SQL Server Enterprise Software Security we could not find it. Is there any other way to check ?

[FarhanAhmed]

Unfortunately, I am not sure if there is another way. If you have a backup of the database or machine try to restore it and recover the particular file from there.

[FarhanAhmed]

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)

[AbhiSSRS]

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!