Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Link one report to another, and include dynamic URL values for filtering

Hi all.

I'm building reports in desktop, publishing to service and then sharing with my colleagues as embedded reports in Sharepoint.

This my scenario:

Report 1. This allows the user to search for an account id. I want to be able to include a link, to report 2, where the account id the user has searched for is used as a filter on report 2.

This is mainly for reasons off efficiency. Due to the nature of the data I cannot aggregate and it is millions of rows. Adding this data to report 1 makes it very large.

Is it possible to create a link from report 1, which contains the account id filter which will then be applied when the user clicks on the link to the report 2?

Many thanks!

Community Support
Community Support

Hi @JonSwed 

Not sure, do you mean you want the users to set account id on Report 1 and get the link to Report 2 filtered by account id? Could you show us your Report 1? 



Best Regards,

Community Support Team _Tang

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

Hi! Yes. The user can enter an account id. 

I then want to add that accountid to a link which will take the user to another report, which will then be filtered to the account id.

I cannot share the report, as it contains confidential information, but if it helps I can create a dummy version .

Helpful resources

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors