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 339 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
816 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
• 13,860 points
51 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
6 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,140 points
9 views
0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 35,750 points
35 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
442 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
647 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
• 7,560 points
45 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.