Forum Discussion

Omer4uq's avatar
Omer4uq
Regular Visitor
9 years ago

Power BI to PULL data from Storefeeder API Limitations

Hi, My Question is that what is the best way to get away with the Power BI 100 row limitation when pulling data from a REST API(Storefeeder in my case). And Please Specify any other way to get the ...
APIS and Embedding
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Omer4uq

 

We can use advanced filter and filter by range as a mitigation for this limitation.

Please refer to following sample code.

 

window.onload = function () { 
  var  Filter = {
   $schema: "http://powerbi.com/product/schema#advanced",
  target: {
    table: "Table",
    column: "value"
  },
  logicalOperator: "And",
  conditions: [
    {
      operator: "GreaterThanOrEqual",
      value: 1
    },
	{
      operator: "LessThanOrEqual",
      value: 100
    }
	
  ]
}

 

Best Regards,
Herbert