Forum Discussion

AOD's avatar
AOD
Helper 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.

     

     



Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

AOD's avatar
AOD
Helper 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.