topic Re: Passing Multiple Parameter filters in Power BI Embedded in Developer

Passing Multiple Parameter filters in Power BI Embedded

codjangmah — Tue, 25 Oct 2016 13:36:08 GMT

I developed an MVC application and i am able to pass one parameter in a filter dynamically to PowerBI embedded which is working.

ie $filter={table1/column}. However I want to be able to pass multiple PBI tables and columns.

Is it possible in Power BI embedded and can it be passed dynamically? ie: $filter={table1/column1}&{table2/column2}..

Re: Passing Multiple Parameter filters in Power BI Embedded

Eric_Zhang — Wed, 26 Oct 2016 09:24:47 GMT

@codjangmah

It is impossible to pass more than one filter that way, as far as I know.
You can check the advanced filter in the newly released JS API, see Introducing the new Power BI JavaScript API.

Re: Passing Multiple Parameter filters in Power BI Embedded

Sunkari — Wed, 26 Oct 2016 13:44:19 GMT

Sad that this feature is pending from a long time and so many people are asking for this feature. I am wondering my Power BI team is not considering this request.

Anyway @Eric_Zhang Power BI Javascript is for only Power BI Embedded(azure service) or this can be used for integrating reports using Rest API using Power BI Embedded(azure service)

Re: Passing Multiple Parameter filters in Power BI Embedded

piyush — Thu, 10 Nov 2016 13:16:41 GMT

@codjangmah: One workaround can be to concatenate the two fields and pass it as a filter.

Re: Passing Multiple Parameter filters in Power BI Embedded

codjangmah — Fri, 18 Nov 2016 15:44:45 GMT

Can you please give an example and how will powerbi know how to process the filter you pass in if its concatenated?

Re: Passing Multiple Parameter filters in Power BI Embedded

alihamud — Sun, 20 Nov 2016 12:05:02 GMT

you can use the JavaScript SDK

https://github.com/Microsoft/PowerBI-javascript

here is an example:

setting three filters on three column with multiple values:

filters1 = [
{
"$schema": "http://powerbi.com/product/schema#advanced",
"target": {
"table": "Date",
"column": "Date"
},
"logicalOperator": "And",
"conditions": [
{
"operator": "GreaterThan",
"value": "2014-04-11T21:00:00.000Z"
}
]
},
{
"$schema": "http://powerbi.com/product/schema#basic",
"target": {
"table": "Department",
"column": "Department"
},
"operator": "NotIn",
"values": [
396,
395,
399
]
},
{
"$schema": "http://powerbi.com/product/schema#basic",
"target": {
"table": "Business Area",
"column": "Business Area"
},
"operator": "In",
"values": [
"R&D"
]
}
]

report.setFilters(filters1)
.then(function (result) {
$("#result").html("Done.
" + JSON.stringify(result));
})
.catch(function (errors) {
$("#result").html("Error.
" + JSON.stringify(errors));
});

Re: Passing Multiple Parameter filters in Power BI Embedded

alihamud — Sun, 20 Nov 2016 12:10:08 GMT

you can do that using the PowerBI Javascript SDK

https://github.com/Microsoft/PowerBI-javascript

example: setting filters for three columns with multiple values:

filters1 = [{
"$schema": "http://powerbi.com/product/schema#advanced",
"target": {
"table": "Date",
"column": "Date"
},
"logicalOperator": "And",
"conditions": [{
"operator": "GreaterThan",
"value": "2014-04-11T21:00:00.000Z"
}]
}, {
"$schema": "http://powerbi.com/product/schema#basic",
"target": {
"table": "Department",
"column": "Department"
},
"operator": "NotIn",
"values": [
396,
395,
399
]
}, {
"$schema": "http://powerbi.com/product/schema#basic",
"target": {
"table": "Business Area",
"column": "Business Area"
},
"operator": "In",
"values": [
"R&D"
]
}]

report.setFilters(filters1)
.then(function(result) {
$("#result").html("Done.
" + JSON.stringify(result));
})
.catch(function(errors) {
$("#result").html("Error.
" + JSON.stringify(errors));
});

Re: Passing Multiple Parameter filters in Power BI Embedded

codjangmah — Mon, 21 Nov 2016 04:04:26 GMT

Thanks Allmud.. Very helpful guide.

Re: Passing Multiple Parameter filters in Power BI Embedded

zq — Fri, 24 Feb 2017 09:38:06 GMT

Hi alihamud, I have used the method described by you for filtering the report based on 2 columns from 2 different tables. However, combined these filterts not work whereas the separate filters work fine. Following is my code:

basicFilter = [

{
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "xyz",
column: "department_id"
},
operator: 'In',
values: [@ViewBag.DepartmentID]
},
{
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "abc",
column: "department_id"
},
operator: 'In',
values: [@ViewBag.DepartmentID]
}
]

If I only apply the filter for table xyz/abc, it works fine. It seems so that combining filters is an issue. Please help