Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to connect to an Azure SQL server using Dataflows, however whenever I try connect i get the error "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".
is this a setting i need to change on the SQL server side? Also does this mean I need to access this from a managed private endpoint within Fabric?
Ive seen conflicting points within the documentation whether or not managed private endpoints can be accessed on a trial account
Solved! Go to Solution.
Hi @amymc ,
Your solution is great, @NandanHegde . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.
You can also check out this topic below for more information on this reported error : Unable to connect to Azure SQL when Deny public network access is enabled - Microsoft Q&A and Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting - Microsoft Community Hu...
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @amymc ,
Your solution is great, @NandanHegde . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.
You can also check out this topic below for more information on this reported error : Unable to connect to Azure SQL when Deny public network access is enabled - Microsoft Q&A and Azure SQL DB Private Link / Private Endpoint - Connectivity Troubleshooting - Microsoft Community Hu...
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
similar issue: