-
Course
- Data
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
About the author
A Microsoft Power Platform Developer with a finance background and a deep passion to help businesses realize their potential with Office 365.
More Courses by Rory