Connecting to Data Sources Purchase the entire course

21 December 2018 · · 590 views

Power BI Course

Connecting to Data Sources

There are three ways that you can work with data in Power BI Desktop. First of all, the most commonly-used method is to import data into a dataset. This involves copying data from your data sources into Power BI’s own internal database. This gives you the fastest possible query performance and the ability to use all of Power BI’s features but it also has some downsides too: refreshing data can be slow, you have to refresh data regularly so that it stays up-to-date, and there are limits on the amount of data you can import into a dataset.

Secondly you can create a live connection to SQL Server Analysis Services. The benefits of doing this are that you can work with much larger data volumes, refresh data much more frequently, and have a single place to store all of the data for your reports. However this centralisation can be too inflexible for some users, who may need to model data in different ways, and of course buying and maintaining an instance of Analysis Services is expensive and time-consuming. Azure Analysis Services, a Platform-as-a-Service version of Analysis Services, is worth considering.

Finally you can use DirectQuery mode. DirectQuery is only available for some data sources, such as relational databases, and in this mode a dataset is created inside Power BI but it stores no data: whenever Power BI queries the dataset, the dataset in turn requests data from the original data source - for example by generating SQL queries against a relational database. The good thing about DirectQuery is that the data in your reports is always up-to-date, but it also tends to give the worst report performance and some Power BI features are not available when you use it.

In Power Query/Get & Transform in Excel you can only import data into the Excel Data Model, the equivalent of a Power BI dataset. Excel also has the ability to create the equivalent of live connections to Analysis Services, but DirectQuery is not available in Excel. It is possible to connect to some data sources from the Power BI service in a browser too.

Log in or purchase access to play the video.

  • Power BI New Features and Course Updates 1-min Free—Watch Now

  • What is Power BI? 59-min Watch with Free Subscription

  • Licensing 8-min

  • Connecting to Data Sources 42-min

  • Connecting to Data Sources (2018 Updates) 23-min

  • Data Import Concepts 55-min

  • Transforming Data with the Query Editor 1-hour 20-min

  • Transforming Data with the Query Editor (2018 Updates) 13-min

  • Advanced Data Loading 49-min

  • Modelling Data 1-hour 10-min

  • Modelling Data (2018 Updates) 14-min

  • DAX and the Data Model 31-min

  • DAX and the Data Model (2018 Updates) 10-min

  • Power BI Desktop vs Excel 37-min

  • Cloud and Desktop Power BI Dashboards and Reports 45-min

  • Power BI Reports (2018 Updates) 40-min

  • Building Reports in Excel 32-min

  • Sharing, Distribution, and Security 42-min

  • Data Refresh 8-min Free—Watch Now

  • Administration and Auditing 11-min Watch with Free Subscription

  • Azure Analysis Services 1-hour 3-min

  • Power BI Premium and Power BI Embedded 36-min Watch with Free Subscription

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo