Forum Discussion
unable to create connection on Synapse SQL serverless DB
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.-
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 Overview
2. 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 networkHi 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.-
-