Refreshing of only Delta data in Power BI model

[Harsh]

Hello @Avenkataanusha,

I’m providing a link below where a member had asked onto the Forum whether they should go for the DirectQuery or DataImport option and we’d a great discussion at length on this topic where some good points were exhanged.

I’m providing a link below of that post.

Hoping you find this useful and helps you to choose the better option in your scenario.

Note: Please click onto the link to view the entire post and not on the expand/collapse button.
.
Thanks and Warm Regards,
Harsh

Performance comparison between DirectQuery & DataImport

Hi there, Currently I am helping my client to convert a DataImport PBIX to use DirectQuery instead. This is to avoid data storing in cloud. We have timing on Data Import report at this point. – Which is performing faster - expected. Now we are having a hard time to gauge performance on DirectQuery in general. (this is a general comparison. Do know that performance is a lengthy and tricky topic. Let’s assume that we are using the same measure/visual for timing comparison. Queries/DAX are tune…