Read only permission to See different tables and Measure defination SSAS

[dhrub]

Dear Team, 

Need your advice . 

I have a SSAS Server , now that server has many tables , Relationships and Measure . . 

I want to give access to another person as read only view of all the measures defination P1 (dax code) ,tables relationships,
i have provided read permission but person is seeing neither the model nor the tables or the measures .

Please guide me what steps i need to take in order to give Read view of all the measures present in the Analysis services server.

I don't want to give Admin rights as he is a new resources at same time user needs to view the measures defination for analysis 

Also same problem in Power bi , he can connect to power bi SSAS cube but when he clicks on the measure within power bi  , he can't see the measure defination.

Please advice on this  

Reference : but its not working for me 
https://learn.microsoft.com/en-us/analysis-services/tabular-models/roles-ssas-tabular?view=asallprod...

[dhrub]

Thank you for quick reply , i will try this and then advice you if it works or i may need more help . .thanks again .
I need some more time as i have to request owner of the cube to try

[Anonymous · Accepted solution]

Hi @dhrub ,

You can deploy SSAS in visual studio and subsequently create roles:

First, you can create a pivot view to see all the measurements and tables

Subsequently, it is straightforward to create roles, apply perspective views, and set up read-only roles

Select a character and a perspective view for testing

Once all is complete, it can be deployed to SSMS

Below is the official link will help you:

Analysis Services tutorial lesson 8 Create perspectives | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.