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!

[ReportGuru]

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.

[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?

[Calvin69]

@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?