Power BI - Getting Data
In Power BI, how should you format the SQL Server name if you need to connect to a named instance called SQL2019 on server DBServer01?
In Power BI, how should you format the SQL Server name if you need to connect to a named instance called SQL2019 on server DBServer01?
easy📝 Formula Fix Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Understand SQL Server instance naming
Named instances are specified by appending a backslash and the instance name to the server name.Step 2: Apply correct syntax in Power BI
Power BI expects the server name in the formatServerName\InstanceNameto connect to a named instance.Final Answer:
DBServer01\SQL2019 -> Option BQuick Check:
Backslash is the standard separator for named instances [OK]
Quick Trick: Use backslash for named instances in server name [OK]
Common Mistakes:
- Using colon or slash instead of backslash
- Reversing server and instance names
- Omitting the instance name
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes