Microsoft Power Query Preview For Excel - September 2013 Release Notes

Microsoft Power Query Preview for Excel September
2013 Release Notes

This Release Notes document contains information about the September 2013
release of Microsoft Power Query Preview for Excel (2.7.3416.121).
The document contains the following sections:
1. Introduction
2. System Requirements
3. Known Issues
1. Introduction
Microsoft Power Query for Excel is a new add-in that provides a seamless experience
for data discovery, data transformation, enrichment and sharing for Information
Workers, BI professionals and other users.
With Power Query you can:
Identify the data you care about from the sources you work with (e.g.
relational databases, Excel, text and XML files, OData feeds, web pages,
Hadoop HDFS, etc.).
Discover relevant data using the search capabilities within Excel.
Combine data from multiple, disparate data sources and shape it in order to
prepare the data for further analysis in tools like Excel and Power Pivot.
Share queries for collaboration with other users within your organization.
2. System requirements
In order to install Power Query, the following system requirements must be
satisfied:
Operating System: The following Operating Systems are supported:

o Windows Vista (requires .NET 3.5 SP1)
o Windows Server 2008 (requires .NET 3.5 SP1)
o Windows Server 2008 R2
o Windows 7
o Windows 8
o Windows 8.1
Microsoft Office: The following Office versions are supported:

o Office 2010 SP1
Office 2013 RTM
Internet Explorer: Internet Explorer 9 or greater is required.
Microsoft Power Query for Excel is available for 32-bit (x86) and 64-bit (x64)
platforms, your selection must match the bit-ness of the installed version of Office.
3. Known Issues
This section includes notes about some of the most commonly hit issues when
trying to use Power Query, such as:
Excel Data Model and Power Pivot interaction:

o Queries will not refresh after a table has been renamed in the Excel
2013 Data Model (via Power Pivot) and modified in Power Query.
o Renaming a query and refreshing (through Power Query) while the
Power Pivot Manage window is open causes a crash in Power Pivot and
Excel.
o For the query which is already loaded to Excel Data Model, modifying
its command text in the Connection properties to some specific SQL
statement will unload it from data model.
o Importing a Power Query query connection into Power Pivot in Excel
2013 using the Existing Connections in Power Pivot will leave Excel
and Power Query processes running when trying to close Excel.
Other issues:
o Query Settings task pane and Query ribbon tab might not show
automatically after enabling connections on a workbook where
connections were disabled.
o Loading a query for the first time fails if any worksheet in the workbook
is protected.
1. Queries will not refresh after the resulting table has been renamed.
Renaming a table in the Data Model (i.e. using Power Pivot or Power View rename
options) will make subsequent refresh attempts fail.
The recommendation is to not rename resulting tables in the worksheet or Data
Model until a fix for these issues is available.
2. Renaming a query and refreshing (through Power Query) while the

Power Pivot Manage window is open causes a crash in Power Pivot and
Excel
When trying to rename a query and refresh it via Power Query, while the Power
Pivot Manage window is open, a crash will happen in Power Pivot and Excel.
As a workaround, users can rename and refresh via Power Query before opening the
Power Pivot Manage window.
3. For the query which is already loaded to Excel Data Model, modifying
its command text in the Connection properties to some specific SQL
statement will unload it from the Data Model.
Once a query has been loaded into the Excel Data Model, if the user modifies its
command text in the Data Connection properties to some specific SQL statement
will unload the query from the Data Model.
It is recommended to not modify the Connection SQL statements for existing Power
Query queries.
4. Importing a Power Query query connection into Power Pivot in Excel

2013 using the Existing Connections in Power Pivot will leave Excel
and Power Query processes running when trying to close Excel.
If the user tries to import a Power Query query into Power Pivot in Excel 2013 using
the Existing Connections functionality in Power Pivot, there will be Excel and
Power Query processes that will keep running in the background when trying to
close Excel.
5. Query Settings task pane and Query ribbon tab might not show
automatically after enabling connections on a workbook where
connections were disabled.
When opening a workbook containing Power Query queries, Excel might disable the
connections as a security mechanism and offer an Enable Content button. After
clicking this button, connections will be successfully enabled but the Query Settings
pane might not show up automatically.
The workaround is to change the currently selected cell after enabling connections.
If this cell belongs to a Power Query query loaded on the sheet, the Query Settings
pane and Query ribbon tab will show at this time.
6. Loading a query for the first time fails if any worksheet in the workbook
is protected.
When trying to load a new query in an Excel workbook, an error will happen if any of
the sheets in the workbook is protected. As a workaround, please check that none of
the existing sheets in the workbook are protected, before adding a new Power
Query query.
If you find any other issues while installing or using Power Query, please do not
hesitate to contact the Power Query UX Feedback alias.

Microsoft Power Query Preview For Excel - September 2013 Release Notes

Uploaded by

Copyright:

Available Formats

Microsoft Power Query Preview For Excel - September 2013 Release Notes

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Microsoft Power Query Preview For Excel - September 2013 Release Notes

Uploaded by

Copyright:

Available Formats

Microsoft Power Query Preview for Excel September

2013 Release Notes

Operating System: The following Operating Systems are supported:

Microsoft Office: The following Office versions are supported:

Office 2013 RTM

Internet Explorer: Internet Explorer 9 or greater is required.

Excel Data Model and Power Pivot interaction:

2. Renaming a query and refreshing (through Power Query) while the

4. Importing a Power Query query connection into Power Pivot in Excel

You might also like