Applying multiple filters in PBI Embed URL

0 votes

I need to filter my Power BI report, but it works only with a single filter and just ignores the other added filter. I've been attempting to do it by using the following filter query syntax:
&$filter={tableName/fieldName} eq '{fieldValue}'
Like it just works if I add just one filter; but even upon adding multiple filters, the PBI report just gets filtered as per the first applied filter and doesn't acknowledge the other filters even after adding multiple ones.
Is there some other way that I've missed out on applying multiple filters to the Power BI Embed URL?

Aug 21, 2018 in Power BI by Bharani
• 4,550 points

recategorized Aug 23, 2018 by Vardhan 473 views

1 answer to this question.

0 votes

Well, that is actually a limitation in its previous version, where report embeds are limited to a single filter expression only. 

You can get the support for multiple filters and even other client-side commands with its new release of 2.0.0.  With this release, you can even get and set filters at report scope and page scope, but I'm guessing the visual scope is still a few more upgrades away.

Check this out if you wish to understand how the SDK can be used to apply filters: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters 

And, check this out for setting filters during load: https://github.com/Microsoft/PowerBI-JavaScript/wiki/Embed-Configuration-Details

Or this, to check out a demonstration on using filters: https://microsoft.github.io/PowerBI-JavaScript/demo/filters.html

FYI - If you want to make the filters you apply more secure so that clients are unable to modify it, use RLS on the report, and then add the username and the role claims to your JWT token if required. Doing this will ensure that requests to view the report with this token will only show data for allowed user or role.
And, The OData $filter parameter only extends supports for a small subset of filter capabilities. To support more complex values or conditions, it is better to construct filter objects using the SDK.

answered Aug 21, 2018 by DataKing99
• 8,100 points

Related Questions In Power BI

+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 14,080 points
1,295 views
0 votes
1 answer
0 votes
1 answer

How to combine multiple tables in power BI?

Hi Sindhu, You can merge the 3 tables ...READ MORE

answered Mar 14 in Power BI by Cherukuri
• 17,710 points
190 views
0 votes
0 answers

How do you change the tables in chart filters?

I am working on a report that shows ...READ MORE

May 10 in Power BI by anonymous
22 views
0 votes
1 answer

How do you change the tables in chart filters?

Hi, You can use the following measure. Measure 2 = ...READ MORE

answered May 10 in Power BI by Avantika
• 1,460 points
18 views
0 votes
1 answer

How to filter on multiple columns in single table

I used dummy data to show how to ...READ MORE

answered Jul 10 in Power BI by sindhu
87 views
0 votes
1 answer

Embed URL-multiple filters in Power BI

With the release of 2.0.0 you can ...READ MORE

answered Oct 16, 2018 in Power BI by Annie97
• 2,190 points
678 views
0 votes
1 answer

Passing a parameter to Power BI Embedded via embedded URL

Add the following to the end of ...READ MORE

answered Oct 23, 2018 in Power BI by Annie97
• 2,190 points
838 views
0 votes
1 answer

powerbi embeded in .net core 1.1

See if it helps: https://www.nuget.org/packages/PowerBI.NetStandard ...READ MORE

answered Nov 28, 2018 in Power BI by Upasana
• 8,410 points
68 views