Forum Discussion

fabricpribeiro's avatar
fabricpribeiro
Icon for Post Patron rankPost Patron
2 months ago
Solved

Paginated Reports

Dears, My team is using paginated reports  Q1) Do they (paginated reports) respect the RLS if its implemented at the semantic layer level? They are also extracting the report , and, in some cases,...
  • trivedisunita's avatar
    2 months ago

    Hi fabricpribeiro​, 

    If the paginated report is connected to a Power BI semantic model that has RLS configured, the RLS rules are applied when users access the report. Users should only see the data they are authorized to view through the semantic model security. Regarding the country parameter, I would view that as a report filter rather than a security mechanism. If the intention is to restrict access by country, it's generally better to enforce that through RLS in the semantic model and use the parameter only for filtering or user convenience. 

    For the export-to-Excel scenario, one consideration is that once data is exported and emailed, it is outside Power BI's security boundaries. If possible, allowing users to access the report directly in the Power BI Service, or using subscriptions that respect dataset security, provides stronger governance and control. So My recommendation would be- 

    1. Use RLS in the Sementic model as the primary security layer.
    2. Use country parameters only as filter, not as security controls
    3. Where practical, have users consume the report in Power BI rather than distributing Excel extracts by email.

    Reference- Set Up Row-Level Security in Power BI Paginated Reports - Power BI | Microsoft Learn

    Power Automate for export report pagined | Microsoft Fabric Community

    Thank you.