Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ovonel
Post Prodigy
Post Prodigy

troubleshooting slow reports after published?

I have published my .pbix, it works great, speed is fine. I consume from SSAS. Now, I have introduced some RLS security and for people accessing with limited permissions, it is awfully slow…

 

How can I troubleshoot this?

 

I have 3 roles.

 

Role1: (everyone has access):

 

RLS

 

Employee table:       =[NT Username] = USERNAME()

 

Projects table:

=[Key_Project] IN

SELECTCOLUMNS(

    FILTER(

        'Engagement Role'

        ,'Engagement Role'[UserName] = USERNAME()

        )

    ,"Key_project"

    ,'Engagement Role'[Key_project])

 

 

 

Role2: (everyone has access):

Employee table:

=[TeamLeadEmployeeID] IN

SELECTCOLUMNS(

                           FILTER(

                                                      'Employee Current'

                                                      ,'Employee Current'[NT UserName] = USERNAME()

                           )

                           ,"RLS_Ids"

                           ,[Employee Number])

 

 

Projects table:

= VAR MyEmployeeNumber=

SELECTCOLUMNS(

FILTER(

'Employee Current'

,'Employee Current'[NT Username]=USERNAME()

)

,"EmployeeNumber"

,'Employee Current'[Employee Number]

)

 

 

VAR My_Employees =

SELECTCOLUMNS(

    FILTER(

'Employee Current'

,'Employee Current'[TeamLeadEmployeeID] = MyEmployeeNumber

) ,"EmployeeNumber"

    ,'Employee Current'[Employee Number]

)

 

RETURN

[Key_project] IN

SELECTCOLUMNS(

    FILTER(

        'Engagement Role'

        ,'Engagement Role'[Employee Number] IN My_Employees

    )

    ,"Key_project"

    ,'Engagement Role'[Key_project]

)

 

 

 

 

(the 3rd role doesnt really matter, it has no filters is Read all access).

0 REPLIES 0

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.