PowerBI Desktop - refresh too long under evaluating

[leandroduarte]

Dear Colleagues,

I'm facing issues with Desktop with refresh taking too long.

Basically it a simple model with one excel table of about 200mb without any data transformation in PowerQuery and it is keep under evalating for at least 1-2 minutes, after it start to refresh.

The model contains this excel and other SQL tables.

Could you please assist with some ways to speed up this process? Please see in this picture the status:

[v-yingjl · Accepted solution]

Hi @leandroduarte ,

Too large data model and complex relationships could cause power bi load data models slowly.

Besides trying to disable Auto detect relationships in power bi, you can try to reduce the size of your data model for unnecessary data, optimize data types etc.

Plesae refer these documents about optimize data model in power bi:

1. Data reduction techniques for Import modeling 
2. Optimization guide for Power BI 
3. Optimize a model for performance in Power BI  

Best Regards,
Yingjie Li

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

[themistoklis]

@leandroduarte 

Disable the following properties:
- File -> Options and Settings -> Options -> Data Load - > "Import relationships from data sources" and "Autodetect new relationships after data is loaded"

- Disable privacy check for the report
- Clear PBI Desktop cache
- Refresh all queries in preview
- Clean cache then refresh all in preview