{"id":169991,"date":"2015-09-10T09:00:40","date_gmt":"2015-09-10T16:00:40","guid":{"rendered":"http:\/\/www.microsoft.com\/?p=169991"},"modified":"2024-08-30T13:49:19","modified_gmt":"2024-08-30T20:49:19","slug":"integrating-power-query-technology-in-excel-2016","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/","title":{"rendered":"Integrating Power Query technology in Excel 2016"},"content":{"rendered":"<p>Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We are excited to let you know that your get-data experience in Excel is about to change forever. In <a href=\"https:\/\/products.office.com\/en-us\/excel\">Excel 2016<\/a> we have integrated Power Query technology into the <strong>Data<\/strong> ribbon under the <strong>Get &amp; Transform<\/strong> section. Power Query technology enhances the self-service business analytics\u00a0experience in Excel by simplifying data discovery, access and collaboration.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-170091\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png\" alt=\"Picture1\" width=\"640\" height=\"401\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png 1024w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-300x188.png 300w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-768x482.png 768w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1.png 1244w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p>Prior to the release of Excel 2016, Microsoft Power Query for Excel functioned as an Excel add-in that was downloaded and installed on <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noopener\">Excel 2010 and 2013<\/a>. In Excel 2016 we integrated the Power Query technology and experience into Excel. Power Query is no longer an add-in but is a native Excel feature from the Data tab, under the Get &amp; Transform section.<\/p>\n<p>In addition, most of the features in the Get &amp; Transform section are now available for all users on all Office plans.<\/p>\n<p>If you are not familiar with Power Query, here is a short summary of what you can now achieve in Excel 2016 with this new technology.<\/p>\n<ul>\n<li><strong>Data connectivity<\/strong>\u2014Connect to many new data sources, such as Facebook and Salesforce, to import the data into Excel 2016.<\/li>\n<li><strong>Data shaping<\/strong>\u2014Extract a preview of the data and load it to the Query Editor to define transformation steps that will allow you to transform the data to the format that meets your needs, such as remove, group, pivot or unpivot columns, and filter rows.<\/li>\n<li><strong>Data catalog<\/strong>\u2014You can find the data you need by searching the Power BI Enterprise catalog (a Power BI license is required).<\/li>\n<li><strong>Repeatable refresh<\/strong>\u2014Simply click the <strong>Refresh All<\/strong> button on the Data ribbon to repeat the import and transformation of the data to your workbook.<\/li>\n<\/ul>\n<p>You can learn more about the new capabilities and how to use them <a href=\"http:\/\/support.office.com\/article\/881c63c6-37c5-4ca2-b616-59e18d75b4de\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>If you are familiar with the Power Query add-in in Excel 2010 and 2013, you know there are several advantages of having the Power Query technology native in Excel 2016, including:<\/p>\n<ul>\n<li><strong>It\u2019s always there<\/strong>\u2014No longer a separate downloadable add-in. The Power Query technology is now available as part of Excel 2016, so you can rely on everyone using Excel 2016 to have it and be able to consume your workbooks.<\/li>\n<li><strong>No complex activation<\/strong>\u2014The Get &amp; Transform group is visible and active by default on the Data tab.<\/li>\n<li><strong>Undo support<\/strong>\u2014Refresh and Edit Query operations on queries can be undone. You can refresh your query and keep all your previous actions in the Undo stack as well.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-170001\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Power-Query-for-Excel-2016-2.png\" alt=\"Power Query for Excel 2016 2\" width=\"300\" height=\"260\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Power-Query-for-Excel-2016-2.png 302w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Power-Query-for-Excel-2016-2-300x260.png 300w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p style=\"padding-left: 52px\">(In the image above we highlighted the Refresh Data and Edit Query Properties operations completed in the <strong>Workbook Queries<\/strong> task pane. Excel 2016 kept these operations in its Undo\/Redo stack. In earlier versions, any Power Query operation deleted the Undo\/Redo stack.)<\/p>\n<ul>\n<li><strong>Object Model support<\/strong>\u2014You can automate your queries with Object Model and develop your dream, an automated ETL Self-Service solution. With Macro Recording you can capture your query operations and generate VBA code that automates the query creation along with your report generation and customization on Excel. To learn more on\u00a0Object Model support you can <a href=\"https:\/\/gallery.technet.microsoft.com\/VBA-to-automate-Power-956a52d1\" target=\"_blank\" rel=\"noopener\">download this demo<\/a>. More details on the Object Model interface is coming soon.<\/li>\n<\/ul>\n<p>You can learn more about Power Query technology, which is available in the Get &amp; Transform group in the Data tab, <a href=\"http:\/\/support.office.com\/article\/881c63c6-37c5-4ca2-b616-59e18d75b4de\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We\u2019re excited to let you know that your get-data experience in Excel is about to change forever. \u2014Read on to learn about how Excel 2016 has integrated Power Query technology into the Data ribbon.<\/p>\n","protected":false},"author":3368823,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","footnotes":""},"content-type":[4035],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-169991","post","type-post","status-publish","format-standard","hentry","content-type-tips-and-guides","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business","review-flag-1680288349-139","review-flag-1680288349-963","review-flag-alway-1680288348-694","review-flag-new-1680288347-871"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Integrating Power Query technology in Excel 2016 | Microsoft 365 Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Integrating Power Query technology in Excel 2016 | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We\u2019re excited to let you know that your get-data experience in Excel is about to change forever. \u2014Read on to learn about how Excel 2016 has integrated Power Query technology into the Data ribbon.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-09-10T16:00:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-30T20:49:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png\" \/>\n<meta name=\"author\" content=\"The Microsoft 365 Marketing Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Microsoft 365 Marketing Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/\",\"@type\":\"Person\",\"@name\":\"The Microsoft 365 Marketing Team\"}],\"headline\":\"Integrating Power Query technology in Excel 2016\",\"datePublished\":\"2015-09-10T16:00:40+00:00\",\"dateModified\":\"2024-08-30T20:49:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\"},\"wordCount\":560,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\",\"name\":\"Integrating Power Query technology in Excel 2016 | Microsoft 365 Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png\",\"datePublished\":\"2015-09-10T16:00:40+00:00\",\"dateModified\":\"2024-08-30T20:49:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Integrating Power Query technology in Excel 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"name\":\"Microsoft 365 Blog\",\"description\":\"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization\",\"name\":\"Microsoft 365 Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png\",\"width\":279,\"height\":60,\"caption\":\"Microsoft 365 Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Integrating Power Query technology in Excel 2016 | Microsoft 365 Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/","og_locale":"en_US","og_type":"article","og_title":"Integrating Power Query technology in Excel 2016 | Microsoft 365 Blog","og_description":"Do you often import data into Excel? Do you ever need to shape your data before you analyze it and build your reports? We\u2019re excited to let you know that your get-data experience in Excel is about to change forever. \u2014Read on to learn about how Excel 2016 has integrated Power Query technology into the Data ribbon.","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2015-09-10T16:00:40+00:00","article_modified_time":"2024-08-30T20:49:19+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/author\/the-microsoft-365-marketing-team\/","@type":"Person","@name":"The Microsoft 365 Marketing Team"}],"headline":"Integrating Power Query technology in Excel 2016","datePublished":"2015-09-10T16:00:40+00:00","dateModified":"2024-08-30T20:49:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/"},"wordCount":560,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/","name":"Integrating Power Query technology in Excel 2016 | Microsoft 365 Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png","datePublished":"2015-09-10T16:00:40+00:00","dateModified":"2024-08-30T20:49:19+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/09\/Picture1-1024x642.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/09\/10\/integrating-power-query-technology-in-excel-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"Integrating Power Query technology in Excel 2016"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","name":"Microsoft 365 Blog","description":"Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. It delivers a complete, intelligent, and secure solution to empower people.","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#organization","name":"Microsoft 365 Blog","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2019\/08\/ms-logo-amp.png","width":279,"height":60,"caption":"Microsoft 365 Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft 365 Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/169991"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/users\/3368823"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/comments?post=169991"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/169991\/revisions"}],"predecessor-version":[{"id":274455,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/169991\/revisions\/274455"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=169991"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=169991"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=169991"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=169991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=169991"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=169991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}