Forum Discussion
Restoring a Deleted Power BI Report
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,
5 Replies
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!
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.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.
