AdventureWorksDW2020 DB is missing a table

Question

Hi,

I'm trying to go through the PowerBI lab at this url:
https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare

I downloaded the AdventureWorksDW2020 from GitHub and loaded into SQL server management studio. 6 tables are mentioned in the lab:
DimEmployee
DimEmployeeSalesTerritory
DimProduct
DimReseller
DimSalesTerritory
FactResellerSales

But DimEmployeeSalesTerritory is not there. Note, AdventureWorksDW2017 was also mentioned but that table is not in that DB either.

Is there an updated version of AdventureWorksDW2020 that I can get that includes all the mentioned tables?

Thanks

Philip

Answer 1

Hi @Philip O'Donnell ,

The newest AdventureWorksDW is 2019, you may see in the documentation.

https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

The AdventureWorksDW2020 mentioned in the tutorial is based on the AdventureWorksDW2017 and has been modified to support the learning objectives of the course labs.So it is a bit different with the AdventureWorksDW2017 and you couldn't find the DimEmployeeSalesTerritory.

In this tutorial, you may need to launch the lab and then complete the exercises with the provided AdventureWorksDW2020.

I tried to log in to the lab environment and connect to the AdventureWorksDW2020, we could see the DimEmployeeSalesTerritory.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The table you look for is included in the AdventureWorksDW2020.bak file which is used in the DA-100 labs which are normally run inside the VM environment of the module. However, you can obtain it from a Microsoft Learning GitHub page which is apparently used to host all lab files. You can find it here: https://github.com/MicrosoftLearning/DA-100-Analyzing-Data-with-Power-BI/tree/master/Allfiles/DA-100-Allfiles/DatabaseBackup

You can download the .bak file from there, restore it to a localhost and then import it in a PowerBI that you run locally on your own computer (it's faster and less annoying than having to do it in the virtual lab)

[edit] Currently as I'm writing this, in the very first DA-100 lab (Lab - Prepare data in Power BI Desktop) you also need two .csv files (ResellerSalesTargets.csv and ColorFormats.csv), you will likely want these if you plan to do the labs on your local PowerBI installation rather than in the VM. You can find those here:
https://github.com/MicrosoftLearning/DA-100KO-Analyzing-Data-with-Power-BI/tree/master/Allfiles/DA-100-Allfiles/Resources

note: this is NOT the same as the backup files that Zoehui-MSFT links to, that is a 'cleaned up' version of the database, so you don't get to practise the material of the first labs.

Answer 3

Hi @ZoeHui-MSFT ,

Thanks for the reply. Much appreciated.

I downloaded and restored the AdventureWorksDW2019 file (because I can't see a ...2020 version) but there is no DimEmployeeSalesTerritory table there either. I'll attach an image.

One of your images shows adventureworksdw2020. Where did you get that file?

Regards

Philip

Answer 4

@ZoeHui-MSFT

I appreciate the clarification. I was following along on my desktop PowerBI, but it is much better to follow the lab from the PowerBi within the lab - which did indeed have the DimEmployeeSalesTerritory table.

I've unaccepted the answer that was accepted - which was too bad as the idea of creating a view to get through the lab was a good one.

I'm a newbie to posting such queries, so did not see a way to accept your latest post, but maybe it will be available when I post this.

Regards

Philip

Answer 5

@Maarten van Schaik

Thanks for the update. This was many months ago, and that course is long finished for me - so there is not much point in my commenting on it any more.