Forum Discussion
Report with Live Connection and RLS Not Reflecting Correct Data for Some Users
- 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!!
Hello Deku ,
I have republished the report with a new link. But, still I have fear that this problem happened again.
I want to know how can we solve this issue once for all.
Hi ddd11 ,
Thank you for reaching out to Microsoft Fabric Community.
Have the user log out of Power BI and log back in. This can refresh their session and force Power BI to reapply the correct RLS roles when they access the report again.
Clear the cache in the user’s browser or have them access the report in InPrivate or Incognito mode.
If the above does not resolve the issue, since your report uses a live connection to the dataset, RLS is evaluated at query time. To avoid issues, try changing it to Import Mode and schedule the refresh as per your requirements.
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!!
- v-sathmakuri1 year agoCommunity Support
Hi ddd11 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you!!