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
RicardoPerezGonalves-5891 1 Reputation point

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

Very good, Thanks so much!
RicardoPerezGonalves-5891 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.

Answer accepted by question author

ZoeHui-MSFT 41,551

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.

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

5 additional answers

Philip O'Donnell 26 Reputation points

2020-10-19T10:32:24.517+00:00

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
Was this answer helpful?
ZoeHui-MSFT 41,551 Reputation points

2020-10-20T01:29:36.33+00:00

Hi @Philip O'Donnell ,

In this https://learn.microsoft.com/en-gb/learn/modules/get-data/lab-prepare, you may see an opinion named "launch tab"

Click it there will be a new pop window, you could have a online exercise and in this exercise, you may use the AdventureWorksDW2020 provided by the tutorial.

And then you could use the table "DimEmployeeSalesTerritory" which is shown in my picture.

In short, if you want to use the AdventureWorksDW2020, you should launch tab and do the exercise online.

I think you could Unaccept your answer and mark my reply below as "Accept Answer" and then we may close the case.

Millions thanks!

Luis J. Moran Cuenca 1 Reputation point

2021-09-09T20:52:34.877+00:00

Thank you, it runs
Sign in to comment

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

AdventureWorksDW2020 DB is missing a table

5 additional answers

Your answer