Clean up previous data posted in a dashboard?

[sohananahid]

Hi all: Good day! I have developed and published a dashboard that shows new ‘maintenance events’ and ‘critical notices’ on different pipelines in ‘Table’ visuals. I have added filter to pull only data that has ‘End Date’ of today or future [events that has not expired yet]. I am using ‘Import’ to Get data as I need to change format of Dates, etc. [tried ‘direct query’, doesn’t work]

The Power BI Publish Team in our company told us that the data memory report shows we are exceeding 1 GB memory limit.

I have a question: With our ‘Scheduled Refresh’ happening 4 times a day to pull new data and show those in the dashboard- what happens to the old data before the last ‘data Refresh’? Does Power BI desktop/Service side store those ‘old data’ in memory? If so, how can we delete those old data to free up memory space so that we are within our 1 GB memory limit?

Many thanks in advance. 😊

[v-janeyg-msft · Accepted solution]

Hi, @sohananahid 

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.

[GilbertQ]

Hi there

What it sounds like to me is that the size of your PBIX file is larger than 1GB.

You will need to remove any columns that are not needed in your report. There are a whole host of optimizations that can be done to reduce the datset (PBIX) file size.

Here are some great details: https://www.bluegranite.com/blog/how-to-improve-power-bi-performance-part-one