BjornBerg's avatar
BjornBerg
Regular Visitor
3 years ago
Status:
Needs Info

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

  • Anonymous's avatar
    Anonymous
    Not 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

  • BjornBerg's avatar
    BjornBerg
    Regular 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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi BjornBerg 

    Has your problem been solved?

     

    Best Regards,
    Community Support Team _ Ailsa Tao

  • BjornBerg's avatar
    BjornBerg
    Regular Visitor

    Hi Anonymous 

    No, I'm still searching for a solution. In the meantime I still hope to get some feedback/direction here.

  • 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