Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

oData OLE DB or ODBC error: [DataSource.Error] Unable to read data from the transport connection

Hi!

 

I keep getting this error. Help!

I'm using this oDatafeed as a source: https://opendata.cbs.nl/ODataFeed/OData/84583NED. It used to work just fine. But I haven't been using oDatafeeds for a while and this happend.

Using version: Version: 2.82.5858.961 64-bit (june 2020)

Power Bi will load some of the data in the Power Query editor. The table is pretty big. When I click "Close and apply", it starts loading and then I get the error.

When I try a smaller table (https://opendata.cbs.nl/ODataFeed/OData/84498NED) it works just fine.

 

Thanks!

Need Help

6 Replies

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

    You are probably running into a connection timeout.

    Can you limit / filter the amount of data?

     

    • Calvin69's avatar
      Calvin69
      Helper III
      2 years ago

      mwegener Hey, I wonder if you could guide me to possible solutions for a timed out connetion due to the data size other than Data Warehouse solution. Is there a way to load all that data directly from the srouce in PBI when the data is massive?

  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Please refer the following post and issue, hope it will be helpful.

     

    https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DataSource-Error/m-p/865494

    https://community.powerbi.com/t5/Issues/Unable-to-read-data-from-the-transport-connection/idi-p/112411/page/2#comments

     

    If it doesn’t meet your requirement, we suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/

     

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • arrowav36's avatar
    arrowav36
    Frequent Visitor
    4 years ago

    It's still not working on my system.

    I have fetched data from shopify using Odata.

    I am trying to apply the merge command and lookup values from one table to another but after clicking on close and apply it takes 10-15 minutes and giving the same error : 

    OLE DB or ODBC error: [DataSource.Error] OData: Received an unexpected EOF or 0 bytes from the transport stream..

    Please help me resolve this issue!

  • arrowav36's avatar
    arrowav36
    Frequent Visitor
    4 years ago

    Hi Anonymous,

    I also got the same error, was able to resolve it by following this process mentioned below : 

    Go to "Control panel"  -> "Programs and features" -> "Turn windows features on or off" -> 

    Then uncheck "Internet information services" and also uncheck " Internet information services Hostable Web Code".

    Thanks & regards

  • ReportGuru's avatar
    ReportGuru
    Post Patron
    1 year ago

    Hi, 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, supemetrics 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 Shopify connector in the data sources list:

     

     

    After that, you need to follow instructions and install the windsor.ai app from the Shopify App Store:

     

     

    then on preview and destination page you will see a preview of your Shopify fields

     

     

    There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.