question

Paula-0965 avatar image
0 Votes"
Paula-0965 asked ·

Azure Synapse Dedicated SQL and PBI safe connection

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.

azure-synapse-analytics
· 2
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

Thanks correct .

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ·

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


· 2
10 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

Thanks correct,

0 Votes 0 ·