Clean up previous data posted in a dashboard?

Hi, Anonymous 

It’s my pleasure to answer for you.

According to your description,If you use import mode to connect the datasource,each refresh in PBI Service will re-import the data of the source data, and don't store those ‘old data’ in memory.You should first check if the size of datesource has exceeded 1GB.

If the size of the source data has exceeded 1GB, you need to manually reduce the size of the source data and keep only the required data.Also,you can use Incremental refresh or use mixed mode(import and DQ)

If the data is not large,the measures, visuals, etc. involved in the report is what occupied memory, and you need to optimize the report.

Links:https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization 

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.