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: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

0
RomainJJJ

Performances issue when mixing RLS on UserPinricpalName() and Composite model

Submitted by on ‎09-22-2022 02:02 PM

Hi,

A report made by a user on a composite model dataset (dataset based on a dataset on which RLS is applied via UserPrincipalName(), and mixed with local files) is very slow.

More than 30 seconds to refresh visuals on Power BI sheet (Services & Desktop same).

Same report, with a role without RLS, filtered on a value of the mail column, which is used to apply RLS with UserPrincipalName() functionnality, has no performance issue. all visuals are refreshed minus than 5 seconds.

No more performance issue with same visuals and RLS, but directly on the dataset (no local files added).

Any idea ?

Thanks

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎09-23-2022 12:34 AM

Hi @RomainJJJ ,

 

 Use RLS for all your users so that Power BI has to query the backend server separately and cache separate reports for every user, which might slow down the report performance. It's by design.

 

You may check  if these helps

Troubleshoot report performance in Power BI - Power BI | Microsoft Learn

 

Best Regards,
Community Support Team _ Caitlyn

 

Idea Statuses