{"id":4314,"date":"2023-12-08T09:01:46","date_gmt":"2023-12-08T00:01:46","guid":{"rendered":"https:\/\/m365jp.xyz\/?p=4314"},"modified":"2023-12-08T09:05:06","modified_gmt":"2023-12-08T00:05:06","slug":"mc696575-action-required-changes-to-get-transform-data-aka-power-query-features-in-excel","status":"publish","type":"post","link":"https:\/\/m365jp.net\/index.php\/2023-12-08-mc696575-action-required-changes-to-get-transform-data-aka-power-query-features-in-excel","title":{"rendered":"MC696575 | Action Required – Changes to Get & Transform Data (aka Power Query) features in Excel"},"content":{"rendered":"
\n
\n
\n\n\n\n
MC696575 | Action Required – Changes to Get & Transform Data (aka Power Query) features in Excel<\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n\n\n\n\n\n\n\n\n\n
Classification<\/th>\nplanForChange<\/td>\n<\/tr>\n
Last Updated<\/th>\n12\/07\/2023 23:33:00<\/td>\n<\/tr>\n
Start Time<\/th>\n12\/07\/2023 23:32:15<\/td>\n<\/tr>\n
End Time<\/th>\n04\/15\/2024 07:00:00<\/td>\n<\/tr>\n
Action Required By Date<\/th>\n2024-03-10T08:00:00Z<\/td>\n<\/tr>\n
Message Content<\/th>\n\n

We will be making changes to Get & Transform Data (aka Power Query) features in Excel.<\/p>\n

Note: <\/b>If you don\u2019t use Power Query, you may dismiss this message.<\/p>\n

[When this will happen:] <\/p>\n

Starting March 11th, 2024,<\/i> we will be introducing important changes to the Get & Transform Data (aka Power Query) features in Excel.<\/p>\n

[How does this affect your organization:] <\/p>\n

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.<\/p>\n

    \n
  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<\/i> (Microsoft Edge WebView2 | Microsoft Edge Developer<\/a>) 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. <\/li>\n
  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<\/i> 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,<\/i> they will not be able to access the relevant data source via Get & Transform Data tools in Excel.<\/li>\n<\/ol>\n

    [What you need to do to prepare:] <\/p>\n

    You will need to: <\/p>\n

      \n
    1.  Install Microsoft Edge WebView2 framework<\/i> – for upcoming Get Data features. <\/li>\n
    2.  Ensure all of the external data sources<\/i> you use with Power Query support TLS version 1.2 or higher <\/i>– for Power Query, in general.<\/li>\n<\/ol>\n

      Please Inform your helpdesk and update documentation as appropriate. <\/p>\n

      For additional information, please refer to: <\/p>\n

Machine Translation<\/th>\n\n

Excel \u306e [\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db] (\u5225\u540d Power Query) \u6a5f\u80fd\u306b\u5909\u66f4\u3092\u52a0\u3048\u307e\u3059\u3002<\/p>\n

\u624b\u8a18\uff1a <\/b>Power Query \u3092\u4f7f\u7528\u3057\u306a\u3044\u5834\u5408\u306f\u3001\u3053\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9589\u3058\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n

[\u3053\u308c\u304c\u3044\u3064\u8d77\u3053\u308b\u304b:] <\/p>\n

2024 \u5e74 3 \u6708 11 \u65e5\u3088\u308a\u3001<\/i>Excel \u306e\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db (\u5225\u540d Power Query) \u6a5f\u80fd\u306b\u91cd\u8981\u306a\u5909\u66f4\u304c\u5c0e\u5165\u3055\u308c\u307e\u3059\u3002<\/p>\n

[\u3053\u308c\u306f\u7d44\u7e54\u306b\u3069\u306e\u3088\u3046\u306a\u5f71\u97ff\u3092\u4e0e\u3048\u307e\u3059\u304b:]<\/p>\n

2024 \u5e74 3 \u6708 11 \u65e5\u4ee5\u964d\u306b Power Query \u3092\u4f7f\u7528\u3057\u3088\u3046\u3068\u3057\u3066\u3001\u4ee5\u4e0b\u306e\u3044\u305a\u308c\u304b\u306e\u30b7\u30ca\u30ea\u30aa\u306b\u8a72\u5f53\u3059\u308b\u30e6\u30fc\u30b6\u30fc\u306b\u306f\u3001\u95a2\u9023\u3059\u308b\u30a8\u30e9\u30fc \u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n

    \n
  1.  Excel for Windows \u3067\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db (Power Query) \u30a8\u30af\u30b9\u30da\u30ea\u30a8\u30f3\u30b9\u3092\u6700\u65b0\u5316\u3057\u3066\u3044\u308b\u305f\u3081\u3001\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db\u6a5f\u80fd\u306e\u4e00\u90e8\u306b\u306f Microsoft Edge WebView2 ( Microsoft Edge WebView2<\/i> |Microsoft Edge Developer<\/a>) \u3092\u30af\u30e9\u30a4\u30a2\u30f3\u30c8 \u30b3\u30f3\u30d4\u30e5\u30fc\u30bf\u30fc\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002\u4eca\u5f8c\u3001Excel for Windows \u306e\u3059\u3079\u3066\u306e [\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db] \u6a5f\u80fd\u306b\u306f Microsoft Edge WebView2 \u304c\u5fc5\u8981\u306b\u306a\u308b\u305f\u3081\u3001\u3053\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u4eca\u3059\u3050\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u3053\u3068\u3092\u304a\u52e7\u3081\u3057\u307e\u3059\u3002<\/li>\n
  2.  \u3055\u3089\u306b\u3001\u30af\u30e9\u30b9\u6700\u9ad8\u306e\u6697\u53f7\u5316\u3092\u304a\u5ba2\u69d8\u306b\u63d0\u4f9b\u3059\u308b\u305f\u3081\u306b\u3001\u3059\u3079\u3066\u306e\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3067\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db (\u5225\u540d Power Query) \u3067\u306e TLS (Transport Layer Security) 1.1<\/i> \u4ee5\u4e0b\u306e\u30b5\u30dd\u30fc\u30c8\u3092\u5ec3\u6b62\u3059\u308b\u4e88\u5b9a\u3067\u3059\u3002\u30e6\u30fc\u30b6\u30fc\u304c\u63a5\u7d9a\u3057\u3088\u3046\u3068\u3059\u308b\u7279\u5b9a\u306e\u5916\u90e8\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u304c TLS \u30d0\u30fc\u30b8\u30e7\u30f3 1.1 \u4ee5\u4e0b\u306e\u307f\u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\u5834\u5408\u3001<\/i> Excel \u306e [\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u3068\u5909\u63db] \u30c4\u30fc\u30eb\u3092\u4f7f\u7528\u3057\u3066\u95a2\u9023\u3059\u308b\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002<\/li>\n<\/ol>\n

    [\u6e96\u5099\u306b\u5fc5\u8981\u306a\u3053\u3068:]<\/p>\n

    \u6b21\u306e\u3053\u3068\u3092\u884c\u3046\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

      \n
    1.  Microsoft Edge WebView2 \u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b<\/i> – \u4eca\u5f8c\u306e [\u30c7\u30fc\u30bf\u306e\u53d6\u5f97] \u6a5f\u80fd\u7528\u3002<\/li>\n
    2.  Power Query \u3067\u4f7f\u7528\u3059\u308b\u3059\u3079\u3066\u306e \u5916\u90e8\u30c7\u30fc\u30bf \u30bd\u30fc\u30b9<\/i> \u304c\u3001 TLS \u30d0\u30fc\u30b8\u30e7\u30f3 1.2 \u4ee5\u964d <\/i>(\u4e00\u822c\u306b Power Query \u306e\u5834\u5408) \u3092\u30b5\u30dd\u30fc\u30c8\u3057\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/li>\n<\/ol>\n

      \u30d8\u30eb\u30d7\u30c7\u30b9\u30af\u306b\u901a\u77e5\u3057\u3001\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u66f4\u65b0\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

      \u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n