Power Bi data source connection for paginated report

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-not-allowed-to-access-t 

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

And you could refer the below blog:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/configuring-the-firewall-for-client-access/ba-p/368780

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 Instance

• 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