© Reza Rad 2018
Reza RadPro Power BI Architecturehttps://doi.org/10.1007/978-1-4842-4015-1_8

8. Choosing the Right Connection Type

Reza Rad1 
Meadowbank, Auckland, New Zealand

Power BI supports different methods for connecting data. That is why the decision to choose the right way is always a tough decision. You have heard of DirectQuery, Live Connection, and Import Data. What do these three mean? And what is the situation that you should choose one over the other? What are the pros and cons of each? What are the best practices to choose each? Which one is faster? Which one is more flexible? Is DirectQuery and Live Connection one thing? Or two separate methods? And many other questions. I always get a lot of questions like this in my courses, ...

Get Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.