MC696575 - Action Required - Changes to Get & Transform Data (aka Power Query) features in Excel

Updated December 11, 2023: We have updated the content below to show as intended. Thank you for your feedback.

We will be making changes to Get & Transform Data (aka Power Query) features in Excel.

Note: If you donâ€™t use Power Query, you may dismiss this message.

When this will happen:

Starting March 11th, 2024, we will be introducing important changes to the Get & Transform Data (aka Power Query) features in Excel.

How does this affect your organization:

Any user who tries to use Power Query after March 11th, 2024, and falls under one of the scenarios, below, will receive a relevant error message.

As we are modernizing the Get & Transform Data (aka Power Query) experience in Excel for Windows, some of the Get & Transform Data capabilities will require Microsoft Edge WebView2 (Microsoft Edge WebView2 | Microsoft Edge Developer) to be installed on the client machine. In the future, all the Get & Transform Data features in Excel for Windows will require Microsoft Edge WebView2 hence we recommend installing this library now.
In addition, and to provide the best-in-class encryption to our customers, we are planning to deprecate the support of TLS (Transport Layer Security) 1.1 or lower in Get & Transform Data (aka Power Query) on all platforms. If a certain external data source a user tries to connect to only supports TLS version 1.1 or lower, they will not be able to access the relevant data source via Get & Transform Data tools in Excel.

What you need to do to prepare:

You will need to:

Install Microsoft Edge WebView2 run-time for upcoming Get Data features.
Ensure all of the external data sources you use with Power Query support TLS version 1.2 or higher - for Power Query, in general.

Please Inform your helpdesk and update documentation as appropriate.

For additional information, please refer to: