cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Partisan
Post Partisan

Clean up previous data posted in a dashboard?

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]

sohananahid_0-1605029734470.png

 

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. 😊

1 ACCEPTED SOLUTION
Microsoft
Microsoft

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.

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

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.

View solution in original post

Super User II
Super User II

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors