Filters to Embed URL in Power BI Embedded

[nagaraj]

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

[Ahak]

Hi @nagaraj 

Is their also a possibility to add an parameter instead of "hardword" for examlpe the the customerID? 

thanks and best regards,

[amitchandak]

@nagaraj , refer if this can help

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

[nagaraj]

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/

[v-deddai1-msft]

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

[nagaraj · 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

[v-deddai1-msft]

Hi @nagaraj,

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

Best Regards,

Dedmon Dai

[nagaraj]

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

[v-deddai1-msft]

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

[nagaraj]

done.