{"id":11862,"date":"2025-06-13T09:01:23","date_gmt":"2025-06-13T00:01:23","guid":{"rendered":"https:\/\/m365jp.net\/?p=11862"},"modified":"2025-06-13T09:02:24","modified_gmt":"2025-06-13T00:02:24","slug":"mc1093233-important-update-token-protection-policy-for-power-query-in-excel","status":"publish","type":"post","link":"https:\/\/m365jp.net\/index.php\/2025-06-13-mc1093233-important-update-token-protection-policy-for-power-query-in-excel","title":{"rendered":"MC1093233 | Important Update: Token Protection Policy for Power Query in Excel"},"content":{"rendered":"<div class=\"postie-post\">\n<div>\n<hr>\n<table id=\"section\">\n<tbody>\n<tr>\n<th width=\"95%\">MC1093233 | Important Update: Token Protection Policy for Power Query in Excel<\/th>\n<\/tr>\n<\/tbody>\n<\/table>\n<hr>\n<table id=\"data\">\n<tbody>\n<tr>\n<th>Classification<\/th>\n<td>stayInformed<\/td>\n<\/tr>\n<tr>\n<th>Last Updated<\/th>\n<td>06\/12\/2025 23:10:35<\/td>\n<\/tr>\n<tr>\n<th>Start Time<\/th>\n<td>06\/12\/2025 23:10:29<\/td>\n<\/tr>\n<tr>\n<th>End Time<\/th>\n<td>08\/31\/2025 07:00:00<\/td>\n<\/tr>\n<tr>\n<th>Message Content<\/th>\n<td>\n<p>As part of the Microsoft Entra Conditional Access <a href=\"https:\/\/learn.microsoft.com\/entra\/identity\/conditional-access\/concept-token-protection#known-limitations\" target=\"_blank\">  Token Protection<\/a> feature rollout, we&#8217;re notifying you of potential impacts to Power Query in Excel. This feature enhances token security but may block certain data import scenarios in Excel when applied.<\/p>\n<p>[When this will happen:]<\/p>\n<p>This feature is currently available in Public Preview, as outlined in the <a href=\"https:\/\/www.microsoft.com\/licensing\/terms\/product\/ForOnlineServices\/all\" target=\"_blank\">  Microsoft Product Terms<\/a>.  <\/p>\n<p>[How this affects your organization:]<\/p>\n<p>When Conditional Access Token Protection is applied to a user, Power Query in Excel will block data import or refresh operations from sources that require Azure Active Directory (AAD) authentication. This includes, but is not limited to:  <\/p>\n<ul>\n<li>SharePoint  <\/li>\n<li>Microsoft Exchange  <\/li>\n<li>Other AAD-authenticated sources, depending on the broker configuration  <\/li>\n<\/ul>\n<p>This may affect users who rely on Power Query to connect to organizational data sources.  <\/p>\n<p>[What you can do to prepare:]<\/p>\n<p>Review your Conditional Access policies before enabling Token Protection for users who depend on Power Query in Excel.  <\/p>\n<p>Inform your helpdesk and update internal documentation to reflect these changes.  <\/p>\n<p>For more information, refer to:  <\/p>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/entra\/identity\/conditional-access\/concept-token-protection#known-limitations\" target=\"_blank\">Microsoft Entra Conditional Access: Token protection (Preview)<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/office\/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a#ID0EBH=Newer_versions\" target=\"_blank\">Import data from data sources (Power Query) &#8211; Microsoft Support<\/a><\/li>\n<\/ul>\n<p>[Compliance considerations:]<\/p>\n<ul>\n<li>Does the change alter how existing customer data is processed, stored, or accessed? Yes<\/li>\n<li>Does the change modify, interrupt, or disable any of the following capabilities (Purview)? Maybe C depending on how Power Query is used in conjunction with DLP or Information Protection policies  <\/li>\n<\/ul>\n<p>  <\/p>\n<\/td>\n<\/tr>\n<tr>\n<th>Machine Translation<\/th>\n<td>\n<p>Microsoft Entra \u6761\u4ef6\u4ed8\u304d\u30a2\u30af\u30bb\u30b9 <a href=\"https:\/\/learn.microsoft.com\/entra\/identity\/conditional-access\/concept-token-protection#known-limitations\" target=\"_blank\">  \u30c8`\u30af\u30f3\u4fddo<\/a> C\u80fd\u306e\u30ed`\u30eb\u30a2\u30a6\u30c8\u306e\u4e00h\u3068\u3057\u3066\u3001Excel \u306e Power Query \u306b\u6f5c\u5728\u7684\u306a\u5f71\u304c\u53ca\u3076\u53ef\u80fd\u6027\u304c\u3042\u308b\u3053\u3068\u3092\u304a\u77e5\u3089\u305b\u3057\u307e\u3059\u3002\u3053\u306eC\u80fd\u306f\u30c8`\u30af\u30f3\u306e\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3\u3092\u5316\u3057\u307e\u3059\u304c\u3001m\u7528\u3059\u308b\u3068 Excel \u306e\u7279\u5b9a\u306e\u30c7`\u30bf \u30a4\u30f3\u30dd`\u30c8 \u30b7\u30ca\u30ea\u30aa\u304c\u30d6\u30ed\u30c3\u30af\u3055\u308c\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>[\u3053\u308c\u304c\u3044\u3064\u8d77\u3053\u308b\u304b:]<\/p>\n<p>\u3053\u306eC\u80fd\u306f\u3001 <a href=\"https:\/\/www.microsoft.com\/licensing\/terms\/product\/ForOnlineServices\/all\" target=\"_blank\">  Microsoft u\u54c1\u6761<\/a>\u306bd\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u306b\u3001F\u5728\u30d1\u30d6\u30ea\u30c3\u30af \u30d7\u30ec\u30d3\u30e5`\u3067\u5229\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n<p>[\u3053\u308c\u304c\u3042\u306a\u305f\u306eM\u306b\u4e0e\u3048\u308b\u5f71:]<\/p>\n<p>\u6761\u4ef6\u4ed8\u304d\u30a2\u30af\u30bb\u30b9 \u30c8`\u30af\u30f3\u4fddo\u304c\u30e6`\u30b6`\u306bm\u7528\u3055\u308c\u308b\u3068\u3001Excel \u306e Power Query \u306f\u3001Azure Active Directory (AAD) J^\u3092\u5fc5\u8981\u3068\u3059\u308b\u30bd`\u30b9\u304b\u3089\u306e\u30c7`\u30bf\u306e\u30a4\u30f3\u30dd`\u30c8\u307e\u305f\u306f\u66f4\u65b0\u64cd\u4f5c\u3092\u30d6\u30ed\u30c3\u30af\u3057\u307e\u3059\u3002\u3053\u308c\u306b\u306f\u4ee5\u4e0b\u304c\u542b\u307e\u308c\u307e\u3059\u304c\u3001\u3053\u308c\u3089\u306b\u9650\u5b9a\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n<ul>\n<li>SharePoint\u306e<\/li>\n<li>\u30de\u30a4\u30af\u30ed\u30bd\u30d5\u30c8\u30a8\u30af\u30b9\u30c1\u30a7\u30f3\u30b8<\/li>\n<li>\u30d6\u30ed`\u30ab`\u306e\u6210\u306b\u3058\u305f\u305d\u306e\u4ed6\u306e AAD J^\u30bd`\u30b9<\/li>\n<\/ul>\n<p>\u3053\u308c\u306f\u3001Power Query \u3092\u4f7f\u7528\u3057\u3066M\u306e\u30c7`\u30bf \u30bd`\u30b9\u306b\u63a5A\u3059\u308b\u30e6`\u30b6`\u306b\u5f71\u3092\u4e0e\u3048\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n<p>\u3010\u6d43\u5de5\u6bea\u90e1\u5e5b\u6454\u6266\u6bea\u957f:\u3011<\/p>\n<p>Excel \u3067 Power Query \u306b\u4f9d\u5b58\u3059\u308b\u30e6`\u30b6`\u306b\u3057\u3066\u30c8`\u30af\u30f3\u4fddo\u3092\u6709\u90e1\u6454\u5de5\u80ad\u6328\u6055\u247b\u8deb\u9489\u4e92 \u30dd\u30ea\u30b7`\u3092_J\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u30d8\u30eb\u30d7\u30c7\u30b9\u30af\u306b\u901a\u77e5\u3057\u3001\u3053\u308c\u3089\u306e\u6d93\u868d\u4ece\u957f\u5de5\u6bea\u745c\u0394\u56db\u8bd3\u9a8f\u4e27\u6fc2\u5e5e\u8797\u8da3\u868b\u9647\u7b4f\u76ae\u5764\u4e39\u3041<\/p>\n<p>\u306b\u3064\u3044\u3066\u306f\u3001\u4ee5\u4e0b\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<ul>\n<li><a href=\"https:\/\/learn.microsoft.com\/entra\/identity\/conditional-access\/concept-token-protection#known-limitations\" target=\"_blank\">Microsoft Entra \u6761\u4ef6\u4ed8\u304d\u30a2\u30af\u30bb\u30b9: \u30c8`\u30af\u30f3\u4fddo (\u30d7\u30ec\u30d3\u30e5`)<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/office\/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a#ID0EBH=Newer_versions\" target=\"_blank\">\u30c7`\u30bf \u30bd`\u30b9\u304b\u3089\u30c7`\u30bf\u3092\u30a4\u30f3\u30dd`\u30c8\u3059\u308b (Power Query) &#8211; Microsoft \u30b5\u30dd`\u30c8<\/a><\/li>\n<\/ul>\n<p>[\u30b3\u30f3\u30d7\u30e9\u30a4\u30a2\u30f3\u30b9\u306bv\u3059\u308b\u8003]\u4e8b:]<\/p>\n<ul>\n<li>\u3053\u306e\u6d93\u6454\u745c\u8f8d\u2493\u5374\u599e\u6664\u5ba2\u30c7`\u30bf\u306eI\u7406\u3001\u4fdd\u5b58\u3001\u307e\u305f\u306f\u30a2\u30af\u30bb\u30b9\u306e\u65b9\u6cd5\u304c\u6d43\u94ef\u8f98\u84fc\u5de5?\u306f\u3044<\/li>\n<li>\u3053\u306e\u6d93\u6454\u745c\u8f8d\u248b\u97e6C\u80fd (Purview) \u306e\u3044\u305a\u308c\u304b\u304c\u6d93\u2485\u5378\u7a00\u84fc\u90e1o\u90e1\u6454\u80dc\u8f98\u84fc\u5de5?\u305f\u3076\u3093 &#8211; Power Query \u3092 DLP \u307e\u305f\u306f\u60c5\u87ca\uff37o\u30dd\u30ea\u30b7`\u3068M\u307f\u5408\u308f\u305b\u3066\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u306b\u3088\u3063\u3066\u306a\u308a\u307e\u3059<\/li>\n<\/ul>\n<p>  <\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MC1093233 | Important Update: Token Protection Policy for Power Query in Excel Classification stayInformed Las [&hellip;]<\/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-11862","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/11862","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=11862"}],"version-history":[{"count":0,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/posts\/11862\/revisions"}],"wp:attachment":[{"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/media?parent=11862"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/categories?post=11862"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365jp.net\/index.php\/wp-json\/wp\/v2\/tags?post=11862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}