make report individual for each user that uses the report

[truttafisker]

hi there 

I have a report which I want to share with alot of people (aprox 1000 users).

I use the analysis service to get my data.

.. But I'm not sure how to approach this .. the users should only be allowed to see data that is relevant for their organization.
The users are not added to my AD so I thought of managing their access to the report, by letting them contact me, I add them "somewhere" and somehow restrict their access to the dataset from the analysis service to what's only relevant to them.

.. but I don't know what the most correct way would be .. 

It seems that I can't use the "Manage roles" feature in Power BI desktop, because I'm using the analysis service.

so would the what would the correct approac to this be ?

I'm pretty sure that I'm not the first with this issue, but I can't figure out if RLS, Service Principals or something else would be the best way to do this .. 

[freginier]

Hey there!

I think your best option would be Row-Level Security (RLS) in Analysis Services, along with a method for user authentication and filtering.

- Since you're using Analysis Services, RLS should be configured in the model, not in Power BI Desktop.

- Define roles in Analysis Services with DAX filters that apply user-specific restrictions.

- Use the USERNAME() or USERPRINCIPALNAME() function in DAX to filter data dynamically based on the logged-in user.

Hope this helps!

😁😁

[Deku]

It sounds like you are building a thin report on top a existing analysis services model.

You would need RLS defined in the analysis services model

[MattiaFratello]

Hi @truttafisker, 

I think your best shot could be to implement Dynamic Row-Level Security (RLS) in Analysis Services.