Simple play icon Course
Skills Expanded

Connect Power BI to Additional Data Sources

by Rory Neary

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.

About the author

A Microsoft Power Platform Trainer Developer with a finance background and a deep passion to help businesses realize their potential with The Microsoft Power Platform. Rory has been working in the Power Platform since the early days of Power BI and has trained people across Europe in that time, from Italy up to Iceland and from Ireland across to Finland. An accountant by trade, he has worked both as a contractor, trainer and a consultant in the Power Platform space for many years and has seen ... more

Ready to upskill? Get started