Analysis Service Tabular Model 2019 security for Power BI report

Hi, kaushikmakadia 

It sounds like an RLS solution. Row level security is a Power Bi feature that allows you to create rules for users. Those rules (DAX code) will filter the current model.

You can read more in microsoft doc: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

That will show how to implement it.

Here you have a second link in case you feel that the first documentation won't work. There are ways to make it dynamic but it might be a little more complex: https://blog.ladataweb.com.ar/post/652895563673649152/powerbi-seguridad-de-filas-rls-con-regla

I hope all of that helps you.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.