Power BI Data Import Playbook

by Rory Neary

Connecting to data is often the first place to begin when starting a new Power BI report. This course will teach you the skills and techniques for connecting to a wide range of data sources from Power BI.

What you'll learn

Every Power BI report starts with data, which can be housed in a multitude of ways. In this course, Power BI Data Import Playbook, you’ll learn fundamental skills for making and using connections to sources of data in your reports. First, you’ll explore how data importation fits within the context of building a simple end to end Power BI report. Then, you'll delve into other data sources starting with structured sources such as databases all the way through to unstructured ones including Excel and web data sources. Finally, you'll learn about data privacy and even get to discover how to create tables from thin air using DAX (Data Analysis Expressions). When you’re finished with this course, you’ll have the skills and knowledge of Power BI data importation needed to enable you to begin building insightful Power BI reports.

Table of contents

Course Overview
2mins
Understanding How Import Fits within the Power BI Model Production Process
6mins
Connecting to Databases, Data Warehouses, SSAS Cubes, and Power BI Data Models Using Power BI
10mins
Configuring Privacy Levels for Data Sources
7mins
Connecting to Online Sources Using Power BI
4mins
Connecting to SharePoint Data
4mins
Connecting to Text and CSV Data Sources from Power BI
7mins
Loading Data Using an R Script
3mins
Storing and Connecting to Your Office 365 Data Files
10mins
Using Blank Queries to Create Data Tables
4mins
Entering Your Own Data by Hand
4mins
Creating Tables from Thin Air
11mins
Course Wrap Up
3mins

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.

Ready to upskill? Get started