Forum Discussion
Dynamic RLS solution is not working for newly added users
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!
4 Replies
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.
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!
- 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.
