Applying RLS in a paginated report (Report builder)

Hi DataVitalizer ,

1、When you connect to Power BI dataset from PowerBI Desktop/report builder, the connection mode is set as live connection which means you can't do any modification on the data model(e.g.: table relationship) so you can't see the relationship.

2、Please refer to the following document about applying RLS in paginated report to see if it helps you.

https://docs.microsoft.com/en-us/power-bi/developer/embedded/paginated-reports-row-level-security

3、Please refer to the following document about paginated reports with graphs .

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/charts-report-builder-and-ssrs?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-a-chart-to-a-report-report-builder-and-ssrs?view=sql-server-ver15

Best Regards

Community Support Team _ Polly

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