Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |