Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Power BI Data Gateway + VPN

Scenario & Requirement:

  • Source Data (= On Premises, SQL Server Database) for Power BI Report is ACCESSIBLE ONLY USING VPN
  • Power BI Report (Using Data IMPORT), developed & published to Cloud Service
  • Need to SETUP PBI Data Gateway for the Data Set SCHEDULE REFRESH

 

Challenges

 

  • Windows Machine, allotted for installing PBI Data Gateway, is also accessible Using VPN
  • Have installed PBI Data Gateway on the above said machine, but it fails while SIGN-IN with Cloud Credentials
  • Reason for failing is power bi gateway proxy authentication

 

Need solution to solve this challenge.
Please do help.

Status: Needs Info
Comments
v-haibl-msft
Employee

@ctembe

 

Could you please provide a screenshot for the error message? Please also take a look at this document which is about configuring proxy settings for the On-premises Data Gateway.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
ctembe
Regular Visitor

@v-haibl-msft,

 

Thanks for the response.

 

Basically, I have ambiguity in identifying windows machine on which I need to SET Power BI Gateway.

Because:

  • Data Source (= On Premises SQL Server) IS ONLY Accessible using VPN
  • Machine for Power BI Gateway SHOULD BE ONLINE and CANNOT BE on VPN

 

 

 

v-haibl-msft
Employee

@ctembe

 

You can try to install the gateway on the machine where on-premises SQL Server is located. Make sure the machine where gateway is installed can be connected to the Internet.

 

Best Regards,
Herbert