Forum Discussion

fabricpribeiro's avatar
fabricpribeiro
Post Patron
6 days ago

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, during the extraction passing a country parameters and converting to excel (which they append to an e-mail and send via Graph API) 

I don't like the fact that the users receive the information in excel and also, I don't like the fact that currently they are filtering the report per country so that people only see their one things. This seems to me like a custom way of doing RLS.. 

Q2 ) Do you suggest any other approach?

Thanks a lot,

Pedro

 

 

 

 

 

admin
governance

2 Replies

  • trivedisunita's avatar
    trivedisunita
    Continued Contributor
    6 days 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.

     

  • v-kathullac's avatar
    v-kathullac
    Community Support
    2 days ago

    Hi fabricpribeiro​ ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

    Regards,

    Chaithanya