Visualization getting an error

[Anonymous]

I looked for a solution for this but couldn't find any. 

All the visualization works fine, but if I want to add a custom column I did on Desktop to be shown in one of the visualizations, it takes a while to load, and finally I get this error:

It seems to be a memory issue, but the column loads fine in desktop. I'm having trouble just with this visualization. 

I'd appreciate any guidance. Thanks in advance!

[ribisht17]

@Anonymous 

This is more on the Power BI service side, what is the error if you click on See details?

>>>Error "Couldn't retrieve the data for this visual.... - Microsoft Power BI Community

Regards,

Ritesh

Regards,

Ritesh

[Anonymous]

Thanks for the reply. 

If I click on see details, that sign shows up. And if I click on Copy details to clipboard, I get a list of exceptions.

This is the first stack trace:

Stack Trace:
System.IO.IOException: Stream was too long.
at System.IO.MemoryStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.StreamWriter.Flush(Boolean flushStream, Boolean flushEncoder)
at System.IO.StreamWriter.Write(String value)
at Microsoft.DataShaping.Common.Json.JsonValueUtils.WriteEscapedJsonString(TextWriter writer, String inputString)
at Microsoft.DataShaping.InternalContracts.JsonStreamingStructureWriter.WriteSimpleEncodedValue(Object value)
at Microsoft.DataShaping.InternalContracts.DataShapeResultWriter.DictionaryValuesWriter.WriteValues(String identifier, Boolean isTypeEncoded, IReadOnlyList`1 values)
at Microsoft.DataShaping.Processing.DataShapeResultGeneration.DataShapeResultGenerator.WriteValueDictionaries(DictionaryEncodingCoordinator dictEncoding, String dataShapeId, DataShapeWriter writer, CalculationGenerationTelemetry calcTelemetry)
at Microsoft.DataShaping.Processing.DataShapeResultGeneration.DataShapeResultGenerator.ProcessDataShape(DataShape dataShape, DataShapeWriter writer)
at Microsoft.DataShaping.Processing.DataShapeResultGeneration.DataShapeResultGenerator.GenerateImpl()
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.RunInActivity(ActivityKind activityKind, Action action)
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()

[ribisht17]

Looks like related to c# - Failed to write large amount of data to stream - Stack Overflow memory/big data as you have already mentioned there 

Regards,

Ritesh

[Anonymous]

Oh I see. But I don't understand why I'm having trouble with the Report,  while in the Data section the same column is shown correctly.

I'll read that link you sent and see if I can find something. Thank you!

[ribisht17]

Yes, you might have got the data but still, it has to travel from there to the actual Visual, you can assume that as Viz SQL.Action on your data such as a Bar Chart which is internally querying your data-set to get the output in the form of a chart. So this Viz SQL query is quite heavy .... which may have posed this problem .....

Something similar to SELECT * FROM TABLE where condition & you are not getting the output since the table is quite big or unusable index etc...so the data is there, that's fine but too much of memory ...or exceed memory.So we try to solve that by tuning the query,partition,INDEXING etc

Ritesh

Mark my post as a solution if it helped you so that it can help others as well| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin

[Anonymous]

Do you think it would be possible to avoid this issue if I try to show the visualization using python or R instead of the regular way, or it would be the same, as the main problem is the data size?

[Anonymous]

I understand. Thanks for the explanation!