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
What the notice says
Microsoft’s text, safely structuredUpdated 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:
What changed
Between archive captures, newest first… Note: If you don’t use Power Query, you may dismiss this message.
When[When this willhappen: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 yourorganization: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 toprepare:prepare:] You will need to: Install Microsoft Edge WebView2 run-time for upcoming Get …- · first version seen
Learn more
Links from the notice and their documentation checks- Microsoft Edge WebView2 | Microsoft Edge Developer
- About Get & Transform (Power Query) in ExcelNot read yet
- Preparing for TLS 1.2 in Office 365 and Office 365 GCC | Microsoft LearnNot read yet
- How to enable Transport Layer Security (TLS) 1.2 on clients - Configuration Manager | Microsoft LearnNot read yet
Related public changes
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.