Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am looking to build an app that passes a filter query string to a report, similar in format as the filter query string in PBI Service reports:
URL?filter=Table/Field eq 'value'
then convert this format to Javascript, IBasicFilter
const basicFilter: pbi.models.IBasicFilter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "Store", column: "Count" }, operator: "In", values: [1,2,3,4], filterType: pbi.models.FilterType.BasicFilter }
Curious if anyone has done this before, and knows of a plugin or easier way to transform this structure. thanks
Hi @sierra710,
You almost get it done. Please try the online demo here. You also can get the source code here.
// Build the filter you want to use. For more information, See Constructing // Filters in https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters. const filter = { $schema: "http://powerbi.com/product/schema#basic", target: { table: "Store", column: "Chain" }, operator: "In", values: ["Lindseys"] }; // Get a reference to the embedded report HTML element var embedContainer = $('#embedContainer')[0]; // Get a reference to the embedded report. report = powerbi.get(embedContainer); // Set the filter for the report. // Pay attention that setFilters receives an array. report.setFilters([filter]) .catch(function (errors) { Log.log(errors); });
Best Regards,
Dale
Thanks, but this does not address my question.
i am looking to programmatically generate the basic filter, not hard code values.