Forum Discussion
Filter results from SharePoint query in advanced editor
Anonymous RLS is going to be a "Pro" level feature, which would require all users to have a Pro license.
Based on what you are saying, I really think it is what you are asking to do. Give a look in those links, and if it works out or not comment back so we can explore further or close out the thread for others.
Anonymous I'll try this again, but the answer is the same. You want row level security.
Bring in the entire data set. It will have all engineers. There are multiple ways you can implement Row Level Security, either a user directly associated to a role (described in the previous link), or create a mapping table that you reference in your DAX function which validates the user coming in using the USERNAME() function in DAX. A walkthrough was done by Reza Rad here
Essentially, rather than try to filter things on the input (in Power Query) - Which won't be dynamic in the external facing report -> you need to set this up in the external facing part where any user logging in will only see their data.
Anonymous Thanks, I'll dive into that. I thought it was only for authorization puposes did not realize it could be a solution for my problem.
Problem could be I need the pro version for this. With a large amount of users...
Anonymous RLS is going to be a "Pro" level feature, which would require all users to have a Pro license.
Based on what you are saying, I really think it is what you are asking to do. Give a look in those links, and if it works out or not comment back so we can explore further or close out the thread for others.