I have run into a pretty deal breaking issue at the last hurdle of building a fairly big report. The main datasource is Salesforce Objects, I was able to connect and run all perfectly via Power Bi Desktop but now I have finally got to publishing it and setting up the credentials it keeps failing. I have tried through my enterprise gateway and personal gateway with thes exact same result:
Failed to update data source credentials
Its a corporate instance of Salesforce on a custom domain and as mentioned works pretty much fine in Desktop. Has anyone any ideas why I might be running into this?
Its majorly heartbreaking to be at this late stage and run into this issue.
Any help welcome.
If instance of Salesforce is online, you don't need to add this data source under any gateway,
just go to setting->schedule refresh->edit credential,
before that, be sure "Allow user's cloud data sources to refresh through this gateway cluster " checked.
If it doesn't help, please provide detailed error information.
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, I tried this, it will not save the credentials... it seems that its a setting on the instance of Salesforce as I can do it fine with an alternative instance of salesforce...
It would be better if I COULD push Salesforce through the gateway but it doesnt work that way.
I too have run into the same error as the OP. Nearly the same exact scenario with the same results:
- Custom Salesforce domain
- Connceting directly to Salesforce objects
- When configuring gateway options, click 'edit credentials' for the Salesforce connection
- Input correct login information, window closes as if the connection was made
- End up with this error:
Failed to update data source credentials: Hide details
|Time:||Thu May 02 2019 08:14:07 GMT-0400 (Eastern Daylight Time)|
This too is a deal breaker for mt organization since the bulk of our data is now in Salesforce.
At this time I am manually updating our reports in Power BI Service by refreshing and republishing through the Desktop client, but this won't be an effective long term solution. Is there any workaround to get the scheduled refresh option to work with the Service?