Forum Discussion

Sunkari's avatar
Sunkari
Responsive Resident
9 years ago

Data Privacy Settings In Power BI-Performance Implications

Hi All,

In the following link, CHRIS WEBB wrote a nice post about data privacy settings and it's performance implications in Power BI.

 

https://blog.crossjoin.co.uk/2017/05/24/data-privacy-settings-in-power-bipower-query-part-1-performance-implications/?blogsub=confirming#blog_subscription-3

 

The article was very nice but I am not convinced with data security usage and what real-time problems it's going to solve.

 

If anybody used data privacy settings, please provide your inputs here. 

 

 

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Sunkari,

     

    Based on document, if you ignore the data privacy, it may increase the performance and functionality of data.

     

    Configure Privacy Levels

    Privacy Levels is a setting that is set to Combine data according to your Privacy Level settings for each source by default, which means that Privacy Levels is not enabled.

    Setting Description
    Combine data according to your Privacy Level settings for each source (on, and the default setting) Privacy level settings are used to determine the level of isolation between data sources when combining data.
    Ignore the Privacy levels and potentially improve performance (off) Privacy levels are not considered when combining data, however; performance and functionality of the data may increase.

     

    For detail information, you can take a look at below article:

    Power BI Desktop privacy levels

     

    Regards,

    Xiaoxin Sheng