Forum Discussion

jzwanziger's avatar
jzwanziger
New Member
11 months ago
Solved

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

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...
Need Help
  • GilbertQ's avatar
    GilbertQ
    11 months ago

    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 

Anonymous's avatar
Anonymous
Not applicable
11 months ago

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