Get Data From An Excel Spreadsheet with Power BI
Lab
Beginner
0 h 30 m
2020-03-04
Lab Overview
In this lab, you will learn the basics of acquiring data using Power BI Desktop. You will import Excel files into Power BI Desktop and transform the data. You will use Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites and then cleanand shape the data with Power Query/M.

Related Learning Path(s):
Business Intelligence with Power BI
Objectives
  • Using Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites
  • Cleansing and shaping data with Power Query/M
Pre-Requisites
  • Fundamentals of Power BI
Exercises
In this exercise, you will import multiple worksheets from an Excel file into Power BI Desktop, then you will use Power Query to shape tables and transform columns.
Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs provide a live environment to get hands-on experience using the same tools and services in the real world.


Learn More