Power BI - Getting Data
You want to connect Power BI to a SQL Server database but only have the server IP and a custom port number 14330. How should you specify the server in the connection dialog?
You want to connect Power BI to a SQL Server database but only have the server IP and a custom port number 14330. How should you specify the server in the connection dialog?
hard📝 Scenario Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Understand SQL Server port specification
SQL Server uses comma ',' to specify a custom port after the IP address.Step 2: Identify correct syntax for server and port
The correct format is IP address followed by comma and port number.Final Answer:
192.168.1.10,14330 -> Option DQuick Check:
Custom port syntax = IP,Port [OK]
Quick Trick: Use comma to specify port after IP in SQL Server connection [OK]
Common Mistakes:
- Using colon or slash instead of comma for port
- Using backslash which is for instance names
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes