Forum Discussion

poojakarora's avatar
poojakarora
Regular Visitor
5 years ago

performance with live/not-live connections

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?

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    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.