Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Jeanxyz
Impactful Individual
Impactful Individual

how to connect to a sql db in localhost

I'm preparing for DP 600 exam, in the exercise lab, I was asked to download a pbix file and log into the data sources using my work or school account. I followed the steps and used Windows authenification method, which caused an error (see below). 

Looking into the Power Query data source, I got quite confused. It looks PB is trying to import data from a sql database stored in localhost, but shouldn't we create such a database in SSMS local host first?

Below is the exercise lab with download url: https://microsoftlearning.github.io/mslearn-fabric/Instructions/Labs/17-enforce-model-security.html

Screenshot 2025-05-13 121309.png

1 ACCEPTED SOLUTION
BIswajit_Das
Super User
Super User

Hello @Jeanxyz 
I'm not sure if this is gonna helpfull or not but you should check out this page
https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16...

Thanks & Regard...

View solution in original post

2 REPLIES 2
BIswajit_Das
Super User
Super User

Hello @Jeanxyz 
I'm not sure if this is gonna helpfull or not but you should check out this page
https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16...

Thanks & Regard...

Thanks a lot. I installed SSMS and SQL server, changed the importing parameter in the pbix file to match my SMSS instance name and it works!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.