Data optimization

[Anonymous]

Hi ,

I have done some data optimization usinf vertipaq analyzer and reduced the report size from 145MB to 80MB.

But still, the time taken for refreshing the data is high.taking 1 hr to do refresh.

Please suggest something to do here.

Last 4 Week filter 

[Anonymous]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

No, My problem is not solved yet.

Still working on it

[Anonymous]

Hi @Anonymous ,

According to my understanding, you want to know how to reduce the data refresh time in Power Bi Desktop,right?

When you do joins/appends in Power Query it has to load the entire table into virtual memory. This causes a lot of paging and is very slow. 

You could change your data model,  uncheck the Enable load option for the unnecessary table

For more information,you can refer to:

10 Performance tips to speed up your Power BI reports | LYTIX

Power BI Performance Tips and Techniques

Speed Up Data Refresh Performance In Power BI Desktop Using Table.View

Data reduction techniques for Import modeling - Power BI | Microsoft Docs

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

[amitchandak]

@Anonymous , difficult to tell without looking into the details

refer if these two can help

https://blog.crossjoin.co.uk/2020/05/14/speed-up-data-refresh-performance-in-power-bi-desktop-using-...

https://www.youtube.com/watch?v=nP-8_st1wWk