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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

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

 

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎09-23-2022 12:34 AM
Status changed to: Delivered

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