Forum Discussion
How to create User prompt for only querying a specific record/customer from DB
Hi, I have a usecase where I have to build a PowerBI customers report for several PowerBI endusers. The report is containing: Customer number, Customer Name, Account number, Account value, Account...
Hi Gengar
RLS is not an option as I see it.
The end user is only allowed access to data related to the specific customer for a specific task she/he is working on at a given time.
If we only restrict by RLS she has all customers and there accounts in the dataset at all time, and will not restrict for a specific customer dynamicly.
Regards RYA