Forum Discussion
Accidentally removed elevated rights AD groups from a report
Hello Experts!
I am hoping you can give me some insight or direction.
Here is the situation.
When i was updating security on one of our reports on Power BI on-Prem report server. I removed the Admin account on accident and now we have no way of accessing or edit/removing that report. Is there another way to see all the reports on the server and remove them if the Admin accounts are not tied to the report?
Nooo,
please do not delete any report this way, you will delete only head information of report, other (including content data, model, policy, schedules, and so on) will rest in db.
If you want delete report directly in DB, I strongly do not recommend, it is unsupported, but if you still want, please use correct stored procedure, e.g. DeleteObject (use profiler to check how use parametrs). Additionaly, better than delete report is reset permission on report using SP DeletePolicy. E.g.:
exec DeletePolicy @ItemName=N'/YOUR/PATH/TO/report'
But again, is not recommend to do anything on DB level, it is unsupported way.
2 Replies
You can remove the report by using the below table in PBI Report Server Database
DELETE FROM [dbo].[Catalog] Where ItemID ='Your Report Item ID'
not sure about the second part though
Nooo,
please do not delete any report this way, you will delete only head information of report, other (including content data, model, policy, schedules, and so on) will rest in db.
If you want delete report directly in DB, I strongly do not recommend, it is unsupported, but if you still want, please use correct stored procedure, e.g. DeleteObject (use profiler to check how use parametrs). Additionaly, better than delete report is reset permission on report using SP DeletePolicy. E.g.:
exec DeletePolicy @ItemName=N'/YOUR/PATH/TO/report'
But again, is not recommend to do anything on DB level, it is unsupported way.
