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: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
MorelG
Frequent Visitor
‎07-25-2024 05:46 AM

We are facing the same issue. This is something that is very important to fix. It affects the work of developers.

wgjunsay
Advocate I
Advocate I
‎08-07-2024 10:19 AM

It's just unfortunate because this is something that used to work before. But I believe the recent updates have caused this to no longer work. 

Ry009
Helper II
Helper II
‎08-15-2024 09:51 PM

Yeah this is really important for this to work.

AMUI
Regular Visitor
‎08-25-2024 10:58 PM

Hi,

Same issue over here.

Ry009
Helper II
Helper II
‎09-02-2024 04:05 PM

Same issue here.

jimmyhuang
Regular Visitor
‎09-09-2024 12:06 PM

Same issue here, please work on a fix, as we have mutiple reports connecting to the same model via live connection, so it's critical for us to test, especially we only have  a single model.  This was working before the I added a direct query to another data model within the power bi workspace, now I can no longer test and verify the RLS.

flbda
New Member
‎11-08-2024 10:52 AM

My reports, which used to work, are now inaccessible. As a workspace admin, I need the 'As Role' function to ensure report consistency.

ptmuldoon
Resolver I
Resolver I
‎12-04-2024 12:13 PM

Same here.   I need to be able to test a role as another user.

Idea Statuses