Forum Discussion

Scott_BI's avatar
Scott_BI
Advocate I
2 years ago
Solved

Add RLS to a semantic model being used as a data source

We have a semantic model created that encompasses an entire business domain. There are various groups who need access to reports based on this model, and each one has differing RLS requirements that sometimes overlap subject areas within the model. Up until recently our path has been to create a copy of the base model and add the ACL table and RLS to the copy. This results in extra overhead in ensuring the two models remain in sync.

 

To try an minimize the overhead, I'm trying to create a new model using the original semantic model as a DQ source, and then adding the ACL table and RLS roles. However, I am running into a problem. It works fine in Desktop when using "View as role." The visual filters and displays as expected. When I publish it to a premium backed workspace, I cannot use the View as Role feature as I get the following error.

 

 

And when I have someone test who has permissions to the report and is added to the appropriate role they get this message.

 

 

Is there a setting in service I'm missing? Any other suggestions?

 

Please help!

2 Replies