cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Import Vs DirectQuery Performance

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

2 REPLIES 2
Highlighted
Super User VII
Super User VII

Re: Import Vs DirectQuery Performance

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

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Microsoft
Microsoft

Re: Import Vs DirectQuery Performance

Hummm

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

 

Good idea !i'll try it.

 

 

Thanks.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors