Transport connection problem publishing Sales Force model

[Brian_M]

I have created a new model and connected to SalesForce using the following method:

• Get Data - Online Sources - SalesForce Objects.

Data pulls through from SalesForce into my PBI Desktop model but when I try to publish it, I get the following error:

Error Message:

Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.

Does this mean that I can't publish a report containing a SalesForce connection to the Service?

Has anyone else successfully published a PBIX file containing a SalesForce connection? I was hoping to test whether or not the report will be able to refresh directly from SalesForce cloud via the PowerBI Service.

Thanks!

[Vicky_Song · Accepted solution]

@Brian_M, I could be able to publish a PBIX file containing a SalesForce connection. Please have another try. In addition, according to this article, the account you're using to connect to SalesForce needs to fullfill the following requirements:

• Connected with a production Salesforce account that has API access enabled
• Permission granted to the Power BI app during log-in
• The account has sufficient API calls available to pull and refresh the data
• A valid authentication token is required for refresh. Ensure you have 5 or less Salesforce data sets imported, as Salesforce has a limit of 5 authentication tokens per application

[Brian_M]

Thanks Vicky, I tried it again today and it works!