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,660 points

recategorized Aug 23, 2018 by Vardhan 2,820 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: 

And, check this out for setting filters during load:

Or this, to check out a demonstration on using filters:

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,240 points

Related Questions In Power BI

0 votes
1 answer
+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
• 18,570 points
0 votes
1 answer

How do you embed dashboard using JavaScript in Power BI?

Dashboards in Power BI can be embedded ...READ MORE

answered Mar 5, 2019 in Power BI by Phalguni
• 1,020 points
0 votes
4 answers

How to combine multiple tables in power BI?

Click Advanced Editor and check if step #"Appended ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
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, 2019 in Power BI by anonymous
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, 2019 in Power BI by Avantika
• 1,520 points
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,160 points
0 votes
1 answer

Using Multiple filters in DAX

CALCULATE is defined as CALCULATE(<expression>,<filter1>,<filter2>…) This means that you can ...READ MORE

answered Dec 22, 2020 in Power BI by Gitika
• 65,910 points
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,160 points
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP