Forum Discussion
Helper IXMLA endpoint - can't create ROLES after last service update - Workaround
after march service update not possible create roles over XMLA PPU (RLS).
If model is published without roles .
Checked with - SQL Managment studio and Tabular editor .
Only way is :
1) Delete semantic model from PPU
2) Create roles on model (Local)
3) Publish model to PPU
If you're creating a role in tabular editor you need to set it's model permissions to read. Have a look at https://docs.tabulareditor.com/te3/tutorials/data-security/data-security-setup-rls.html#:~:text=Add%20a%20New%20Role,'%3A%20Name%20the%20new%20role.
Message also suggests the model has an unsupported locale. See if the above fixes your problem first though.
5 Replies
Hi dim123dim123 ,
Could you please provide more details?
1.What error messages (if any) were encountered when trying to create the role?
2.Did you verify that the tools (SSMS, form editor) are up to date?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.
dim123dim123Hi ,
of cource i can
1.
2. SSMS not up to date - this is not nessesary . Tabular Editor 2 and 3 up to date.
3. Only first model deploy with roles pass without errors. after not possible additional another role ( need again remove semantic model , add role in local mode and deploy ) .
- bcdobbs
Community Champion
If you're creating a role in tabular editor you need to set it's model permissions to read. Have a look at https://docs.tabulareditor.com/te3/tutorials/data-security/data-security-setup-rls.html#:~:text=Add%20a%20New%20Role,'%3A%20Name%20the%20new%20role.
Message also suggests the model has an unsupported locale. See if the above fixes your problem first though.
- dim123dim123
hi Ben ,
yes, I checked that this is a solution for PPU .
It is interesting that there was no error before the last update.So PPU and probably Azure Analysis now need Rights options.
SQL Analysis (onPremm) accept role without permissions option
But - when i create Role - model Permission None and publish to PPU at first time - this success .
I think this is service bug
- bcdobbs
That is odd. I've certainly received that error before over the last few years in the various different combinations of ppu and p1 capacity.
