{"id":834,"date":"2023-03-24T09:00:47","date_gmt":"2023-03-24T00:00:47","guid":{"rendered":"https:\/\/m365jp.xyz\/?p=834"},"modified":"2023-03-24T09:00:54","modified_gmt":"2023-03-24T00:00:54","slug":"mc532199-microsoft-excel-get","status":"publish","type":"post","link":"https:\/\/m365jp.net\/index.php\/2023-03-24-mc532199-microsoft-excel-get","title":{"rendered":"MC532199 | Microsoft Excel: Get"},"content":{"rendered":"
\n
\n
\n\n\n\n
MC532199 | Microsoft Excel: Get<\/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>\n03\/23\/2023 23:29:03<\/td>\n<\/tr>\n
Start Time<\/th>\n03\/23\/2023 23:28:54<\/td>\n<\/tr>\n
End Time<\/th>\n08\/31\/2023 07:00:00<\/td>\n<\/tr>\n
Action Required By Date<\/th>\n2023-05-31T07:00:00Z<\/td>\n<\/tr>\n
Message Content<\/th>\n\n

We will be updating Get & Transform Data tools in Excel (aka Power Query).<\/p>\n

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

Starting June 1, 2023, Get & Transform Data tools in Excel will require additional libraries to be installed to continue working.<\/p>\n

<\/p>\n

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

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

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

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

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

    \n
  1. .NET framework v4.7.2 – for Power Query, in general <\/li>\n
  2. WebView2 framework – for the From Web (Power Query) data connector <\/li>\n<\/ol>\n

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

    For additional information, please refer to About Get & Transform (Power Query) in Excel<\/a>. <\/p>\n<\/td>\n<\/tr>\n

Machine Translation<\/th>\n\n

Excel \u306e Get & Transform Data Tools (\u5225\u540d Power Query) \u3092\u66f4\u65b0\u3059\u308b\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n

[\u3053\u308c\u304c\u8d77\u3053\u308b\u3068\u304d:]<\/p>\n

2023 \u5e74 6 \u6708 1 \u65e5\u4ee5\u964d\u3001Excel \u306e Get & Transform Data \u30c4\u30fc\u30eb\u3067\u306f\u3001\u52d5\u4f5c\u3092\u7d99\u7d9a\u3059\u308b\u305f\u3081\u306b\u8ffd\u52a0\u306e\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

<\/p>\n

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

\u30c6\u30ca\u30f3\u30c8\u306b\u65e2\u5b58\u306e Get & Transform Data (\u5225\u540d Power Query) \u30af\u30a8\u30ea\u304c\u3042\u308b\u5834\u5408\u3001\u6307\u5b9a\u3057\u305f\u65e5\u4ed8\u4ee5\u964d\u306f Power Query \u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u304f\u306a\u308a\u307e\u3059\u30026\u67081\u65e5\u4ee5\u964d\u306b\u4f7f\u7528\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001\u30a8\u30e9\u30fc\u30e1\u30c3\u30bb\u30fc\u30b8\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002 <\/p>\n

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

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

\u4ee5\u4e0b\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002 <\/p>\n

    \n
  1. .NET Framework v4.7.2 – Power Query \u5168\u822c <\/li>\n
  2. WebView2 \u30d5\u30ec\u30fc\u30e0\u30ef\u30fc\u30af – From Web (Power Query) \u30c7\u30fc\u30bf \u30b3\u30cd\u30af\u30bf \u7528<\/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\u307e\u3059\u3002  <\/p>\n

    \u8a73\u7d30\u306b\u3064\u3044\u3066\u306f\u3001\u300c Excel \u306e Get & Transform (Power Query) \u306b\u3064\u3044\u3066<\/a>\u300d\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002 <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    MC532199 | Microsoft Excel: Get Classification planForChange Last Updated 03\/23\/2023 23:29:03 Start Time 03\/23 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-834","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/comments?post=834"}],"version-history":[{"count":0,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/834\/revisions"}],"wp:attachment":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/media?parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/categories?post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/tags?post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}