Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

daaa

Test as role "not supported" message for composite model

Submitted by Advocate I on ‎09-12-2023 02:01 AM

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.

rls2.PNGrls1.PNG

Is this a bug, or is "test as role" really not supported for a composite model?

Status: Investigating

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

See more ideas labeled with:
28 Comments (28 New)
Comments
Randra
Regular Visitor
‎01-24-2024 11:49 PM

Facing the same issue here, hope this gets resolved soon!

oallner
New Member
‎02-12-2024 07:10 AM

I am also experiencing the exact same issue.

wkqdbig
Frequent Visitor
‎02-26-2024 07:21 AM

Adding to the noise on this one, please add option! The only way around it currently is to bother an external/ other user to verify it's all kicking in correctly. Problematic when sub-teams are adding their own customisations to the composite, we can't just pull the report back onto a dataset close to source to test it. 

wgjunsay
Advocate I
Advocate I
‎03-08-2024 12:28 PM

Hello, is there an update on this?? I am still experiencing it in Power BI service for one of my models. 
@v-tangjie-msft 

nosikliw
New Member
‎04-10-2024 07:41 AM

I'm having the same issue.  Looking for a solution to this please!

DamianDavies
Frequent Visitor
‎04-16-2024 01:04 AM

Me too d;)

johnbasha33
Super User
Super User
‎05-03-2024 04:54 AM

I am also facing the same issue. 

electrifiedg
Advocate I
Advocate I
‎05-31-2024 01:25 PM

I am also facing the same issue and 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.

daaa
Advocate I
Advocate I
‎06-02-2024 10:08 PM

Hi all,

 

I have created a copy of this issue on 

https://community.fabric.microsoft.com/t5/Issues/Test-as-role-quot-not-supported-quot-message-for-co... 

Since this one seems to be completely ignored.

F1-Checo
Regular Visitor
‎06-20-2024 07:08 PM

Same issue here. Why there are so few votes? I think this should be affecting many developers.

Idea Statuses