Forum Discussion
PowerBI Desktop - refresh too long under evaluating
- 5 years ago
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:
- Data reduction techniques for Import modeling
- Optimization guide for Power BI
- Optimize a model for performance in Power BI
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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