topic Re: Power BI Embedded Filter Problem in Developer

Power BI Embedded Filter Problem

Knuckles — Tue, 02 Aug 2016 10:32:45 GMT

i try to create an angular 2 application with Power BI Embedded report.

I create a dashboard with a Report level filter on a Function Table that is used to retrive the data.

I use this code, with javascript, to set the report

var m = { 
                    action: "loadReport",
                    accessToken: response.AccessToken,
                    height: h, 
                    width: w,
                    oDataFilter:'CountryRegion eq "United States"'
             };

but when the report is show the filter is not set (but work when the user click on it)

Any suggestion?

Thanks!

Re: Power BI Embedded Filter Problem

jocaplan-MSFT — Tue, 02 Aug 2016 21:49:13 GMT

The filter needs to be set as a query string parameter on the embedURL.

Re: Power BI Embedded Filter Problem

Knuckles — Wed, 03 Aug 2016 08:46:27 GMT

thanks for your reply

i try this

iframe.src=response.Report.embedUrl +"&$filter=CountryRegion/CountryRegionName eq 'United States'";

but doesen't work....

Re: Power BI Embedded Filter Problem

Eric_Zhang — Wed, 03 Aug 2016 09:42:29 GMT

@Knuckles

Both adding the parameter in JS or adding query in embeded URL work in my test.

In JS, a format as below should work, DO NOT mess the single quote and double quotes. You can add an alert to debug the passed JSON.stringified message.

oDataFilter:'CountryRegion eq "United States"'
oDataFilter: "<table>/<column> eq '<filtervalue>'"

One thing important is that <table>/<column> is case-sensitive. Make sure you've specified the correct names.

Re: Power BI Embedded Filter Problem

Knuckles — Wed, 03 Aug 2016 09:50:09 GMT

thanks!

the problem was the single quote and double quotes!

Now all works!