Sign in to confirm you’re not a bot

This helps protect our community. Learn more

Import vs DirectQuery in Power BI

120K subscribers

72K views 4 years ago

Should you use Import or DirectQuery data connectivity mode for your Power BI models? Let's make the right choice by comparing the performance and scalability of the two options! Optimizing DAX video course: https://www.sqlbi.com/p/optimizing-da... How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

...more

...more

load from sql server

load data from the server into the internal database

enable the performance analyzer

Import vs DirectQuery in Power BI

1.3KLikes

72,077Views

2020Nov 19

Should you use Import or DirectQuery data connectivity mode for your Power BI models? Let's make the right choice by comparing the performance and scalability of the two options! Optimizing DAX video course: https://www.sqlbi.com/p/optimizing-da... How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

load from sql server

load data from the server into the internal database

enable the performance analyzer

Transcript

Follow along using the transcript.

SQLBI

120K subscribers