Dynamic Subscription - Dynamic Links? (RLS not a viable solution)

[jzwanziger]

Hey y'all!

We've set up several dynamic subscriptions for our sales reports. They're great - but it's a bit frustrating that the link in the email doesn't connect to a filtered report to match the image in the subscription. We've instructed our team to use a bookmark once they open the link, but it's not ideal. 

Hoping I've just somehow missed a magic setting option in all the research I've done. Is it possible to update this? 

While the report would match via the link if we instigated RLS - our users do often need to see data that's not relevant to this specific subscription filter requirement, so RLS isn't an option for us here. 

[Poojara_D12]

Hi @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.

[jzwanziger]

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!

[v-pgoloju]

Hi @jzwanziger,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @GilbertQ  for prompt and helpful response.

It might be possible to handle this using Power Automate  you can set up a scheduled flow that exports the report with certain filters applied and emails it to users, possibly including a filtered report link. I haven’t tried setting it up myself, but it could be worth exploring as a workaround. if it's important to you please consider creating an idea as suggested by @GilbertQ.

Thanks & Regards,

Prasanna Kumar

[GilbertQ · Accepted 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 

[jzwanziger]

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!