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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.