Forum Discussion

AOD's avatar
AOD
Icon for Helper III rankHelper III
1 year ago
Solved

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   
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

     

     



AOD's avatar
AOD
Icon for Helper III rankHelper III
1 year ago

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 
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.