Forum Discussion

ddd11's avatar
ddd11
Frequent Visitor
1 year ago
Solved

Report with Live Connection and RLS Not Reflecting Correct Data for Some Users

Description: We have a Power BI report published in Workspace A that uses a live connection to a dataset in another workspace called "Master Database". This dataset has Row-Level Security (RLS) impl...
  • v-sathmakuri's avatar
    1 year ago

    Hi ddd11 ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    You can try using the Rebind Report API, which allows you to rebind the existing report without changing its report ID or link to the same dataset. This action forces Power BI to refresh the report’s internal metadata, including Row-Level Security (RLS) role evaluations and identity bindings.
    For more details, refer to the official documentation: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/rebind-report )

     

    sample call:

    POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/Rebind
    Content-Type: application/json

    {
    "datasetId": "your-dataset-id"
    }

     

    Additionally, although reports with live connections don't typically require dataset refreshes, you may try triggering a dataset refresh from the source workspace. In some cases, this can help clear cached role assignments or identity tokens that may be impacting RLS behavior.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!