From the course: Power BI Data Methods (2019)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Comparing data connection modes
From the course: Power BI Data Methods (2019)
Comparing data connection modes
- [Instructor] Earlier we saw the following Data Connection Modes for databases. Import, DirectQuery and Live. In the cloud services, we can also leverage the Push mode. In the future, Microsoft will continue to develop and improve the connection options available for all these Data Connection Modes. A recent update to Power BI Desktop allows us to connect to both DirectQuery and Import in combination for different queries in the same file. We use Import as the typical default data connection type. Microsoft recommends this method because it takes advantage of the high performance query engine and allows for us to leverage the full range of options for working with data. DirectQuery allows us to connect to data in it's original source repository. This option works best when the underlying data provides interactive queries returning data in less than five seconds, or if this data changes frequently and we need the latest…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.