cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Power BI Embedded Filter Problem

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

 

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

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

Highlighted

thanks for your reply

 

i try this

 

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

but doesen't work....

Highlighted

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

 

View solution in original post

Highlighted

thanks!

 

the problem was the single quote and double quotes!

 

Now all works!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.