Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have report which uses a composite data model, with a mix between DirectQuery to other Power BI datasets and some imported tables from SQL Server. The model also uses calculation groups, allthough I do not think this is related to the issue.
The data model also has RLS, and I can test this in desktop and it works as intended.
However, when I publish the report to the service and I want to "test as role", I get the following error message.
Is this a bug, or is "test as role" really not supported for a composite model?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @daaa ,
Please check if SSO is enabled. The Test as role/View as role feature doesn't work for DirectQuery models with single sign-on (SSO) enabled.
Through my testing, dq schema connection to sql server data source mixed with import schema of sql server's composite model, RLS takes effect. lc schema connection to power bi dataset then converted to dq schema and then mixed with import schema data source, RLS is not supported.
Refer: Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ Neeko