Loading...

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

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

Excel users, take note: changes are coming to the Get & Transform Data (aka Power Query) features in the program. Starting March 11th, 2024, important changes to the features will be introduced. If you're not using Power Query, you can disregard this message. However, if you are using Power Query, it's important to note that certain capabilities will require the installation of Microsoft Edge WebView2 by March 11th, 2024. To ensure that you're able to use all the features of Get & Transform Data in Excel, it's recommended that you install this library now.

In addition, Microsoft is planning to deprecate the support of TLS (Transport Layer Security) 1.1 or lower in Get & Transform Data (aka Power Query) on all platforms, which may impact your ability to access certain external data sources via Get & Transform Data tools in Excel. To prepare for these changes, it's important to keep your helpdesk and documentation updated, install the Microsoft Edge WebView2 framework, and verify that any external data sources used with Power Query support TLS version 1.2 or higher. For more information, visit the links provided in the message ID MC696575.

This change may complicate things for some users, but with the right preparation and resources, you can ensure that your experience with Excel stays seamless even after these changes take place.

The post Action Required – Changes to Get & Transform Data (aka Power Query) features in Excel appeared first on M365 Admin.

Published on:

Learn more
M365 Admin
M365 Admin

by João Ferreira

Share post:

Related posts

How to Join Data Sources in Tableau in 4 Simple Steps

If you're struggling to join data sources in Tableau, look no further. This tutorial breaks down the process into four simple steps, allowing ...

1 year ago

Excel: Refresh queries from Authenticated Data Sources in Excel for the Web

Excel for the Web has made it possible to refresh Power Query data from authenticated data sources. This means that data sources requiring aut...

1 year ago

What is Power Query: A Step-By-Step Guide for Data Analysis

In the realm of data analysis, performing repetitive tasks in Excel or Power BI can be exhausting. But fear not, because Power Query is here t...

1 year ago

How to Use Power Query in Excel: The Complete Guide

Power Query is an excellent business intelligence tool in Excel that facilitates data import, cleaning, and transformation as per your require...

1 year ago

How to Add Power Query to Excel: A Step-by-Step Guide

Power Query can be a transformative tool for Excel users who want to connect, import, and shape external data. Adding it to Excel is a straigh...

1 year ago

Microsoft Excel: Get

Get ready for some changes in Excel's Get & Transform Data tools! Starting June 1, 2023, additional libraries will be required to continue...

2 years ago

Data Sources in Power BI Workspaces

Organizing data sources in Power BI workspaces is fundamental to building effective workspaces that highlight data flows within your organizat...

2 years ago

Power Query Transform Column Challenge: Stacked Data to Ordered Table

This Power Query transform column guide focuses on transforming stacked data into a tabular format with the information presented in descendin...

2 years ago

Mastering DP-500: Performance Tuning of Power Query and Data Sources

If you're looking to optimize the performance of your Power BI solutions, this article is a must-read. Performance tuning can be a complex and...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy