Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Refresh data from VPN-secured Salesforce

I have an issue when I try to refresh a published report from Salesforce objects.   Salesforce is white-listed so it can be accessed only from VPN.   It is ok when I try to refresh data from Powe...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    I got a reply from MS support

     

    Credential acquisition and connection test are always happening from the Power BI Service. so there is no currently a workaround on our side.

    It’s happen because SF is an online data source, so it will never use the PSW

    But even if the data source itself ends up using a gateway, all OAuth in DMTS happens entirely in the cloud.

     

    It seems to be true - PowerBI checks credentials online first.

     

    To workaround, we use some trick with Salesforce DataLoader to export all data into CSV first on the machine connected to VPN and then access that CSV with the gateway.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I got a reply from MS support

 

Credential acquisition and connection test are always happening from the Power BI Service. so there is no currently a workaround on our side.

It’s happen because SF is an online data source, so it will never use the PSW

But even if the data source itself ends up using a gateway, all OAuth in DMTS happens entirely in the cloud.

 

It seems to be true - PowerBI checks credentials online first.

 

To workaround, we use some trick with Salesforce DataLoader to export all data into CSV first on the machine connected to VPN and then access that CSV with the gateway.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Anonymous,

 

Thank you for your sharing the solution which benefits other members.

 

Best Regards,
Qiuyun Yu