Forum Discussion

sachin1234's avatar
sachin1234
New Member
9 years ago

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

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
 
 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • Hello,

     

    Im having the same issue, any solution was found? 

     

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.