Report server database is getting larger and larger

[alisoroush7]

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?

[alisoroush7]

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

[AnthonyGenovese · Accepted solution]

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!