Import Vs DirectQuery Performance

[nkasdali]

Hi All,

I think this question has come back quite a few times, but I have found no clear answer to my question.

I know the difference and the limitations of each mode, I just want to find the most efficient for my use.

Starting from the idea that I have a report that is used by hundreds of people at different times of the Day.

The import allows me to have all my dataset in memory, so it can easily respond to a high demand. however, the data will be stored in Azure.
now, If I use Direct Query, it will create a large exchange with my database because of the number of people who consult my report.

In this situation I have a preference for import Mode.

Am I right?

regards

[parry2k]

@nkasdali you can also consider composite mode where you have mostly used measures are in import and rest can be direct query.

[nkasdali]

Hummm

So you suggest that my fact table will be in Import and others dimensions in DirectQuery ?

Good idea !i'll try it.

Thanks.