How to connect to Azure analysis perspective

[atomar070]

Hi,

Can anyone please help me with how to connect to Azure analysis services perspective. It is not allowing me to connect to perspective. Below is the error i am getting. Note - I am admin for cube server. I want my user to connect to signle perspective.

[v-yuta-msft]

@atomar070 ,

Firstly, please check if the servername\instancename is valid. Secondly, please check if the AS admin has assigned the member as admin like below:

 

Community Support Team _ Jimmy Tao

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

[atomar070]

@v-yuta-msft Yes, i have been assigned the similar access and yes i am using the correct server name. While i am putting database name then i am able to connect. The problem begings when i try to put the perspective name instead of datase.

[zoloturu]

Hi  @atomar070 , 

In case you want to connect to Analysis Services perspective you need to leave database field empty and press OK. Then you will be able to select your perspective.

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

It was useful? Press Thumbs Up!

[atomar070]

Hi @zoloturu - I don't want to give user facility to select the perspective. Because in this case they can select the main perspective as well. If i can facilitate them with only one perspective only then they will not be able to see other fact and dimension which are not there in that perspective. Do we have any way where we can directly connect to perspective directly.

[zoloturu]

@atomar070 , 

You need to leave access to specific perspectives for specific users. So then each user will see only allowed ones.

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

[atomar070]

Hi @zoloturu, How do i give access to particular perspective. It allow giving access to database level.

[atomar070 · Accepted solution]

Hi @zoloturu , @v-yuta-msft  -  I have got it worked with Object-level security. Thank you both for your help.

https://docs.microsoft.com/en-us/analysis-services/tabular-models/object-level-security