Forum Discussion

tdga's avatar
tdga
Frequent Visitor
8 years ago

Role security in SSAS tabular model doesn’t have an effect on APP-workspace and BI desktop

Hi I’ve created a SSAS tabular model 1200 where there are two sets of roles; Administrator and Financial For the moment, I only have one user with ‘Read’ permission in the ‘Financial’ role. The...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

tdga

 

What are the permissions you configured for those users in that App Workspace? 

 

Regards,

tdga's avatar
tdga
Frequent Visitor
8 years ago

Hi there

Thanks for the reply!

 

It's a Danish version of PowerBI Service but hope it's good enough.

 

I've added two members who can edit the content for the app workspace. One of the members are administrator on the tabular model and the second one has a "Read permission" on the tabular model -  but for the app workspace it's only those two members who can edit the content for the app workspace.

 

 

 

For the specific App I've given acces to several users but it's only 1 member from the tabular model (Role settings) that have read permission. The other users within the organisation can acces the power bi content from Power BI Services but since the settings in the tabular model with live connection only has 1 administrator user and 1 read user I wouldn't expect that the others users would be able to see the App content even though they have been given acces as shown below for the specific App.

 

It might be that I've missed something but since it's a LIVE connection connected to a tabular model I would expect that all the permissions were granted from within the tabular model?

 

Thanks in advance

/TDGA