Forum Discussion
Data optimization
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.
4 Replies
Anonymous , difficult to tell without looking into the details
refer if these two can help
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.
