Power BI Data Import Playbook

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.
Course info
Rating
(55)
Level
Beginner
Updated
May 6, 2019
Duration
1h 46m
Table of contents
Course Overview
Understanding How Import Fits within the Power BI Model Production Process
Connecting to Databases, Data Warehouses, SSAS Cubes, and Power BI Data Models Using Power BI
Connecting to Databases through Direct Query
Configuring Privacy Levels for Data Sources
Connecting to Online Sources Using Power BI
Connecting to SharePoint Data
Connecting to Text and CSV Data Sources from Power BI
Loading Data Using an R Script
Importing Excel Data and Workbooks to Power BI
Connecting to Web Data Sources from Power BI
Storing and Connecting to Your Office 365 Data Files
Using Blank Queries to Create Data Tables
Entering Your Own Data by Hand
Creating Tables from Thin Air
Course Wrap Up
Description
Course info
Rating
(55)
Level
Beginner
Updated
May 6, 2019
Duration
1h 46m
Description

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.

About the author
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.

Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Rory Neary, and welcome to my course, Power BI Data Import Playbook. I'm a Power Platform consultant at DataSpinners. I've been working with data as an accountant analyst and developer for over 20 years. This course is relevant to almost every single Power BI report that has ever lived. Not only that, but connecting to data is very often the first place you're likely to begin when starting a new report. So, if you're starting out with Power BI, you've come to the right place. In this course, we're going to cover the creation of connections from Power BI to a very wide range of sources of data. Some of the major topics that we'll cover include connecting to databases, Excel files, connecting to online sources, and creating tables from thin air. By the end of this course, you'll know how to import data into Power BI and you'll also have an understanding of the importance of where to store your data files. Before beginning the course, you should be familiar with Windows operating system, and it will help to have an understanding of data modeling concepts, such as tables, fields, and relationships. You're also going to need an installation of the Power BI Desktop, which can be downloaded from powerbi.microsoft.com. From here, you should feel comfortable diving further into Power BI with courses on Retrieve, Transform, and Combine Data Using Power Query and Getting Started with DAX Formulas in Power BI, Power Pivot, and SQL Server Analysis Services. I hope you will join me on this journey to learn Power BI with the Power BI Data Import Playbook course, at Pluralsight.