AdventureWorksDW2020 DB is missing a table

Philip O'Donnell 26

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

Thomas LeBlanc 481 Reputation points

2020-10-19T14:29:09.883+00:00

There has never been a table named DimEmployeeSalesTerritory in the AdvWorks DW database. There is a DimSalesTerritory table in all versions I know of. There is a foreign key from the DimEmployee table to the DimSalesTerritory table. Maybe the Power BI teaching imported the DimSalesTerritory and renamed to DimEmployeeSalesTerritory because the DimSalesTerritory table is used in multiple relationships in the AdvWorks DW database.

Or, perhaps someone has created a view called DimEmployeeSalesTerritory like:

CREATE VIEW [dbo].DimEmployeeSalesTerritory
AS
SELECT *
FROM dbo.DimSalesTerritory
GO
Philip O'Donnell 26 Reputation points

2020-10-19T14:50:52.497+00:00

ThomBeaux

Thanks for that.

Also, thanks to Zoehui-MSFT.

I'll accept the answer, i.e. close it.

Regards

Philip
Ricardo Perez Gonçalves 1 Reputation point

2021-09-14T20:32:29.503+00:00

Very good, Thanks so much!
Ricardo Perez Gonçalves 1 Reputation point

2021-09-14T20:37:24.737+00:00

Really, I see too, The documentation it's diferent of the database AdventureWorksDW2020, but the solution's ThomBeaux solve the problem until here.

Accepted answer

ZoeHui-MSFT 40,056 Reputation points

2020-10-19T02:41:55.38+00:00

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.
Please sign in to rate this answer.

1 person found this answer helpful.
Stuart Mitchell 16 Reputation points

2022-02-28T13:47:21.143+00:00

As has been stated, the AdventureWorksDW2020 in the lab contains those tables. If you download the DA100.zip from the lab environment you can use the .bak file in DA100\DatabaseBackup folder. That is, asssuming you have access to a SS instance and permissions to restore databases.

Despite what MSFT said, it's easier to do offline. The labs kept dropping out. Also be aware that the lab instructions require you to do some mental gymnastics. The numbering of the lab directories don't all match the lab number. Also there are some constructs in the instructions, particularly one TOPN expression, that are patently incorrect.

If you can get through the labs with all the omitted steps and errors you will be learning heaps.

Mauricio Hidalgo 1 Reputation point

2022-03-10T01:33:49.72+00:00

Hello StuartMitchell-0876

I have this problem and i dont know if you can help me with this.

1.- In the same PowerBI lab (adventureworksdw2020-db-is-missing-a-table.html

I need to get data from this folder (i need to download a .csv file) but here is no folder in there

Can you or anyone help me with this please because i don't know what file i have to download from the documentation Zoe shared with us. (adventureworks-install-configure
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

5 additional answers

Scott Hay 15 Reputation points

2025-01-21T14:55:54.0433333+00:00

The way to resolve this issue in 2025 is to download the files for the PowerBI training - https://github.com/MicrosoftLearning/PL-300-Microsoft-Power-BI-Data-Analyst/raw/Main/AllfilesDownload.zip - and then restore the AdventureWorksDW2020.bak file that is in the DatabaseBackup folder. You will then have the version of this database with the DimEmployeeSalesTerritory table.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

AdventureWorksDW2020 DB is missing a table

5 additional answers

Your answer