Username() filtering a simple table. No RLS or TABLE EDITOR

[Veigale]

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?

[Veigale]

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.

[lbendlin]

What you are doing is basically dynamic RLS.  Note that USERPRINCIPALNAME()  is preferred. USERNAME is inconsistent between desktop and service.

[Veigale]

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.

[Veigale]

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.

[lbendlin]

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.

[Veigale]

See, I checked some dynamic RSL guidance, but see. In this step I have to enter the 800 employees' emails, for example.
And this is also dynamic. Tomorrow it could be 700/900.

It's just something so I don't have to do this that I'm looking for.

See the figure.
I am required to enter emails for RLS to work.