Forum Discussion
unable to create connection on Synapse SQL serverless DB
Hi Team ,
I am unable to create connection on Synapse SQL serverless DB from PowerBI service .
Kinldy help
Hi AOD ,
Since public access is disabled, Power BI cannot directly connect to Synapse Serverless. To enable access while keeping public network access disabled, consider the following solutions:-
Since public access is disabled, your Synapse Serverless database needs a Private Endpoint within your Virtual Network. This ensures a secure connection without exposing it to the public internet.
-
If Power BI Service is outside your Virtual Network, you may need to install an On-Premises Data Gateway inside the VNet. This gateway acts as a bridge, securely connecting Power BI to Synapse through the Private Endpoint.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Regards,
Pallavi.-
8 Replies
Hello AOD ,
Could you demonstrate the error message?Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |Hi Gökberk ,
Thanks for replying . I am getting below error while creting connection ,
I got below details from our Synapse Environment to which I needs to access data from.
1. Tenant ID (Directory ID) - got it from Active Directory Overview2. Service Principal ID (Application ID) Portal, Got it from App registrations.
Created new App
3. Service Principal Key (Client Secret) - Created new secret from App Registration . Thanks.Hi AOD ,
Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.
It looks like there is an issue with the Service Principal’s authentication while trying to connect Power BI Service to your Synapse SQL Serverless database. To resolve this, please follow these steps to ensure the connection works smoothly:
-
Assign Synapse Administrator or Synapse Contributor roles to the Service Principal in Azure Synapse's Access Control settings.
-
Ensure Azure Synapse's security configuration has Azure Active Directory authentication enabled.
-
Verify that the Tenant ID, Service Principal ID, and Client Secret are correct, ensuring the Client Secret is active and unexpired.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Regards,
Pallavi.Hi ,
Thanks for response. all above settings is in place. I am getting below error , as we have disbled public access . Is there any other way to access without enabling public access
Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
Details: Microsoft SQL: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny Public Network Access is set to Yes To connect to this server, use the Private Endpoint from inside your virtual network
-
Hi AOD ,
I wanted to check in on your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply that helped you or sharing your solution. It would be greatly appreciated by others in the community who may have the same question.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi AOD ,
I wanted to follow up on our previous suggestions regarding connection on Synapse SQL serverless DB. We would like to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank youHi AOD ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.
