can't load data to a visual , status code 400

[sachin1234]

Hello ,

I have a Power BI report who pulls data from SSAS MDS cube. The report works fine when on power BI desktop, but fails with the following message:

Http Status Code400

Activity ID90c1fab3-d213-4f5b-8554-27be7f9472b5

Correlation IDbb612bae-b1b9-e271-cc98-d61357edf957

Request IDc32d30ab-6493-21ba-279d-e59bc9cf61cf

TimeSun XXXXXX

Version13.0.1700.1295

Cluster URI

I've captured the network trace  found that the following repeating multiple times in the response body, but really don't follow what it really means. Can someone help in troubleshooting this further?

error":{"code":"BadRequest","message":"Bad Request","details":[{"message":"The reader's MaxDepth of 256 has been exceeded. Path 'queries[0].Query.Commands[0].SemanticQueryDataShapeCommand.Query.Where[1].Condition.And.Right.Or.Right.And.Right.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.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.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.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.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 5969

[Anonymous]

Hello, 

We did get he same error when using Power BI Javascript API and Power BI Embedded. This happen when you put too many filters on javascript side. Any idea or maybe a fixed planned ? We of course raised a incident to MS support.

const advancedFilter: pbi.models.IAdvancedFilter = {
  $schema: "http://powerbi.com/product/schema#advanced",
  target: {
    table: "Store",
    column: "Name"
  },
  logicalOperator: "Or",
  conditions: [
    {
      operator: "Contains",
      value: "Wash"
    },
    {
      operator: "Contains",
      value: "Park"
},
    {
      operator: "Contains",
      value: "Shanghai"
},
    {
      operator: "Contains",
      value: "China"
    }
Etc.............
  ],
  filterType: pbi.models.FilterType.AdvancedFilter
}

Regards.

[Ged]

Hello,

Im having the same issue, any solution was found? 

Thanks

[v-shex-msft]

Hi @sachin1234,

Since your datasource is ssas and you published the report to service, you need a gateway to manage the your data. Can you ensure you are correctly setting the on-premise gateway at service side?

Reference link:

Manage your data source - Analysis Services

In addition, if above is not help, can you share some detail content? It will be help for troubleshooting.

Regards,

Xiaoxin Sheng