Connect Power BI to Additional Data Sources
This course will teach you how to connect to some very popular online data sources. You will also explore ways of introducing tables into your data model, including the use of queries, to those that don’t necessarily require external data sources.
What you'll learn
Every Power BI report starts with an essential process: pulling data from one or more data sources before creating a data model to generate insights.
In this course, Connect Power BI to Additional Data Sources, you’ll gain the ability to connect to a wide range of data sources and create tables within your Power BI reports.
First, you’ll explore how to connect to popular external data sources like Azure SQL databases, SharePoint, and Microsoft Dataverse.
Next, you’ll discover how to pull data from text, CSV files, Google Sheets, and online data sources like data.world.
Finally, you’ll learn how to create data tables with or without external sources by using query logic, manually entering data, leveraging R scripts, and utilizing DAX to generate tables.
When you’re finished with this course, you’ll have the skills and knowledge needed to confidently connect to diverse data sources and create tables within your Power BI data model.
Table of contents
- Connecting to Azure SQL Databases 5m
- Connecting to SharePoint Lists 4m
- Connecting to SharePoint Document Libraries 4m
- Connecting to Excel Documents Held in SharePoint 4m
- Connecting to Third-party Data Sources 4m
- Connecting to a Dataverse Database 7m
- Connecting to Text and CSV Data Sources from Power BI 3m
- Connecting to Google Sheets 4m
- Connecting Power BI to an OData Feed 6m