Forum Discussion
Dynamic Report Subscription
Under "Map my data" can you uncheck the "pre-existing filter option?
Hope you have read my article, I explained the RLS scenario there. Techically how dynamic subscriptions work in your scenario is, it will iterate over the list the list of email ids you selected and then applies the filter (which is email id column) and then sends one email for ever row.
Which is exactly what you are expecting, Since you have hardcoded your email in the "send to" section you got those many emails as many as the # of emails you have in the column you selected.In an ideal scenario, when you map email id column to the "Send to" section, you will not be able to choose the same the column in the "Report Filters" section as I have shown you in my previous response. So I created a duplicate column of my email id column and mapped the filters in this way
"Duplicate Email ID" = "Original Email ID"
So, these are my suggestions:
1. Uncheck the "Pre-existing" filters
(test the scubcription, I guess this should solve the blank visuls issue)
2. Create a duplicate email id column in your RLS table and and put the filter on it in "Report filters" section.
As I have mentioned in my article, this approach worked for me with out any issueHope this helps
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
To answer your question: Yes, you can choose same dataset/semantic model to map recipient data. Have done that multiple times.
can you check whether you have enabled, pre-existing filters option enabled? also check if that was reason for showing blank results.
Please do note, When you link email id column in your data as "Send To" Email then you will not be able to choose the same column as Report Filter, it will be grayed out.
like this
So, create a duplicate of email id column. And then in report filters section, choose the duplicate column as Filter On and then Original column as filter value. It should work.
I am attaching a blog post I wrote, where I explained about how dynamic RLS works
https://medium.com/@tharunkumarr98/power-bi-report-subscriptions-does-not-respect-rls-be66171f27e8
Hope it helps
Connect on LinkedIn
|
Thanks for the response! This is how i have it set up but I am getting the same result. Blank table and multiple emails.
i selected the dataset for connect to recipient data. This is the same dataset the report is connected to.
for select and filter data, i chose the email column of my user table. In the report, filtering on this column will give you MS Dynamics data for that user:
Email details. I just have myself as the recipient for my testing
Map your data. I am able to choose the same internalemailaddress field for both and have include my changes enabled.
tharunkumarRTK could it be because my RLS allows me to see all data? Is there a way to have it be just the ones where my email matches?
Under "Map my data" can you uncheck the "pre-existing filter option?
Hope you have read my article, I explained the RLS scenario there. Techically how dynamic subscriptions work in your scenario is, it will iterate over the list the list of email ids you selected and then applies the filter (which is email id column) and then sends one email for ever row.
Which is exactly what you are expecting, Since you have hardcoded your email in the "send to" section you got those many emails as many as the # of emails you have in the column you selected.In an ideal scenario, when you map email id column to the "Send to" section, you will not be able to choose the same the column in the "Report Filters" section as I have shown you in my previous response. So I created a duplicate column of my email id column and mapped the filters in this way
"Duplicate Email ID" = "Original Email ID"
So, these are my suggestions:
1. Uncheck the "Pre-existing" filters
(test the scubcription, I guess this should solve the blank visuls issue)
2. Create a duplicate email id column in your RLS table and and put the filter on it in "Report filters" section.
As I have mentioned in my article, this approach worked for me with out any issueHope this helps
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
