Conflict between RLS and Data Refresh

[Anonymous]

Hi all ,

We'd like to use RLS to secure data and give our users the opportunity to refresh data on demand. 

How can we use RLS (what needs workspace access-level "Viewer") and give the opportunity to refresh dataset? As we know, refreshing data needs higher access-level than Viewer.  

Thank you in advance!

[Anonymous · Accepted solution]

@Anonymous 

You are right. Viewers cannot see the datasets in the workspace so they do not have "refresh now" feature, because it is infeasible to allowed Viewers to manage or edit the content in the workspace.

As the workaround, Power bi allows members admins or owners set up a schedule refresh that can consistently refresh the dataset, so viewer can alwasys see the latest updates. In addition, if the the source is from onedrive or sharepoint, onedrive refresh is automatically applys that refreshes the dataset every hour.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Anonymous 

You do not need high access role to fresh the dataset, viewers can still munual click the refresh button on the report page. The limitation is Viewers cannot Schedule data refreshes via the on-premises gateway. Please refer to the Roles in workspace.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The refresh button at the top of reports just refreshs the report-view if the dataset was already refreshed. But it doesn't refresh the dataset itself.  

[amitchandak]

@Anonymous , see if these can help

RLS - Row Level security
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi