Power BI Paginated Report Builder

[satyamsd21]

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 access the same RLS which is already applied on the SSAS.

Questions:
1. Will the RLS be directly pulled by Paginated reports without doing any changes in settings as pbix file? It is assumed that we are using same credentials to access paginated report as we use for pbix file where RLS is seen perfectly applicable. and RLS is already configured at SSAS data source level.
2. If not then how can we setup RLS for independent paginated reports?
3. while importing ssas to paginated reports is there any connection between creating connection string and rls getting implemented or obstructed? like are there any options in advance properties while creating connection string that needed to be manipulated to make rls work?

[Anonymous · Accepted solution]

Hi @satyamsd21 ,

1.RLS in Paginated Reports:
Unfortunately, paginated reports do not directly support Row-Level Security (RLS) as Power BI reports do. RLS is only available on the report server or database side, and it cannot be enabled directly within paginated reports
However, you can embed paginated reports, and when doing so, you have control over which data is displayed. This allows you to tailor the information presented per user
To summarize, RLS won’t be automatically pulled by paginated reports without additional configuration.
2.Setting Up RLS for Independent Paginated Reports:
Since paginated reports don’t inherently support RLS, you’ll need to handle security at the data source level (e.g., SSAS) or within the report server.
Consider implementing RLS directly in your SSAS data source, ensuring that the necessary roles and filters are correctly defined. The paginated report will then inherit these security settings.
3.Connection String and RLS:
While importing SSAS data into paginated reports, the connection string plays a crucial role.
Ensure that the connection string used in your paginated report matches the one used in your Power BI report (where RLS works). Verify credentials, authentication methods, and any other relevant settings.
While creating the connection string, there are no specific advanced properties directly related to RLS. However, consistency between connection settings is essential.

Below is the link will help you:

www.edureka.co

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bradsy · Accepted solution]

https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-rls

[Anonymous · Accepted solution]

Hi @satyamsd21 ,

1.RLS in Paginated Reports:
Unfortunately, paginated reports do not directly support Row-Level Security (RLS) as Power BI reports do. RLS is only available on the report server or database side, and it cannot be enabled directly within paginated reports
However, you can embed paginated reports, and when doing so, you have control over which data is displayed. This allows you to tailor the information presented per user
To summarize, RLS won’t be automatically pulled by paginated reports without additional configuration.
2.Setting Up RLS for Independent Paginated Reports:
Since paginated reports don’t inherently support RLS, you’ll need to handle security at the data source level (e.g., SSAS) or within the report server.
Consider implementing RLS directly in your SSAS data source, ensuring that the necessary roles and filters are correctly defined. The paginated report will then inherit these security settings.
3.Connection String and RLS:
While importing SSAS data into paginated reports, the connection string plays a crucial role.
Ensure that the connection string used in your paginated report matches the one used in your Power BI report (where RLS works). Verify credentials, authentication methods, and any other relevant settings.
While creating the connection string, there are no specific advanced properties directly related to RLS. However, consistency between connection settings is essential.

Below is the link will help you:

www.edureka.co

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.