Hi Everyone,
I want to utilize role level security to allow users of a published report to set up there own filter table. My idea is that users can drop a file in a sharepoint that has SKU, their username, and filter name. In the model i will use a folder query in a dataflow to aggregate all files and then use powerautomate to refresh the flow and dataset whenever someone modififies or adds a file to the folder.
In the model I have the folder query dataflow table connected to the massive SKU list with a one to many relationship. I then setup a RLS where username = userprincipalname(). My hope is that is will only show the filters that that particular user setup, however, the RLS is filtering the table then subsequently filtered the entire SKU table to only SKUs in their file.
How do i setup role level security to only filter that individual table? I even tried disconnecting the tables and using lookupvalue to retrieve the filter name but i grabbed all of them and bypassed the RLS.
Help me out! This is a critical function for dozen of users to build custom filter tables on thousands of SKUs.
