M365 Changelog: Microsoft Excel – Get

MC532199 – Microsoft will be updating Get & Transform Data tools in Excel (aka Power Query).

When this will happen:

Starting June 1, 2023, Get & Transform Data tools in Excel will require additional libraries to be installed to continue working.

How does this affect your organization:

If your tenant has any existing Get & Transform Data (aka Power Query) queries, Power Query will not be accessible after the specified date. Any user who tries to use it after June 1st will receive an error message.

If you don’t use Power Query, you may dismiss this message. 

What you need to do to prepare:

You will need to install:

1. .NET framework v4.7.2 – for Power Query, in general
2. WebView2 framework – for the From Web (Power Query) data connector 

Inform your helpdesk and update documentation as appropriate. 

For additional information, please refer to About Get & Transform (Power Query) in Excel. 

Help and support