From the course: Managing Data with Microsoft 365
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Importing data in Power BI
From the course: Managing Data with Microsoft 365
Importing data in Power BI
- [Instructor] Reports need data. Before you can create visualizations and gain insights, you'll need to be able to import datasets into Power BI. In this lesson, I'll walk you through two ways that you can import data into this powerful software. You can install Power BI on your PC by going to the Microsoft Store and searching for Power BI. When you open Power BI Desktop, you'll see the start screen. I'll go ahead and close it. The first way to import data for your reports is from an Excel spreadsheet. In this example, I am importing a list of customers from Excel. There are two ways to do this. You can either select Excel workbook in the ribbon near the top of the screen, or import data from Excel from the Add Data menu. I'm going to select Excel workbook from the home ribbon. This brings up a dialogue where I can select the spreadsheet I want to import. I'm going to open the customer file. You can download this in the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.