OData.Feed fails with EndOfStreamException

[DaveTheOx]

Using OData.Feed() with Implementation="2.0" and either IncludeAnnotations="*" or IncludeMetadataAnnotations="*" fails with the following exception:

DataMashup.Trace Warning: 24579 : {"Start":"2019-01-23T15:24:26.4825436Z","Action":"StreamMessenger/Read","Exception":"Exception:\r\nExceptionType: System.IO.EndOfStreamException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Unable to read beyond the end of the stream.\r\nStackTrace:\n   at System.IO.__Error.EndOfFile()\r\n   at System.IO.BinaryReader.FillBuffer(Int32 numBytes)\r\n   at System.IO.BinaryReader.ReadInt32()\r\n   at Microsoft.Mashup.Evaluator.MessageSerializer.Deserialize(BinaryReader reader)\r\n   at Microsoft.Mashup.Evaluator.StreamMessenger.Read()\r\n\r\n\r\n","ProductVersion":"2.65.5313.841 (18.12)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":12260,"Tid":1,"Duration":"00:00:00.0074639"}

DataMashup.Trace Warning: 24579 : {"Start":"2019-01-23T15:24:26.4938941Z","Action":"StreamMessenger/Post","Exception":"Exception:\r\nExceptionType: System.IO.IOException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089\r\nMessage: Pipe is broken.\r\nStackTrace:\n   at System.IO.Pipes.PipeStream.WinIOError(Int32 errorCode)\r\n   at System.IO.Pipes.PipeStream.WriteCore(Byte[] buffer, Int32 offset, Int32 count)\r\n   at Microsoft.Mashup.Evaluator.MessageSerializer.Serialize(BinaryWriter writer, Message message)\r\n   at Microsoft.Mashup.Evaluator.MessageSerializer.Serialize(BinaryWriter writer, Message message)\r\n   at Microsoft.Mashup.Evaluator.StreamMessenger.Post(Message message)\r\n\r\n\r\n","ProductVersion":"2.65.5313.841 (18.12)","ActivityId":"00000000-0000-0000-0000-000000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":12260,"Tid":1,"Duration":"00:00:00.0288941"}

....

The function succeeds if IncludeAnnotations and IncludeMetadataAnnotations are removed.     

The function succeeds if Implementation="2.0" is removed and IncludeAnnotations="*" and/or IncludeMetadataAnnotations="*" are included.

Sample M language showing the failure:

let
Headers = [Authorization = "Bearer eyJ0eXAiOiJ..............jJmMLADeUtx9Z3w"],
Options = [ODataVersion = 4.0, MoreColumns = true, IncludeMetadataAnnotations="*", Implementation="2.0"],
Source = OData.Feed("https://s3dwebapisam.ingrnet.com/s3d/v1", Headers, Options)
in
Source

Sample M language showing success:

let
Headers = [Authorization = "Bearer eyJ0eXAiOiJ..............jJmMLADeUtx9Z3w"], 
Options = [ODataVersion = 4.0, MoreColumns = true, IncludeAnnotations="*", IncludeMetadataAnnotations="*"],
Source = OData.Feed("https://s3dwebapisam.ingrnet.com/s3d/v1", Headers, Options)
in
Source

[v-yuezhe-msft]

@DaveTheOx,

Could you please use fiddler to track the connection process and share fiddler trace log here? Also please share all Power BI Desktop trace log here. You can upload log files through OneDrive.

Regards,
Lydia

[DaveTheOx]

Hi @v-yuezhe-msft,

I sent you a private message with a OneDrive link to the information you requested about the bug in PBI Desktop. 

Thanks,
Dave

[DaveTheOx]

Hi @v-yuezhe-msft,

Were you able to get the failure information from my OneDrive?

Thanks,

Dave

[v-yuezhe-msft]

@DaveTheOx ,

I didn't see any detailed error message from the trace log you share. I make a test using your M query with SharePoint online list data source, but everything works well in Power BI Desktop Feb release(2.66.5376.2521). How about you use Power BI Desktop Feb release and change '*' in IncludeMetadataAnnotations="*" to detailed information?



Regards,
Lydia

[DaveTheOx]

SharePoint online list data works because the amount of annotations metadata returned from SharePoint is trivial compared to the amount of annotations metadata in our OData API.   You need to test with our metadata. 

I will test again with Feb release and will again include the trace logs.  

Regards,
Dave