Power BI - Getting Data
Which of the following is the correct way to specify the server name when connecting Power BI to SQL Server?
Which of the following is the correct way to specify the server name when connecting Power BI to SQL Server?
easy📝 Formula Fix Q12 of 15
Step-by-Step Solution
Solution:
Step 1: Recall SQL Server instance naming
SQL Server uses backslash \ to separate server and instance names.Step 2: Match correct syntax
The correct format is ServerName\InstanceName, not with slashes or dots.Final Answer:
ServerName\InstanceName -> Option BQuick Check:
SQL Server instance separator = \ [OK]
Quick Trick: Use backslash \ between server and instance [OK]
Common Mistakes:
- Using forward slash or dot instead of backslash
- Omitting instance name when required
- Adding spaces around the backslash
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes