topic Re: Get data from API in Developer

Get data from API

Anonymous — Sun, 18 Aug 2019 09:16:29 GMT

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!

Re: Get data from API

Jayendran — Mon, 19 Aug 2019 09:40:40 GMT

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]
}

Re: Get data from API

Jayendran — Thu, 05 Sep 2019 06:20:23 GMT

Hi @Anonymous

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

Re: Get data from API

Anonymous — Thu, 05 Sep 2019 06:26:09 GMT

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!!