cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nagaraj
Post Patron
Post Patron

Filters to Embed URL in Power BI Embedded

Hi,

 

 I have a requirement to append the filters like below to the Embed URL in (Power BI Embedded)

 

?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

 

Was following as mentioned in this link 

 

 https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

 

Manually if i try this its working, but when adding filters to Embed URL its not working.

 

Please guide if I am doing to correctly and how to resolve this.

 

REgards

Nagaraj

1 ACCEPTED SOLUTION

Hi @v-deddai1-msft 

 

I was able to add URL filters to Embed URL and its working. Below is the syntax i used

 

report.EmbedUrl + "&filter=FundProperty/FundName eq \\'Eagle\\'";

 

Regards

Nagaraj

View solution in original post

8 REPLIES 8
amitchandak
Super User IV
Super User IV

@nagaraj , refer if this can help

https://community.powerbi.com/t5/Developer/Power-BI-Embedded-Filters/m-p/1148452



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

HI @amitchandak 

 

 Below URL referring to how the filters can be applied in the javascript. But as per the below documentation i can see that we can embed the fitlers directly in the URL so that no need to use javascript API for this task and is easy for some scenarios 

 

https://azure.microsoft.com/en-us/updates/power-bi-embedded-advanced-url-filtering-capabilities/

2.jpg

Hi @nagaraj ,

 

It is not supported to add URL Filters to Power BI Embedded URL in Power BI currently .There is an idea about this issue, please vote it up, Allow filters in the url for an embedded report , to improve the Power BI.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Hi @v-deddai1-msft 

 

I was able to add URL filters to Embed URL and its working. Below is the syntax i used

 

report.EmbedUrl + "&filter=FundProperty/FundName eq \\'Eagle\\'";

 

Regards

Nagaraj

View solution in original post

Hi @nagaraj,

 

I noticed that your URL contains \\ before and after Eagle. Is it escape character?

 

Best Regards,

Dedmon Dai

yes those are escape characters. We are passing the URL from dotnet to Javascript API, hence the first slash is escape sequence in C# and the second one is for escape sequence for Javascript Regards Nagaraj

Hi @nagaraj ,

 

Thank you for sharing the solution and explaining it for me , Would you please accept your reply as answer that people with same issue would find it more quickly.

 

Best Regards,

Dedmon Dai

done.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.