Forum Discussion

satyamsd21's avatar
satyamsd21
New Member
2 years ago
Solved

PBI Paginated Reports RLS importing from SSAS

Hi,  Context: There is Paginated report directly connected to SSAS server. SSAS has RLS applied on itself which is confirmed using pbi report pbix file. But the Paginatted report is not able to acc...
Data Protection
  • TelmoBarbosa's avatar
    TelmoBarbosa
    2 years ago

    Hi satyamsd21  ,

    You can see in this topic (Re: PBI Report Builder - Paginated Report RLS With... - Microsoft Fabric Community) how I worked around the problem.

     

    Basically, I published the paginated report with a user that does not have access to the server. This way, when a specific user opens the report, there is no impersonation, and the data is filtered based on the user viewing the report (uses RLS defined at AAS level).

     

    Before doing this, I had published the paginated report with my user (admin access), and all the report views were impersonated with my user, ignoring all the RLS definitions.

     

    You can use DAX Studio, for example, through the All Queries option, to check which user is being used when querying the server through a paginated report viewing.

     

    Best regards,
    Telmo Barbosa

TelmoBarbosa's avatar
TelmoBarbosa
Regular Visitor
2 years ago

Hi satyamsd21  ,

You can see in this topic (Re: PBI Report Builder - Paginated Report RLS With... - Microsoft Fabric Community) how I worked around the problem.

 

Basically, I published the paginated report with a user that does not have access to the server. This way, when a specific user opens the report, there is no impersonation, and the data is filtered based on the user viewing the report (uses RLS defined at AAS level).

 

Before doing this, I had published the paginated report with my user (admin access), and all the report views were impersonated with my user, ignoring all the RLS definitions.

 

You can use DAX Studio, for example, through the All Queries option, to check which user is being used when querying the server through a paginated report viewing.

 

Best regards,
Telmo Barbosa