Get data from API

[Anonymous]

Hi Communitty!

I have a report with a list and some filters. I want to send the filters parameters throiugh the API and then get the data of the list (the list of one of the columns) through the API.

Is this possible? Couldn' find it in the API documentation.

Thanks!

[Jayendran]

Hi @Anonymous 

You can use Query string parameter syntax for filtering

https://docs.microsoft.com/en-us/power-bi/service-url-filters#uses-for-query-string-parameters

If you are using PowerBI Embedded then you can use PowerBI-JavaScript API to set filters with Power BI Embedded. For more details, you can refer to PowerBI-JavaScript wiki Filters. 

const filter = { ... };

report.setFilters([filter])
  .catch(errors => {
    // Handle error
  });

const basicFilter: pbi.models.IBasicFilter = {
  $schema: "http://powerbi.com/product/schema#basic",
  target: {
    table: "Store",
    column: "Count"
  },
  operator: "In",
  values: [1,2,3,4]
}

[Jayendran]

Hi @Anonymous 

Do you have any update ? If my replay helps please accept it as answer/giving kudos which will help other community members

[Anonymous]

Hi, 

Thanks it helped! That looks like the way to set the filters, I'm still looking for a solution to how to get the data results via the API.

Thanks!!