Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Status: Needs Info
Comments
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
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:

BjornBerg_0-1672906066049.png

 

Other pages are working fine in Power BI service, but none of them are working in Power BI desktop.

Anonymous
Not applicable

Hi @BjornBerg 

Has your problem been solved?

 

Best Regards,
Community Support Team _ Ailsa Tao

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.

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