Forum Discussion

Eptor's avatar
Eptor
Frequent Visitor
9 years ago

Salesforce credentials not accepted in service - Working fine in PBI desktop

Hi,

 

I am using a dataset that uses one file and Salesforce reports.

 

When using the PBI service and trying to set a schedule refresh, the gateway seems to work fine (I have tried connecting just the file without reports), but for Saleforce , the credentials I provide are not accepted by the system when they are exactly the same I use in PBI desktop succesfully. .I get the following messages:

 

 

Failed to update data source credentials.Hide details

Activity ID:09d84d10-19c1-497d-af62-eaeacc77f1d2
Request ID:a87cbefe-bfcf-5f40-9d4a-dd124c93c0ab
Status code:500
Time:Fri Mar 24 2017 09:50:06 GMT+0100 (Central European Standard Time)
Version:13.0.1700.1501
Cluster URI:https://wabi-west-us-redirect.analysis.windows.net

 

Can someone help me to identify how I can resolve this?

 

Thanks

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Eptor,

    Are you able to refresh data in Power BI Desktop? And what authentication type do you use to connect to Salesforce?

    Besides, could you please connect to Salesforce using content pack and check if you can set schedule refresh for the dataset successful?

    Thanks,
    Lydia Zhang

  • QueryWhiz's avatar
    QueryWhiz
    Icon for Post Patron rankPost Patron
    2 years ago

    Hi Eptor were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector, which connects directly to SF objects API. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

     

     

    After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

     

     

    There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

     

  • metrica's avatar
    metrica
    Icon for Post Prodigy rankPost Prodigy
    2 months ago

    Hi Eptor 

     

    The HTTP 500 response does not confirm that the Salesforce credentials were incorrect. I would reenter the credentials in Power BI Service and verify API Enabled and the Salesforce session IP-locking setting.

     

    Power BI Connector for Salesforce provides an alternative connection using an app-specific token and OData source. AppExchange and 30-day trial: https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

     

    Docs and support:
    https://metricasoftware.com/docs/salesforce/
    https://metricasoftware.com/docs/salesforce/contact-support/

     

    Cheers,
    Metrica Team