Forum Discussion
Visualization getting an error
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
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()
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
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!
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