Data Privacy Settings In Power BI-Performance Implications

[Sunkari]

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

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. 

[Anonymous]

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