Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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.
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
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.