data sets cache with security roles

[rpeleg]

Hi eb

Should the addition of security Roles (filterring specific rows to specific users), prevent early caching of visualization data (prior to users request) based on the same data set? Or the power bi service cache includes data of all users.

Filterring vizualization per username() is done later on demand of visualization by some user (at that point specific caching per user occures)?

I am referring to early caching of vizualizations as described here

Thanks a bunch!

Rea

[v-juanli-msft]

Hi @rpeleg

If i understand you right, RLS may not prevent early caching of visualization data.

When the owner of the dataset configure RLS for users in this dataset, changes of the dataset which users can view would come with the refresh happen.

According to this link, It says "If there is no user interaction in a visualization, data is refreshed automatically approximately every hour. You can change that refresh frequency using the Scheduled cache refresh option, and set the refresh frequency."

The refresh mentioned above is for the dataset, not the visuals on the report. the refresh only change the data displaying in in the visuals instead the types or items of the visuals.

Best Regards

Maggie

[rpeleg · Accepted solution]

Thanks Maggie

It seems like there is a distinction between data sets FREE of Role level security (RLS) -  where caching is supported for visualizations

- and then RLS datasets where such caching is NOT supported (probably because the visualization cache mechanism does not cache row level data but rather a summary only needed for final visualization).

Read through section 'User authentication to data sources' in the Power BI Security whitepaper (download from the link over there).