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.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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