Power BI - Getting Data
Which authentication method can you use when connecting Power BI to a SQL Server?
Which authentication method can you use when connecting Power BI to a SQL Server?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify supported SQL Server authentication methods
Power BI supports Windows Authentication and SQL Server Authentication for connecting to SQL Server.Step 2: Match the correct authentication method
Windows Authentication is a common and supported method for SQL Server connections in Power BI.Final Answer:
Windows Authentication -> Option BQuick Check:
Supported authentication = Windows Authentication [OK]
Quick Trick: Use Windows Authentication for seamless domain login [OK]
Common Mistakes:
- Choosing unsupported authentication types like OAuth
- Confusing Power BI authentication with device biometrics
Master "Getting Data" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes