Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Salesforce: Failed to update data source credentials

Hi Folks,   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 v...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

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.

 

Best Regards

Maggie

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

      Activity ID:06cce81c-aaba-481c-87b4-47b6c8d13af9
      Request ID:3cdf6720-3e6f-1e94-ec31-8224980df5dd
      Status code:400
      Time:Thu May 02 2019 08:14:07 GMT-0400 (Eastern Daylight Time)
      Version:13.0.9264.166
      Cluster URI:https://wabi-us-gov-virginia-redirect.analysis.usgovcloudapi.net

      "

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I have narrowed my problem to IP ranges whitelisted by my company... working it with my IT dept which is slow and fun.

         

        Good luck