Forum Discussion

Katrin620's avatar
Katrin620
New Member
10 years ago

Error Salesforce Object: DataSource Error: Unable to connect to the remote server

Hi,

 

I am using Power BI Desktop and want to set up a report using data from a Salesforce Object. 

 

When selecting: Get Data -> Online Services -> Salesforce Objects the system lets me chose the object (in this case Installed Product), but afterwards the 'Preview is Evaluationg' circle turns and turns until it shows an error: "DataSource.Error: Unable to connect to the remote server Details: https://na2.salesforce.com/services/data/v29.0/sobjects/SVMXC__Installed_Product__c/describe"

 

When I open the link the following is shown: 

<Errors>
<Error>
<errorCode>INVALID_SESSION_ID</errorCode>
<message>Session expired or invalid</message>
</Error>
</Errors>

 

The strange thing is that I can work with other objects without error messages, and can work with all reports too.

Any advice would be greatly appreciated.

Need Help

4 Replies

  • cmathistx's avatar
    cmathistx
    New Member
    10 years ago

    I get this error frequently when I am behind our company's firewall on our internal network.  I don't seem to have this problem when on an external network.  And I think the reason why querying some objects work fine and others do not has to do with the number of fields in the objects.

     

    Hope this helps.

  • StijnJanssen's avatar
    StijnJanssen
    Regular Visitor
    9 years ago

    Hi Katrin,

     

    while working with power BI and getting data from salesforce object I experience the same as you have described.

    I also raised another ticket with the same content Anonymous

    Re: Get data online service error on Salesforce object

    https://community.powerbi.com/t5/Integrations-with-Files-and/Get-data-online-service-error-on-Salesforce-object/m-p/142900#M8856

    Looking at the time and date you have raised the question do you have a solution?

     

    Thank you !

    Stijn Janssen

     

     

  • CoderZen08's avatar
    CoderZen08
    Helper V
    1 year ago

    Hi Katrin620 were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. 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
    Post Prodigy
    8 days ago

    Hi Katrin620,

     

    The thread never established a single root cause. INVALID_SESSION_ID indicates an invalid Salesforce session, and one commenter found that the problem occurred only behind a corporate firewall.

     

    Clear the Salesforce credentials and reconnect. If the issue remains, check the proxy or firewall, Salesforce session IP locking, and that the query uses a supported Salesforce API version.

     

    Power BI Connector for Salesforce can be tested as an alternative source, but it still depends on Salesforce permissions and network access.

     

    AppExchange and 30-day trial:
    https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

     

    Cheers,
    Metrica Team