cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LaurenceSD
Helper II
Helper II

Adventureworks 2012 import into Power BI

Hi,

 

I'm doing an SQL course and I've got the Adventureworks 2012 database saved on my laptop, but I'm struggling to import it into Power BI. Is anybody able to point me in the direction of how I can navigate to this database?

 

LaurenceSD_0-1620204115740.png

 

Thanks

 

1 ACCEPTED SOLUTION

Hi, @LaurenceSD 

Of coures. Please refer to this  tutorial.

Refresh data from an on-premises SQL Server database

Make sure you restore the .bak to the database correctly.

 

It is recommended to download Download SQL Server Management Studio (SSMS) integrated environment, it will better help you manage your database.

 

Best Regards,
Community Support Team _ Eason

View solution in original post

5 REPLIES 5
FrankPreusker
Advocate III
Advocate III

You can actually download the Adventure Works database as a prepared PowerBI files from Github: powerbi-desktop-samples/DAX at main · microsoft/powerbi-desktop-samples (github.com)

thanks, @FrankPreusker out of curiosity is it possible to connect to an SQL Database saved on a local machine?

Hi, @LaurenceSD 

Of coures. Please refer to this  tutorial.

Refresh data from an on-premises SQL Server database

Make sure you restore the .bak to the database correctly.

 

It is recommended to download Download SQL Server Management Studio (SSMS) integrated environment, it will better help you manage your database.

 

Best Regards,
Community Support Team _ Eason

View solution in original post

perfect, thanks very much!

Probably, but I don't have experience with that.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.