Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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] }
Hi @Anonymous
Do you have any update ? If my replay helps please accept it as answer/giving kudos which will help other community members
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |