Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreThe FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now
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
Solved! Go to Solution.
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...
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!
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 52 | |
| 44 | |
| 44 | |
| 20 | |
| 19 |
| User | Count |
|---|---|
| 71 | |
| 70 | |
| 34 | |
| 33 | |
| 31 |