Forum Discussion

rpeleg's avatar
rpeleg
Frequent Visitor
7 years ago
Solved

data sets cache with security roles

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

 

Need Help
  • rpeleg's avatar
    rpeleg
    7 years ago

    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).

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      rpeleg
      Frequent Visitor
      7 years ago

      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).