Missing Tables in AdventureWorksWD 2020 Database

Question

I am currently working through the Power BI training and following the provided instructions to connect to the AdventureWorksWD2020 database. However, I have encountered an issue where several expected tables, including DimEmployee are missing.

Here’s what I have done so far:

1. Downloaded the database from the provided link.
2. Successfully restored it in SQL Server and verified that the database exists.
3. Checked for available tables using INFORMATION_SCHEMA.TABLES but only found FactInternetSales.
4. Attempted to re-download and restore the database, but the same issue persists.

Since the instructions specifically reference AdventureWorksDW2020 I want to confirm whether the correct database file has been provided. Could you please verify the database contents or provide guidance on how to access the missing tables?

Looking forward to your assistance.

Answer 1

Hi Val,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer. 

Ask: Missing Tables in AdventureWorksDW2020 Database

Solution: The issue has been resolved. Ensure you follow the module instructions, re-download, and restore the database correctly.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information. 

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue. 

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.