Forum Discussion

THowkins96's avatar
THowkins96
Regular Visitor
8 months ago
Solved

Implementing RLS in Dynamic Subscriptions

Hi all,   Looking for some guidance here regarding the new dynamic subscriptions. Is there a way that I can implement my existing RLS in the model to my subscriptions? I have a contact list to powe...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    8 months ago

    Hi THowkins96 ,

    Please ensure all the prerequisites are being met

     

    Additionally, re check all the steps that are mentioned in the document and check.



    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

v-nmadadi-msft's avatar
v-nmadadi-msft
Community Support
8 months ago

Hi THowkins96 ,

The DAX seems good enough but I would still recommend you to figure out why the RLS that lives in the model doesn't activate in subscriptions, fix that issue so that dynamic subcription works in the intended way.

Some points which may help figure out why its not working correctly:

"Power BI connects to two different semantic models. One contains subscription recipient data, including email addresses of the managers. The other contains the data and defines the mapping between recipients and filters. When it's time to send the report, the latest data available in this second semantic model determines which manager receives a report in their inbox, and what filters are used in that report."
Make sure both the semantic models are correct especially the semantic model which contains recepient data.

Additionally, Build permissions to a Power BI semantic model that contains recipient data. This data includes the email addresses of your recipients and filter values that should be applied for each recipient.

I hope this information helps. Please do let us know if you have any further queries.
Thank you

THowkins96's avatar
THowkins96
Regular Visitor
8 months ago

Hi v-nmadadi-msft 

 

Thanks for this - Can confirm that I'm not actually using 2 separate semantic models, I ingested my subscription list source into the model that I want to use the subscription for. I actually stripped it back and started from square one again of simply adding in the sub list source, leaving the table disconnected from all other tables and then setting up the subscription using the email address, subject and attachment type to define who is sent the email and in what format and then i put a dynamic filter on sub list node = node in my RLS bridge table.

 

This returned a blank result still so I am at my whits end with it to be honest

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    8 months ago

    Hi THowkins96 ,

    Please ensure all the prerequisites are being met

     

    Additionally, re check all the steps that are mentioned in the document and check.



    I hope this information helps. Please do let us know if you have any further queries.
    Thank you