Forum Discussion
Accidentally removed elevated rights AD groups from a 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.
Community ChampionYou 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
Memorable MemberNooo,
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.