Power BI to PULL data from Storefeeder API Limitations

[Omer4uq]

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 whole data in Power BI e.g Data Cube or Azure ??

I want the whole sales data for reporting and analysis.

Best Regards,

[v-haibl-msft]

@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