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

[Anonymous]

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!

[arrowav36]

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

[arrowav36]

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!

[v-zhenbw-msft]

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.

[mwegener]

Hi @Anonymous ,

You are probably running into a connection timeout.

Can you limit / filter the amount of data?