What does Creating connection in model... do on Refresh when SQL Server columns are added?

[Anonymous]

What does Creating connection in model... do on Refresh when SQL Server columns are added?

When columns are added to tables on SQL Server databases, then refreshing reports with DirectQuery can take minutes to complete or never complete.

How can I speed it up? Which settings are related to Creating connection in model...?

[Anonymous]

Hi @Anonymous 

I think you may need to optmize your data model to speed it up.

You may refer to this blog: Optimization guide for Power BI

Best Regards,

Rico Zhou

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

[lbendlin]

That's a relatively recent addition. Power Query is trying to fetch meta data from the source. 

https://blog.crossjoin.co.uk/2020/07/05/why-is-power-bi-running-my-sql-query-twice/

One recommendation is to disable all relationship related options in the data load settings, and the data type sensing options too.