Part V: Understanding Power Pivot and Power Query
add-in providers to be sure that they are 64-bit compatible. This includes add-ins
for all Office products, not just Excel. When you upgrade Excel to 64-bit, you’ll have
to upgrade the entire Office suite with it.
Disabling privacy settings to improve performance
The privacy-level settings in Power Query are designed to protect organizational data as
it gets combined with other sources. When you create a query that uses an external data
source with an internal data source, Power Query stops the show to ask how you’d like to
categorize the data privacy levels of each data source.
For a majority of analysts who deal solely with organizational data, the privacy level set-
tings do little more than slow down queries and cause confusion. Fortunately, there is an
option for ignoring privacy levels.
Click Data ➪ Get Data ➪ Query Options to open the dialog box shown in Figure 41.10. Select
Privacy under Current Workbook and then choose the option to ignore privacy levels.
FIGURE 41.10
Disabling the privacy level settings
Disabling relationship detection
When building a query and choosing Load to Data Model as the output, Power Query will,
by default, attempt to detect relationships between queries and create those relationships
within the internal data model. The relationships between queries are primarily driven by
the defined query steps. For instance, if you were to merge two queries and then load the
result into the data model, a relationship is automatically created.
