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

I want the whole sales data for reporting and analysis.

 

Best Regards,

APIS and Embedding

1 Reply

  • 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