Forum Discussion
Users removed/overwritten from RLS roles after model redeploy
We're having a very specific issue that we're hoping someone can help with. We're in the process of publishing our tabular models to a Power BI PPU workspace to use them as PBI datasets rather than deploying them to a separate Azure Analysis Services server, and have hit an RLS-related snag on the first model.
We figured out that we can't have users assigned to RLS roles when we publish our model from Visual Studio to our workspace, so we removed them from the model and just added them to the roles once it was in the workspace. However, when we publish changes to the model, the users get removed from the roles, presumably because they are overwritten with the empty roles from the model in VS. Is there a setting somewhere that can prevent this from happening?
The only workaround we've come up with is scripting changes to the roles through SSMS after the model is deployed. So far we've only figured out how to do this manually, but would like to kick it off automatically. If we need to go this route, we were wondering if there's any kind of notification on the PBI server that is created when a dataset is published. Ideally we would find a way to run the scripts based on that. Any assistance with either solution is greatly appreciated; please let me know if more clarification is needed.
Hi LeifB
What you could do is to download and install the BISM Normalizer which will allow you to granularly control which aspects you want deployed to PPUHere is the website: Home Page - BISM Normalizer (bism-normalizer.com)
And this is created by Christian Wade who works on the Power BI team.
3 Replies
- GilbertQSuper User
Hi LeifB
What you could do is to download and install the BISM Normalizer which will allow you to granularly control which aspects you want deployed to PPUHere is the website: Home Page - BISM Normalizer (bism-normalizer.com)
And this is created by Christian Wade who works on the Power BI team.
- GilbertQSuper User
Awesome, happy to help where I can!