Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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
Solved! Go to Solution.
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
Hi @nagaraj
Is their also a possibility to add an parameter instead of "hardword" for examlpe the the customerID?
thanks and best regards,
@nagaraj , refer if this can help
https://community.powerbi.com/t5/Developer/Power-BI-Embedded-Filters/m-p/1148452
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/
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
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
Hi @nagaraj,
I noticed that your URL contains \\ before and after Eagle. Is it escape character?
Best Regards,
Dedmon Dai
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.
User | Count |
---|---|
94 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
146 | |
112 | |
73 | |
56 |