Forum Discussion

MikeSolvesBI's avatar
MikeSolvesBI
Icon for Helper II rankHelper II
3 years ago

latest document on how to setup Power BI to Azure sql service using a VPN

Hello,

I am looking to connect Power BI Service to Azure SQL in the most secure way. 

 

It looks like using a VPN and Gateway is the most secure.

 

Is there a current document outlining the steps?

 

Thank You,

 

Michael

Data Protection

1 Reply

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi , MikeSolvesBI 

    According to your description, you want to connect the Azure sql server in Power BI . 

    For the "Azure sql server" is a cloud data source , i think you do not need to use the gateway to connect.

    You just need to update the credential in the setting of the data source and then you can get the data from the Azure sql server.

    By another, the on-premise gateway is the tool to open the connection from on-premise datasource to the Sql server.

    For cloud data sources, data traffic is the traffic inside the Azure service and is very secure. If you use a data gateway, traffic is also sent on-premises, which also affects some performance.

    For more information, you can refer to :
    On-premises data gateway - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly