Forum Discussion
Username() filtering a simple table. No RLS or TABLE EDITOR
Gente, tudo bem?
Gostaria de uma maneira simples de medir com username(), filtrar uma tabela ou um visual.
Não quero usar o RLS e também o recurso Editor de Tabelas.
Há mais de 800 funcionários e o Painel está incorporado em uma página do SharePoint.
A ideia é que, ao acessar a página, esse funcionário veja apenas suas informações (username()).
Estou pesquisando na internet e só me deparo com RLS e Editor de Tabelas.
Alguém poderia ajudar?
6 Replies
What you are doing is basically dynamic RLS. Note that USERPRINCIPALNAME() is preferred. USERNAME is inconsistent between desktop and service.
yes, I will use USERPRINCIPALNAME().
I wouldn't want to enter users into the security configuration on the service. there are 800 employees.
I already tested and managed to get the nickname through the measurement, but I couldn't put it in a data segmenter, for example.I'm a newbie and I believe there must be a maneuver for this dynamic rls.
Read the documentation. Dynamic RLS works by having a reference table with email addresses and their permissions. That is your RLS table that then needs to control the rest of the data model.
I'm going to delve deeper into RLS.
But in the service, don't I have to insert the users that are in the table?That would be the difficulty.
If maintenance on the service is not necessary, the problem would be solved with the internal table.
I saw a feature in the Table editor and you can play the measure in the data segmenter, but it changes all the measures on the dashboard. This would be a problem, as I have other measurements in the visual.
