If the server was created with private access, it has no public endpoint, so anything outside the private network cannot reach it. ADF and PBI will fail unless they are inside the same virtual network.
To fix it, you have only two options:
- Use private networking end to end
- Place ADF inside a Managed VNet and use an IR that can reach the MySQL private endpoint.
- For PBI, use PBI Gateway installed on a machine that has network access to the VNet.
If you need a public endpoint, you must create a new server with public access and migrate the data.
There is no workaround. The server’s network mode is fixed after creation.
Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.