topic Re: Read only permission to See different tables and Measure defination SSAS in Report Server

Read only permission to See different tables and Measure defination SSAS

dhrub — Tue, 23 Jan 2024 20:10:58 GMT

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=asallproducts-allversions

Re: Read only permission to See different tables and Measure defination SSAS

Anonymous — Tue, 06 Feb 2024 07:01:21 GMT

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.

Re: Read only permission to See different tables and Measure defination SSAS

dhrub — Wed, 24 Jan 2024 15:08:56 GMT

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