Dynamic RLS solution is not working for newly added users

[Sajna_M]

Hi All,

I created a Power bi solution which integrates with SQL server which stores the user transactional data, Company mapping table, Roles, Participants information.

In Roles table RT, I have column like RoleID, RoleName

In partipants table PT, I have column like RoleID, Username, email Id

In user transaction table UTT, I have columns like ticket ID and company name

In company mapping table CMT, I have column like company name and RoleId

Step 1:

Created a relationship between transaction data and permission master data based on company name and RoleId

Step 2:

We have created a RLS and added a condition in user transaction data as lookupvalue(UTT.companyname,  UTT.Companyname, UTT.Companyname, PT.emailID, USERNAME())

Step 3: published and added users into roles (RLS part)

Output: it started to give right output for role users with right level.

Problem: when we add new user in SQL database and refresh data set.  For the newly added users, the respective transaction data is missing. Seems like, we have to publish the report again to apply for the newly added user to view their respective data.

Is it right? Is there any solution for this? I wish to see this by refreshing dataset.

Regards!

[Seward12533]

Is this on the service? If so you need to set up a gateway and enable scheduled refresh of the dataset.  The "Refresh Button" on the service does not do this. 

[Sajna_M]

We have power bi reports which use SQL server connection to import the data in the model container. Then I publish this report into workspace.

Still the 'refresh now' on dataset won;t work?

Regards!

[Seward12533]

I believe the “Refresh Now” only updates the report from the data set. Are you using the redhead icon on the data set itself and/or do you have scheduled refresh turned on for the data set? Assuming refresh all and rebuild bing works on the desktop. If so this is probably baboybabetter question for the community on the BI Service forum vs desktop.

[Sajna_M]

I tried with refresh now, din't try with schedule refresh.

What is redhead icon on the data set itself means?

You are right, I missed that part. I will create a request under service.