How to delete subscriptions in PowerBI RS

Question

Bilal H. Bhatt 136

Hello,

I have a user which has lot of subscription in PowerBI Report server. I want to delete all the subscriptions associate with this user.

Please let me know how can i do it?

Thanks

1 answer

Answer 1

Thank you for reaching out to the Microsoft Q & A Forum.

Please try below steps to Delete Subscriptions for a User.

Open SQL Server Management Studio (SSMS). Connect to the SQL instance hosting your PBIRS databases. Locate the ReportServer database (not ReportServerTempDB).
Subscriptions are stored in the Subscriptions table. Each subscription has an OwnerID that links to the user in the Users table.

Run below query to find all subscriptions for the user.

USE ReportServer;

SELECT s.SubscriptionID, s.Path, u.UserName

FROM Subscriptions s

INNER JOIN Users u ON s.OwnerID = u.UserID

WHERE u.UserName = 'DOMAIN\UserName';

Replace DOMAIN\UserName with the actual username.

DELETE s

FROM Subscriptions s

INNER JOIN Users u ON s.OwnerID = u.UserID

WHERE u.UserName = 'DOMAIN\UserName';

Note: Always take a backup of the ReportServer database before running DELETE operations.

For testing, Run the SELECT query again to ensure no subscriptions remain for that user.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh