Connecting to Different Data Sources in Power BI

Connecting to Different Data Sources in Power BI starts by looking at the pros and cons of Import and Direct Query storage modes. We then see how those storage modes can be combined in different composite model architectures to address their respective shortcomings and specific scenarios.  Along the way, we’ll see how Power BI can protect sensitive source data and how a model can be shared. 

Learning Objectives 

• Data storage modes 

• Connecting to data sources 

• Changing data sources 

• Sharing data sources 

Intended Audience 

This lesson is for students wanting to understand how Power BI stores data and handles different types of data connections. 

Prerequisites 

• Familiarity with Power BI desktop and the Power BI service.  

• Completion of the lesson on Loading Data into Power BI.