Tecflix

Connecting to Data Sources (2018 Updates) Purchase the entire course

21 December 2018 · · 216 views

Power BI Course

Connecting to Data Sources (2018 Updates)

This video contains new content that is related to the Connecting to Data Sources section, and covers new features that have been added in late 2018.

Composite models allow you to do two new important things: have multiple DirectQuery data sources in the same model, and to mix DirectQuery and Import data sources in the same model. This brings a number of benefits: not only does it give you more flexibility for modelling when you’re working in DirectQuery mode, but it will also improve query performance because if the data in a table does not change much you can use Import mode. It will also improve refresh performance because you can use DirectQuery mode for large tables where query performance is less important.

A related feature to composite models is aggregations. This feature helps query performance by allowing you to store pre-aggregated data in Power BI, which can then be used by Power BI when it runs queries that request aggregated values from another table. It will be particularly important when you have a large table stored in DirectQuery mode because you will be able to store pre-aggregated data for that table in Import mode.

Finally, incremental refresh allows you to avoid having to refresh all the data in a table when you do a refresh—instead, it allows you to just refresh the data in a table which you know has changed. At present, this feature is only available in Power BI Premium.

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

$480/year

Access all content on this site for 1 year.
Purchase
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