Power Bi data source connection for paginated report

[RajeshZZ424]

I have paginated report using Azure SQL database. We have created report using the stored proc and published the report. The user who created the report and published left the project and I have taken the owner ship and tried updating the credentials. but it not working i have checked those are same credentials perviously used as well but i am unable to establish the connection to the datasource getting below message while connecting.

I am using below connection method.

Please provide your suggestion this problem.

regards,

Rajesh

[v-luwang-msft · Accepted solution]

Hi  @RajeshZZ424 ,

From your error, it looks like the IP address does not have access to your SQL, you need to configure the client's firewall to allow access to.

Detail operations refer :

https://stackoverflow.com/questions/8543653/windows-azure-client-with-ip-address-xxx-xxx-xxx-xx-is-n... 

https://docs.microsoft.com/en-us/answers/questions/336084/azure-data-factory-sql-connectivity-error-... 

And you could refer the below blog:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/configuring-the-firewall-for-clie...

Here are couple of helpful resources related to connectivity issues and ADF Managed Virtual Network with Private Endpoint.

• Troubleshooting connectivity issues and other errors with Azure SQL Database and Azure SQL Managed I...

• Azure SQL Database and Azure Synapse IP firewall rules

• Managed Virtual Networks and Private Endpoints in Azure Synapse and Azure Data Factory

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien