Power BI Embedded Filter Problem

[Knuckles]

hi

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!

[jocaplan-MSFT]

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

[Knuckles]

thanks for your reply

i try this

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

but doesen't work....

[Eric_Zhang · Accepted solution]

@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.

[Knuckles]

thanks!

the problem was the single quote and double quotes!

Now all works!