Direct Query or Import

[Anu]

When is it that we need to go for direct query? I know when the data is large,but what is the approximate size limit for import mode?

[ankit]

Hi @Anu

Below link provide information on when Direct Query shall be used.

DirectQuery in Power BI - Power BI

Also, find some differences in below link

https://www.cittabase.com/blog/power-bi-tips-import-vs-direct-query/

Let me know if you have any specific question regarding this.

Thanks
Ankit Jain