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

[Anonymous]

I am loading CRM dynamics data. Anyone who can help to provide an explanation or trouble shooting manual for this issue?

[v-jingzhang]

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.