cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Filter passed by URL not respected when exporting Power BI report to pdf

We have a report that receives a Record ID via a URL and the Record ID is then used to filter all pages.

Although we realize that per the article: Export reports from Power BI to pdf

"URL filters aren't currently respected when you choose Current Values for your export..."

We're hoping someone may have found a work-around.

 

Since it's just a record ID, is there an easy way for the user to "copy and paste it" so it's then considered a "changed filter value"

Just editing and re-entering doesn't seem to work - seems like the URL that includes the filter may be part of the problem.

 

Thanks in advance for your coaching!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Filter 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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Community Support
Community Support

Re: Filter passed by URL not respected when exporting Power BI report to pdf

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:

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 Li

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

View solution in original post

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Filter passed by URL not respected when exporting Power BI report to pdf

Hi there, as far as I am currently aware there is no way to respect the export to PDF.

With that being said there is the capability to copy a visual as an image

https://powerbi.microsoft.com/en-us/blog/announcing-copy-a-visual-as-an-image/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Helper II
Helper II

Re: Filter passed by URL not respected when exporting Power BI report to pdf

@GilbertQ  thanks for the coaching - unfortunately, this is for a nonprofit reporting on activity and outcome metrics so each page of the report has several viz, but we could certainly do "screenshots" and paste them in to a doc.  

We're also exploring having another filter that could be entered based on the value in the passed record but we're trying to avoid re-entering info.

Highlighted
Super User IV
Super User IV

Re: Filter 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.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Community Support
Community Support

Re: Filter passed by URL not respected when exporting Power BI report to pdf

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:

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 Li

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

View solution in original post

Highlighted
Helper II
Helper II

Re: Filter passed by URL not respected when exporting Power BI report to pdf

As 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!

image.png

 

 

 

 

Highlighted
Super User IV
Super User IV

Re: Filter passed by URL not respected when exporting Power BI report to pdf

Awesome thanks for showing us how you solved it!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors