Creating connection in model takes forever / stuck when refreshing data with dataverse tables

Hi Anonymous 

 

How many tables are included in the model? Tables are evaluated parallelly. If your computer's memory resource is sufficient, you can try increasing maximum number of simultaneous evaluations and/or available memory per evaluation. See Evaluation configuration settings for Desktop - Power BI | Microsoft Docs

 

When some tables are being refreshed, other tables will be pending and waiting for them to be finished. Those pending tables will display "Creating connection in model". You can drag the scroll bar to find out which query is stuck on loading data. If it is always stuck on refreshing, copy this query to a new pbix file and refresh it separately to test whether this query is too slow. 

 

If some tables are static and don't need to be refreshed, you can uncheck the option "Include in report refresh". If some tables are not used in the report, you can uncheck the "Enable load" option to exclude them from the model. This can reduce the data size to be refreshed which can reduce the refresh time. Managing query refresh - Power BI | Microsoft Docs

 

Also, check if there are many empty columns and empty rows in the queries. Remove them in Power Query Editor. This would be helpful sometimes. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.