topic Re: Filter Query String Parameter in custom Javascript Embed application in Developer

Filter Query String Parameter in custom Javascript Embed application

sierra710 — Fri, 27 Jul 2018 12:11:02 GMT

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

Re: Filter Query String Parameter in custom Javascript Embed application

v-jiascu-msft — Mon, 30 Jul 2018 05:30:18 GMT

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

Re: Filter Query String Parameter in custom Javascript Embed application

sierra710 — Mon, 30 Jul 2018 11:49:03 GMT

Thanks, but this does not address my question.

i am looking to programmatically generate the basic filter, not hard code values.