Adventureworks 2012 import into Power BI

[LaurenceSD]

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?

Thanks

[FrankPreusker]

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)

[LaurenceSD]

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

[v-easonf-msft · 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

[LaurenceSD]

perfect, thanks very much!

[FrankPreusker]

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