From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Import sales territory data

Import sales territory data - Power BI Tutorial

From the course: Complete Guide to Power BI for Data Analysts by Microsoft Press

Start my 1-month free trial Buy for my team

Import sales territory data

“

- [Instructor] Okay, so let's continue the journey of getting data into our Power Query editor that's going to help support sales analysis. So the next piece of data that we're going to bring in is sales territory data. So once again, we ask around, does anybody have sales territory data that shows how our individual territories are laid out and the countries that we have? And somebody says, "Yes, we've got that. "I've got this file here for you." All right, so let's go ahead and connect into that. So I'm going to click on New Source and this time what we're going to do is we're going to click Excel Workbook. So we're going to open up the Excel workbook and the sales territory file is this one here called Sales Territories. We'll go ahead and click Open. Power Query is taking a look at the contents of the file to see what it can connect into. And over here on the left, we're going to see we have one option. We can connect into the sheet called Sheet1. Then we have a preview of what…

Contents