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 23,200 courses taught by industry experts.

Import the other countries' sales data

Import the other countries' sales 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 the other countries' sales data

“

- [Instructor] Okay, so we ended off the previous lesson on the Power BI desktop. So if I want to work my way back to the Power Query Editor window, off the home tab, I just simply click transform data and this takes us back to the Power Query Editor window. So in this sub-lesson what we're going to do is we want to import the other countries' sales data. And the way this data is delivered to us is rather unique. So what I'm going to do here is just show you the folder structure for the way that the data is delivered. Okay, so if I look at the folder structure, which we have, we earlier grabbed the United States sales data from this folder here. So this is the file we connected to earlier and imported into the Power BI desktop. So over here we have this folder called Other Countries and these are all the other countries in which AdventureWorks does business. So if I just navigate into this folder, we'll see that we've got files that are from Australia, Canada, France, Germany, and the…

Contents