topic Re: Report server database is getting larger and larger in Report Server

Report server database is getting larger and larger

alisoroush7 — Tue, 12 Sep 2023 05:40:56 GMT

hi guys
i have a power bi report server and its data base is getting larger and larger. as i had a look on it, the biggest table is CatalogItemExtendedContent. is there anyway to reduce its size buy deleting some useless data? and im wondering what cause this table to be huge in size?

Re: Report server database is getting larger and larger

AnthonyGenovese — Tue, 12 Sep 2023 16:40:33 GMT

How big are you talking? The general thought is to never touch these tables (except for some general queries to determine report usage). If you need to reduce the size of the tables, it is best to delete reports, dataset, and subscriptions in the front end. That way everything is properly removed. You could also reduce the amount of history that your report server is keeping.

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!

Re: Report server database is getting larger and larger

alisoroush7 — Wed, 13 Sep 2023 04:32:47 GMT

thanks. i did it and after that i shrinked the database and 50% of the space got free