Forum Discussion
Power Bi data source connection for paginated report
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
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 :
And you could refer the below blog:
Here are couple of helpful resources related to connectivity issues and ADF Managed Virtual Network with Private Endpoint.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
1 Reply
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 :
And you could refer the below blog:
Here are couple of helpful resources related to connectivity issues and ADF Managed Virtual Network with Private Endpoint.
Did I answer your question? Mark my post as a solution!
Best RegardsLucien