Privacy levels

I want to


Privacy levels specify an isolation level that defines the degree that one data source will be isolated from other data sources. Although a restrictive isolation level blocks information from being exchanged between data sources, it may reduce functionality and impact performance. The Fast Combine setting determines if Power Query uses your Privacy Level settings while combining data. The Privacy Levels dialog box provides an informative message about the implications of selecting data source privacy levels. This includes a link to Power Query Online Help about Privacy Levels and Fast Combine.

Privacy Levels

 Caution    You should configure a data source containing highly sensitive or confidential data as Private.

Configure a privacy level

With privacy level settings, you can specify an isolation level that defines the degree that one data source must be isolated from other data sources.

Setting Description Example Data Sources
Private data source A Private data source contains sensitive or confidential information, and the visibility of the data source may be restricted to authorized users. A private data source is completely isolated from other data sources. Facebook data, a text file containing stock awards, or a workbook containing employee review information.
Organizational data source

An Organizational data source limits the visibility of a data source to a trusted group of people. An Organizational data source is isolated from all Public data sources, but is visible to other Organizational data sources.

A Microsoft Word document on an intranet SharePoint site with permissions enabled for a trusted group.
Public data source A Public data source gives everyone visibility to the data contained in the data source. Only files, internet data sources or workbook data can be marked Public. Free data from the Microsoft Azure Marketplace, data from a Wikipedia page, or a local file containing data copied from a public web page

Configure privacy level settings

  1. When prompted with the Select Privacy Level For Data Sources dialog box, click Public, Organizational or Private according to the nature of the specific data source. For more information, see How to configure a privacy level.
  2. Click Save.

Top of Page Top of Page

Configure Fast Combine

Fast Combine is a workbook setting that is Off by default.

Setting Description
Off (default) Privacy level settings are used to determine the level of isolation between data sources when combining data.

On

Privacy levels are not considered when combining data, however; performance and functionality of the data may increase.

Security   Setting Fast Combine to On could expose sensitive or confidential data to an unauthorized person. Do not set Fast Combine to On unless you are confident that the data source does not contain sensitive or confidential data.

Configure Fast Combine

  1. In the POWER QUERY ribbon tab, click Fast Combine.
  1. When Fast Combine is not selected, data will be combined according to your Privacy Levels setting. Merging data across Privacy isolation zones will result in some data buffering.
  2. When Fast Combine is selected, the data will be combined ignoring your Privacy Levels that could reveal sensitive or confidential data to an unauthorized user. The setting may improve performance and functionality.

Security   Disabling Fast Combine may improve performance; however, Power Query cannot ensure the privacy of data merged into this workbook.

Top of Page Top of Page

 
 
Applies to:
Excel 2013, Excel 2010