What is the best way to have Azure Synapse Dedicated SQL db without a public IP?
And how would PBI connect to it? Do you need a data gateway?
Is it using a managed workspace virtual network?
Read a lot of papers... would appreciate some guidance.
What is the best way to have Azure Synapse Dedicated SQL db without a public IP?
And how would PBI connect to it? Do you need a data gateway?
Is it using a managed workspace virtual network?
Read a lot of papers... would appreciate some guidance.
thanks for the answer
we still will need a power bi data gateway right? to get the data from dedicated sql synapse?
please confirm.
thanks again
Hello @Paula-0965 ,
Thanks for the ask and using the Microsoft Q&A platform .
Not sure if you have explorered the option of private link . Please read about the same here and also here .
Let me know if you have any further questions .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
ok, great. so just double checking that I got this right.
In order to have to have Azure Synapse Dedicated SQL db without a public IP, high level overview steps are:
- create a synapse managed workspace virtual network
- create private links
- create a data gateway
Thanks again
7 people are following this question.