Forum Discussion

alisoroush7's avatar
alisoroush7
Icon for Helper I rankHelper I
3 years ago
Solved

Report server database is getting larger and larger

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...
SQL
  • AnthonyGenovese's avatar
    AnthonyGenovese
    3 years ago

    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!

AnthonyGenovese's avatar
AnthonyGenovese
Icon for Resolver III rankResolver III
3 years ago

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!