cannot connect to azure sql db from powerbi desktop

[nazneensaheer]

I can connect from SSMS to the Azure SQL db using entra authentication but not from powerbi desktop as getting this error

Each time we are getting below ERROR ,while Client IP is already added in azure portal

Details: "Microsoft SQL: Cannot open server 'xxxxx' requested by the login. 

[v-menakakota · Accepted solution]

Hi @nazneensaheer ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience,i would have read the question again sorry for that.
When connecting to an Azure SQL Database from Power BI Desktop, it's important to choose the correct authentication method to avoid connection issues. In the SQL Server connector, if your account uses Multi-Factor Authentication (MFA), you should select Azure Active Directory - Universal with MFA, which is the recommended option. If your account does not require MFA, then you can use Azure Active Directory - Password instead. Using the appropriate authentication method ensures a stable and secure connection, while avoiding common errors that can occur with options like "Organizational Account," which is not reliably supported for Azure SQL connections.

Once check the below screenshot and documentation for more information:

Azure SQL Database with DirectQuery - Power BI | Microsoft Learn

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[nazneensaheer · Accepted solution]

The solution that worked is Clear all global permissions from data sources and reconnect using powerbi desktop and select windows authentication

[v-menakakota]

Hi @nazneensaheer ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @nazneensaheer ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-menakakota]

Hi @nazneensaheer ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you

[nazneensaheer]

not worked with any of above and didnt find solution please help

[v-menakakota · Accepted solution]

Hi @nazneensaheer ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We really apologies for the inconvenience,i would have read the question again sorry for that.
When connecting to an Azure SQL Database from Power BI Desktop, it's important to choose the correct authentication method to avoid connection issues. In the SQL Server connector, if your account uses Multi-Factor Authentication (MFA), you should select Azure Active Directory - Universal with MFA, which is the recommended option. If your account does not require MFA, then you can use Azure Active Directory - Password instead. Using the appropriate authentication method ensures a stable and secure connection, while avoiding common errors that can occur with options like "Organizational Account," which is not reliably supported for Azure SQL connections.

Once check the below screenshot and documentation for more information:

Azure SQL Database with DirectQuery - Power BI | Microsoft Learn

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[nazneensaheer]

had installed latest powerbi desktop

added client/user IP to azure firewall rules and he can access db using ssms

[v-menakakota]

Hi @nazneensaheer ,

We really appreciate your efforts and for letting us know the update on the issue. If this is the solution that has worked for you please accept your reply as solution so as to help other community members who may face similar issue in the future. Please continue using fabric community forum for your further assistance.

Thank you and Regards,
Menaka Kota.