Getting Data from Azure SQL and Excel

Getting Data into Power BI from Different Sources looks at connecting to data sources on-premise, in the Azure cloud, and Power platform data sources. The lesson is focused on how various data sources can impact your data model's performance, rather than looking at every single source that Power BI accommodates, as there are literally dozens and dozens of them. Apart from typical database and file data sources we look at Dataverse, a power platform repository and data flow an online ETL service.

Learning Objectives

• How to connect to a database and file data source on-premises and in the Azure cloud
• How to change the location of a data source without reimporting the data
• Look at the pros and cons of each Power BI data storage mode
• User Power Platform's Dataverse product as a data source
• How to and why you would use a Data Flow as a data source
• Setting up and connecting to an XMLA endpoint

Intended Audience

• This lesson is intended for anyone who wants to get data into Power BI

Prerequisites

• An understanding of Power BI desktop and power BI online
• A Power BI premium account for XMLA endpoint, one of the more specialized data connection topics