Datasets with Salesforce and on-prem SQL Source

[Cathryn]

Hi All

I was just wondering if it's possible to refresh a dataset that has both a salesforce connection and an on-prem SQL Source.  I've seen a lot of posts where I think it says the only way to do this is to have a personal gateway.  

Is this still the case?  I have connection set up in the gateway for salesforce that is available and works if I just have a report with just a salesforce connection.  But when I add the on-prem connection into the report published from the desktop, it says my credentials are invalid

Thanks

Cathryn

[Seth_C_Bauer · Accepted solution]

@Cathryn Still accurate. The personal gateway is the only gateway that allows the "mix" of on premises and online. The OPD gateway still doesn't support this.