Set privacy levels (Power Query) (2024)

Important Although a restrictive isolation level blocks information from being exchanged between data sources, it may reduce functionality and impact performance.

1. To display the Data Source Settings dialog box, do one of the following:

   Power Query EditorSelect File > Options and Settings > Data Source Settings.

   ExcelSelect Data> Get Data > Data Source Settings.

2. Select Edit Permissions. The Edit Permissions dialog box appears.

3. Under Privacy Level, select an option from the drop-down list:

   None There are no privacy settings. Be careful setting this option. Make sure that privacy regulations are otherwise maintained. You might use this privacy setting in a controlled development environment for testing and performance reasons.

   PrivateContains sensitive or confidential information, and the visibility of the data source may be restricted to authorized users. It is completely isolated from other data sources. Examples includeFacebook data, a text file containing stock awards, or a workbook containing an employee review.

   See Also

   Warhammer 60K: The Age of DuskDownloaden & Spielen zonemove auf PC(Emulator)GameSir Launches Nova and Nova Lite ControllersAcer's 57-inch Predator Z57 Lands in Retail

   OrganizationalLimits the visibility of a data source to a trusted group of people. Itis isolated from all Public data sources, but is visible to other Organizational data sources. Acommon example is aMicrosoft Word document on an intranet SharePoint site with permissions enabled for a trusted group.

   PublicGives everyone visibility to the data.Only files, internet data sources, or workbook data can be marked Public. Examples includedata from a Wikipedia page, or a local file containing data copied from a public web page.

4. Select OK.

TheFast Combineoptions are workbook settings that determine whether Power Query uses your privacy level settings when combining data. These options are not enabled by default.

Caution:Enabling Fast Combine by selecting Ignore the Privacy levels and potentially improve performance in the Workbook Settings dialog could expose sensitive or confidential data to an unauthorized person. Do not enable Fast Combine unless you are confident that the data source does not contain sensitive or confidential data.

1. To display the Query Options dialog box:

   Power Query EditorSelect File > Options and settings > Query options.

   ExcelSelect Data >Get Data > Query Options​​​​​​.

2. In the left pane, do one of the following:

   GLOBAL Select Privacy, and then set one of the following in the right pane:

   • Always combine data according to your Privacy Level settings for each source

   • Combine data according to each file's Privacy Level settingsPrivacy level settings are used to determine the level of isolation between data sources when combining data. This setting may decrease performance and functionality.Merging data across privacy isolation zones results in some data buffering.

   • Always Ignore the Privacy levels and potentially improve performance Combine by ignoring your Privacy Levelssetting. This setting can improve performance and functionality, but Power Query cannot ensure the privacy of data merged into the workbook.

   CURRENT WORKBOOKSelect Privacy, and then set one of the following in the right pane:

   • Combine data according to your Privacy Level settings for each sourcePrivacy level settings are used to determine the level of isolation between data sources when combining data. This setting may decrease performance and functionality.Merging data across privacy isolation zones results in some data buffering.

     See Also

     Reimagining how the MacBook Touch Bar could work in 2024

   • Ignore the Privacy levels and potentially improve performance Combine by ignoring your Privacy Levelssetting. This setting can improve performance and functionality, but Power Query cannot ensure the privacy of data merged into the workbook.

3. Select OK.