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.

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.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors