MDS 2016, Excel add-in error, partial data download

  • Scenario: We have an MDS 2016 instance, and end users are using the 2016 Add-in for MS Excel to view the model and update entities.
    Issue: Smaller entities will download without issue to MSExcel. For larger entities, we are getting only partial data downloads.

    e.g. ~3800 members from a 5500 row entity.

    The error message then pops up: 

    • TITLE: Master Data Services Add-in for Excel
    • An error (Unable to read data from the transport connection: The connection was closed.) occurred while transmitting data over the HTTP channel.

    I am wondering if this is something like a web service config issue?

    Any advice gratefully accepted!

  • ggarethh - Friday, November 23, 2018 3:11 AM

    Scenario: We have an MDS 2016 instance, and end users are using the 2016 Add-in for MS Excel to view the model and update entities.
    Issue: Smaller entities will download without issue to MSExcel. For larger entities, we are getting only partial data downloads.

    e.g. ~3800 members from a 5500 row entity.

    • TITLE: Master Data Services Add-in for Excel
    • An error (Unable to read data from the transport connection: The connection was closed.) occurred while transmitting data over the HTTP channel.

    I am wondering if this is something like a web service config issue?

    Any advice gratefully accepted!

    Just two things come to mind, don't use "localhost" as a server name and check the MaximumDbaEntitySize setting. 
    😎

    It looks like you have a network issue though, check the things I mentioned and then check the network!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply