@braddo81 wrote:
yeah, so any issues with purging the data from this table?
and then free up the space
So if you are talking about truncating the table (eg deleting all the rows) yes there would be an issue. Deleting anything directly from the database is not supported and is highly likely to cause issues. Your entire instance might stop working or all your reports might thow errors. You should only ever delete things from the UI or using the support API methods.
The extended content table stores the content for your pbix based reports and the data models are loaded in and out of RAM dynamically from there. So if you delete anything from there you will almost certainly loose reports from the portal.
If you are just talking about performing a shrink operation at the database or table level there is not much danger in that although it is probably something you would want to do while the instance is not being actively used to minimize the impact. Although as I already mentioned you would only regain a maximum of 9Mb from shrinking that table.
