PBI Evaluating时间太长

Multiple calculations(complex measures and calculated columns) in large dataset will eat up much CPU and memory . In your scenario, there are some proposals for you troubleshooting such performance issue.

1. Use the latest version of Power BI Desktop(2.42.4611.901).

2. Untick the following options in your current PBIX file. You can go to File -> Options and settings -> Options->CURRENT FILE(Data Load) to find the options.
1.PNG

3. Follow the guide in this blog to disable Load for these intermediate queries in your PBIX file to save memory.

4. Optimize your data model by following  the tips in the articles below.
  Data Import Best Practices in Power BI
  Power BI Performance Tips and Techniques

5. Use a faster computer with bigger memory would help in your scenario.

 

ref：https://community.powerbi.com/t5/Desktop/Microsoft-Mashup-Evaluation-Container-is-killing-my-box-PowerBI/td-p/120441

https://blog.crossjoin.co.uk/2019/03/26/power-bi-caching-parallelism-and-power-query-refresh-performance/

posted @ 2023-04-04 16:53  po-A  阅读(151)  评论(0)    收藏  举报

Tushare大数据开放社区-免费提供各类金融数据和区块链数据 , 助力智能投资与创新型投资。

Python, Matlab, R, Web数据抽取学习交流。