performance with live/not-live connections

[poojakarora]

Hi,

I want to create a live connection to one of the tables and on other tables i donot intend to have live connection. Does that affect the query folding on the non-live connection tables?

[v-jingzhang]

Hi @poojakarora 

You can connect to only one model with Live Connection and cannot add other data sources in the same report. Do you mean using DirectQuery and Import tables in the same model? If so, the DirectQuery table will not influence the query folding on other tables.

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