Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
@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.
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 ?
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.
Proud to be a Super User!
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)
Proud to be a Super User!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |