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...
Need Help
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!!