Public mode

No access to your tenant or devices. Every item links to its source. What this means

Sources need attention Customize Public modeDiscuss ChangeIntel on Discord

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

From Microsoft 365 Message Center Archive by Merill Fernando · Microsoft may not have sent this notice to your tenant.

Action date

10 Mar 2024 981d ago Act by , as Microsoft's metadata states

What the notice says

Microsoft’s text, safely structured

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.

  1. 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.
  2. 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:

  1. Install Microsoft Edge WebView2 run-time for upcoming Get Data features.
  2. 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:

What changed

Between archive captures, newest first
  1. … Note: If you don’t use Power Query, you may dismiss this message. When[When this will happen:happen:] Starting March 11th, 2024, we will be introducing important changes to the Get & Transform Data (aka Power Query) features in Excel. How[How does this affect your organization:organization:] Any user who tries to use Power Query after March 11th, 2024, … the relevant data source via Get & Transform Data tools in Excel. What[What you need to do to prepare:prepare:] You will need to:  Install Microsoft Edge WebView2 run-time for upcoming Get …

  2. · first version seen

Learn more

Links from the notice and their documentation checks

No related announcements were found in the saved public history. Check the source for newer announcements.

Not confirmed here

What this page cannot tell you
  • Whether your tenant is affected: this is Microsoft's notice, not a check of your settings.
  • 3 linked pages have not been read yet.
ChangeIntel

An IT change radar: releases, security, known issues, retirements, documentation changes, and service status from public sources. Every item links to supporting evidence; dates and statuses can change after they are read.

Sources read 16 Nov 01:32 UTC · 272 of 275 readable · 250 fully read · 18 waiting for GitHub's hourly limit · documentation 469/469 current