Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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:
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.
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:
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |