Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Publishing error

Hi,

 

I'm publshing a report with a single salesforce object and keep getting an error :

"unable to write data to the transport connection an existing connection was forcibly closed by remote host "

 

the file is only around 10 MB and 120K lines.

 

any suggstion please?

Report Server

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      its only in the desktop, I'm trying to publish the dashboard to the server 

  • ReportGuru's avatar
    ReportGuru
    Post Patron
    2 years ago

    Hi Anonymous I know this reply is very late lol, but 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 (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) 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
    1 month ago

    Hi Anonymous,

     

    I know this is an old thread, but for anyone still running into this kind of Salesforce to Power BI publishing issue, I would also test the Salesforce data connection path separately from the PBIX publishing step.

     

    A 10 MB file with around 120K rows does not sound huge by itself, so the issue may be related to how the Salesforce data is being pulled, refreshed, or transported during publish.

     

    One alternative worth checking is Power BI Connector for Salesforce by Metrica Software, available on Salesforce AgentExchange / AppExchange:
    https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

     

    The idea is to define the Salesforce data source inside Salesforce, choose only the objects and fields you need, apply filters there, and then consume that prepared data source in Power BI. This can make the Salesforce to Power BI pipeline more predictable than relying only on the native connector path.

     

    A few reasons it may be relevant here:

    - It supports standard and custom Salesforce objects.
    - You can select only the required fields and apply filters before the data reaches Power BI.
    - If you also use Salesforce Reports, it avoids the frustrating 2,000-row Salesforce Reports limit that the native Reports connector can hit.
    - There is a 30-day free trial, so you can test it on the same Salesforce object or report before committing.

     

    Docs are here:
    https://metricasoftware.com/docs/salesforce/

     

    Support is here:
    https://metricasoftware.com/docs/salesforce/contact-support/

     

    Disclosure: I am with Metrica. If useful, we can also set up a quick demo and walk through the setup, data source creation, Power BI connection, and refresh behavior.

     

    Hope this helps as an alternative path, especially if the standard connector keeps closing the connection during publish.

     

    Cheers,

    Metrica Team.