This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 11%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
Hi Team,
We are getting the error "The target principal name is incorrect. Cannot generate SSPI context" when we try to connect to Power Bi thru azure SQL Server .
Regards,
Hareesh B
Hi, @Balasala Hareesh I am checking to see if you got a chance to look into the below responses. Please let us know if you have any further questions.
If this answers your question, please consider accepting the answer by hitting the Accept answeras it helps the community look for answers to similar questions.
Regards
Geetha
The error message means, you try to logon with Windows Authentication over Kerberos and that fails, because SPN = "Server Principal Name" isn't correctly registered.
Ask your IT admin to fix it or use Microsoft® Kerberos Configuration Manager for SQL Server®
Please make sure firewall rules for the database are configured to "Allow access to Azure services" as you can see on below image, and you would need to set up a firewall rule to allow the public IP address used by Power BI to make a connection. Also make sure you choose Database authentication mode in Power BI Desktop, and enter server admin account and password or a SQL user rather than AD account to connect to the Azure SQL database,
Make sure also you specify not only the Azure SQL server name (yourservername.database.windows.net) and the database name in that server when connecting to Azure SQL from Power BI.