Forum Discussion
Helper IIIFilter passed by URL not respected when exporting Power BI report to pdf
- I would suggest having the filter that could be entered might be the way to get it working going forward.
Hi JDBOS ,
As mentioned in the article, the URL filters is not supported when exporting to PDF currently. Also, based on my research, I have found other considerations that URL filters are supported in some embedding scenarios and not in others:
- Embedding a report in a secure portal or website is supported.
- URL filters are supported in Power BI Embedded.
- Query string filtering doesn't work with Publish to web or Export to PDF.
- Embed with report web part in SharePoint Online doesn't support URL filters.
- Teams doesn't allow specifying a URL.
So if you want to use filter to export, maybe you could filter in the report in advance then export to pdf instead of using URL filters.
For more information about URL filter, please refer the microsoft document that could hope to help you: URL filters
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Correct. I have a "landing page" for the users to select the client and query string URL will be attached to the coverage data (insurance) we have on them. The user can click on the coverage link and be directed to the coverage report filtered for the selected client. Export using the steps I outlined above holds the filter selection. Screenshots below.
Landing page
filter coming from query string parameter
filter on hidden slicer visual. The filter on this visual for "is not 0" manufactures a single select
Screenshot of export to PPT
Advocate IKyle14
This formula works perfect for a single selection:
Client Filter = IF(HASONEVALUE(Data[Client Name]),SELECTEDVALUE(Data[Client Name])=FIRSTNONBLANK(Data[Client Name],1),0).
Do you have any ideas for a Multiple Selection concept, using the Slicer w/ Visual-level filter workflow ?