Power BI Gateway: Refresh data from two different salesforce instances

[Anonymous]

Hi,

I have successfully connected to two different salesforce instances within the desktop tool and managed to append this data. Unfortunately when I publish this report to a cloud service workspace one of the instances flags the error: "Failed to update data source credentials"? Is this a limitation with the gateway? Am I on an old version of the gateway? Does the azure IP address need to be added to the white list on both sales force instances?

Thanks.

[v-yuezhe-msft]

@Anonymous,

Do you use salesforce object or salesforce report connector in Power BI Desktop? When your Power BI report only contain Salesforce data, gateway is not required in Power BI Service. 

Go to settings in Power BI Service and find your dataset, directly enter your credential under Data source credentials.


Regards,
Lydia