Visualization getting an error

Question

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 · Answer

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 .....&nbsp;Something similar to SELECT * FROM TABLE where condition &amp; 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&nbsp;RiteshMark my post as a solution if it helped you so that it can help others as well|&nbsp;Munde and Kudis (Ladies and Gentlemen) I like your Kudos!!&nbsp;!!My You Tube Channel&nbsp;!!&nbsp;Connect on Linkedin

ribisht17 · Answer

Anonymous&nbsp;&nbsp;This is more on the Power BI service side, what is the error if you click on See details?&gt;&gt;&gt;Error "Couldn't retrieve the data for this visual.... - Microsoft Power BI Community&nbsp;Regards,Ritesh&nbsp;&nbsp;&nbsp;&nbsp;Regards,Ritesh

anonymous · Answer

Thanks for the reply.&nbsp;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:&nbsp;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.&lt;ExecuteQueryAndWriteResult&gt;d__2.MoveNext()

ribisht17 · Answer

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

anonymous · Answer

Oh I see. But I don't understand why I'm having trouble with the Report,&nbsp; 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!

Forum Discussion

Visualization getting an error

7 Replies

Related content

Table visual error

Getting Error Cannot load model

getting error

PowerApps visual Error getting Environments

Getting FUll memory Error