This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 88%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Hi,
I'm currently working on the PL-300 "Get Data in Power BI" lab. When I connect to localhost via Power BI Desktop, the SQL Server only shows AdventureWorksDW2022, which doesn’t contain the tables required for the lab (e.g. DimEmployee, DimProduct, FactResellerSales).
The lab instructions refer to AdventureWorksDW2020, but it's not available. Could you please advise how I can access the correct database or ensure the expected lab environment?
TiA,
Laura
Additional SQL Server features and topics not covered by specific categories
Answer recommended by moderator
Solved – AdventureWorksDW2020 Not Showing
Just to follow up — I got it working by manually restoring the AdventureWorksDW2020 database using SQL Server Management Studio and the .bak file from GitHub. After that, Power BI picked it up with no issues.
Hope that helps someone else!
Laura
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 45%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
where did you store the .bak file?
Post your question in the Power BI community:
https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi