© 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 
(1)
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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.