Forum Discussion
Microsoft 365 Usage Analytics - Customise
Hi All, I'm a total newbie and would like to learn the basics. 1. For the standard report as above, I'd like to customise/filter all the data to be against a specific company chosen under "UserS...
HI JF29,
You can create a mapping table to map users and their company, then you can setting RLS based on username and corresponding company: (use username to find out the company and apply RLS filter on company filed)
RLS with UserName()
Regards,
Xiaoxin Sheng
Hi Anonymous
Thanks for your reply.
I saw your link but am new to all this. Do you have a guide/link on how to do that?
Sorry I'm new to this.
Kind regards,
Jon
Hi JF29,
You can refer to the below blog to know more about RLS operation and configuration:
Power BI Desktop Dynamic security cheat sheet
Regards,
Xiaoxin Sheng