Forum Discussion
Dynamic Subscription - Dynamic Links? (RLS not a viable solution)
Hi jzwanziger
I can understand that this can be quite painful and currently there is no workaround for this besides using a bookmark. What you could do is potentially create a user filter on the report, so when they click on it, it would filter to just show what was in the report, but the user would then have to unfilter themselves in order to see all the other information. You can vote or create an idea here. https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas
Super UserHi jzwanziger
Currently, Power BI doesn’t support opening subscription email links with the same filters used in the subscription snapshot. The image/attachment can reflect the filtered view, but the link always opens the base report. Since you can’t use RLS due to broader data access needs, there isn’t a built-in option to fix this. Workarounds include using dynamic subscriptions for filtered snapshots and building custom filtered or bookmark-based links, but there’s no native toggle to match filters on the email link.
Thank you so much! I had a feeling this would be the case but wanted to make sure I didn't over look anything before submitting it as an idea. Submitted!
