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.
Helper IIIAs an update on our successful progress 🎆 , here's a screenshot.
Since we're not using embedded scenarios, the red box shows the Filter for Record ID that was passed by URL but was not able to be passed to a PDF.
So, we added an additional "Filter on all Pages" for the "Service Plan Name" field.
Since it's unique for records of this Service Plan record type, PBI Svc displays a single record to select.
When selected, this results in the same tables as the Filter by the Record ID passed by the URL.
An extra step but relatively easy since it's just clicking a single filter box.
The next challenge is that another Service Plan record type is not unique, so we may need to create a unique key that will allow us to access fields in all of the dataset's tables that are required for this multi-page report... Sounds like I may be posting another question 😊
Thanks to v-yingjl and GilbertQ for their coaching!
Super User