Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Get data from API

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!

Need Help

3 Replies

  • Jayendran's avatar
    Jayendran
    Solution Sage
    7 years ago

    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's avatar
      Jayendran
      Solution Sage
      6 years ago

      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's avatar
        Anonymous
        Not applicable
        6 years ago

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