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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
satyamsd21
New Member

Re: Power BI Paginated Report Builder

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?

2 ACCEPTED SOLUTIONS
v-xiandat-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-xiandat-msft
Community Support
Community Support

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors