Power bi could not load visual: jsonreader maxdepth of 64 exceeded
One of our reports is facing the following error message when we open the report locally. this error is shown on each visual (slicers, cards, tables, diagrams)
The published report is working fine, except when editing the report in power bi service and opening a hidden page. on this hidden page we receive the same message.
Feedback Type:
Frown (Error)
Timestamp:
2023-01-03T11:01:06.2066973Z
Local Time:
2023-01-03T12:01:06.2066973+01:00
Release:
December 2022
Product Version:
2.112.603.0 (22.12) (x64)
Stack Trace:
System.ArgumentException: Failed to deserialize version 2 of json ExecuteSemanticQueryRequest. ---> Newtonsoft.Json.JsonReaderException: The reader's MaxDepth of 64 has been exceeded. Path 'Queries[0].Query.Commands[0].SemanticQueryDataShapeCommand.Query.Where[8].Condition.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left.Or.Left', line 1, position 7068.
bij Newtonsoft.Json.JsonReader.Push(JsonContainerType value)
bij Newtonsoft.Json.JsonTextReader.ParseValue()
.......
bij Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
bij Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
bij Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
bij Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
bij Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
bij Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
bij Microsoft.PowerBI.ExploreHost.ServiceContracts.ExecuteSemanticQueryRequestDeserializer.DeserializeV2Request(String json)
--- Einde van intern uitzonderingsstackpad ---
bij Microsoft.PowerBI.ExploreHost.ServiceContracts.ExecuteSemanticQueryRequestDeserializer.DeserializeV2Request(String json)
bij Microsoft.PowerBI.ExploreHost.ServiceContracts.ExecuteSemanticQueryRequestDeserializer.DeserializeGeneric[T](String json, IReadOnlyDictionary`2 versionedDeserializers, String typeName)
bij Microsoft.PowerBI.ExploreHost.ServiceContracts.ExecuteSemanticQueryRequestDeserializer.Deserialize(String json)
bij Microsoft.PowerBI.ExploreHost.SemanticQuery.SemanticQueryHandlerBaseFlow.DeserializeExecuteSemanticQueryRequest(String jsonRequest)
bij Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.InternalRun()
OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 nl-NL)
CLR Version:
4.8 or later [Release Number = 528372]
Peak Virtual Memory:
70.3 GB
Private Memory:
597 MB
Peak Working Set:
883 MB
IE Version:
11.789.19041.0
Telemetry Enabled:
True
Model Default Mode:
Composite
Model Version:
PowerBI_V3
Enabled Preview Features:
PBI_compositeModelsOverAS
PBI_enableWebView2
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_NlToDax
PBI_optimizeTabRibbon
PBI_relationshipEditPane
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
5 Comments
- AnonymousNot applicable
Hi BjornBerg
You mentioned that when you open the report locally , you will get the error , so the error happened in Power BI Desktop ? You can open the report normally in Power BI Service ,right ?
Best Regards,
Community Support Team _ Ailsa Tao - BjornBergRegular Visitor
Hi Anonymous
Yes, it doesn't happen in the published app/Power BI Service.
But when I edit the report in Power BI Service, I get a similar issue on a hidden page in the report:
Other pages are working fine in Power BI service, but none of them are working in Power BI desktop.
- AnonymousNot applicable
- BjornBergRegular Visitor
Hi Anonymous
No, I'm still searching for a solution. In the meantime I still hope to get some feedback/direction here.
- decarsul
Helper V
Would like to add, we are experiencing the same issue when using powerbi projects. when using the regular pbix format this issue is not present