{"id":153361,"date":"2015-07-15T09:00:45","date_gmt":"2015-07-15T16:00:45","guid":{"rendered":"http:\/\/www.microsoft.com\/?p=153361"},"modified":"2024-08-30T14:29:55","modified_gmt":"2024-08-30T21:29:55","slug":"6-updates-in-power-query-for-excel","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/","title":{"rendered":"6 updates in Power Query for Excel"},"content":{"rendered":"<p>This month\u2019s Power Query update includes six new or improved features including:<\/p>\n<ul>\n<li>Improvements to ODBC Connector<\/li>\n<li>Navigator dialog improvements<\/li>\n<li>Option to enable Fast Data Load versus Background Data Load<\/li>\n<li>Support for Salesforce Custom environments in Recent Sources list<\/li>\n<li>Easier parsing of Date or Time values out of a Text column with Date\/Time information<\/li>\n<li>Unpivot Other Columns entry in column context menu<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379&amp;WT.mc_id=Blog_PBI_Announce_DI\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-153431 size-full\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png\" alt=\"Download Power Query\" width=\"272\" height=\"40\" \/><\/a><\/p>\n<p>You can continue reading below for more details about each feature.<\/p>\n<h3>Improvements to ODBC Connector<\/h3>\n<p>We improved the ODBC Connector by making the SQL statement optional instead of required. Now users can simply provide the Connection String for their ODBC source and navigate the list of tables available from the data source, pick up the ones they want to import, and apply any additional transformations needed in the Query Editor. This greatly simplifies the process for bringing in data from several data sources supported via ODBC.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-153381\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-1.png\" alt=\"6 updates in Power Query for Excel 1\" width=\"640\" height=\"231\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-1.png 526w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-1-300x108.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<h3>Navigator dialog improvements<\/h3>\n<p>With this update, we made several improvements to the Navigator dialog:<\/p>\n<ul>\n<li>Ability to resize the Navigator pane\u2014We made the list of databases\/tables, in the left side of the Navigator dialog, resizable to improve readability.<\/li>\n<li>Added the \u201cPreview downloaded on\u2026\u201d message\u2014On the Navigator dialog previews, below the table name, the new \u201cPreview downloaded on\u2026\u201d message has been added to indicate the freshness of the data. In many cases, Power Query leverages the local cache for previews of tables that users have already imported. This might be confusing to users seeing outdated data. The \u201cPreview downloaded on\u2026\u201d message addresses this confusion. The message is displayed for previews older than 24 hours. Note: if you want to retrieve the latest data preview before importing the data, it\u2019s also possible to refresh this data preview from the top-right corner of the dialog.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-153421\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-for-Power-Query-for-Excel-2.jpg\" alt=\"6 updates for Power Query for Excel 2\" width=\"640\" height=\"509\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-for-Power-Query-for-Excel-2.jpg 881w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-for-Power-Query-for-Excel-2-300x239.jpg 300w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-for-Power-Query-for-Excel-2-768x611.jpg 768w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<h3>Option to enable Fast Data Load versus Background Data Load<\/h3>\n<p>We added an option for users to control whether the query should be loaded to the workbook in the background or use the new \u201cFast Data Load\u201d option to accelerate the query download. The default behavior is \u201cBackground Data Load,\u201d but now users can instead choose the \u201cFast Data Load\u201d mode in the Options dialog. When loading a query using the \u201cFast Data Load\u201d mode, your query will take less time to load, however, Excel may be unresponsive for long periods of time during the upload.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-153511\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/cropped-6-updates-in-Power-Query-for-Excel-3.png\" alt=\"cropped-6 updates in Power Query for Excel 3\" width=\"644\" height=\"493\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/cropped-6-updates-in-Power-Query-for-Excel-3.png 644w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/cropped-6-updates-in-Power-Query-for-Excel-3-300x230.png 300w\" sizes=\"(max-width: 644px) 100vw, 644px\" \/><\/p>\n<h3>Support for Salesforce Custom environments in Recent Sources list<\/h3>\n<p>Last month we added a new option to the Salesforce connector to specify whether to connect to Production or a Custom environment. This month we are enabling the Salesforce Custom environments to be shown in the Recent Sources list.<\/p>\n<h3>Easier parsing of Date or Time values out of a Text column<\/h3>\n<p>We made it much easier to extract a Date or a Time value from a text column that contains a DateTime or DateTimeTimezone value represented as Text. Before this update, you would need to convert your Text column to DateTime or DateTimeTimeZone and then extract the Date or Time component.<\/p>\n<p>In this month\u2019s update, we\u2019ve added two new options under the Transform and Add Column tabs, in the Date &amp; Time dropdown menus, to parse these data types out of the currently selected Text columns.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-153401\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-4.png\" alt=\"6 updates in Power Query for Excel 4\" width=\"640\" height=\"151\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-4.png 957w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-4-300x71.png 300w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-4-768x181.png 768w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<h3>Unpivot Other Columns entry in column context menu<\/h3>\n<p>\u201cUnpivot Columns\u201d is one of the most popular transformations in Power Query. However, what many users don\u2019t know is that \u201cUnpivot Other Columns\u201d is even better! \u201cUnpivot Other Columns\u201d helps users ensure their queries automatically pick up new columns added to the original data in the future. This is the most common case for tables where new columns are added for each new period of data (i.e. years, quarters). Users only need to select the columns that are \u201cstable\u201d and select <b>Unpivot<\/b><b> Other Columns<\/b>\u2014from that point on all other columns in the table will be unpivoted.<\/p>\n<p>\u201cUnpivot Other Columns\u201d has been available for a while in the Transform tab, under Unpivot Columns, but now we also added it to the column context menu in the preview for easier access and discoverability.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-153403\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-5.png\" alt=\"6 updates in Power Query for Excel 5\" width=\"640\" height=\"241\" srcset=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-5.png 910w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-5-300x113.png 300w, https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/6-updates-in-Power-Query-for-Excel-5-768x289.png 768w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><span class=\"TextRun SCX47061178\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX47061178\">That\u2019s all for this month. We\u2019re making lots of incremental improvements to Power Query and we hope that you find it better with every new monthly update. Please continue sending us feedback using our \u201cSend a Smile\/Frown\u201d feature, or by <\/span><\/span><a class=\"Hyperlink SCX47061178\" href=\"https:\/\/support.powerbi.com\/forums\/265200-power-bi\/category\/91861-designer\" target=\"_blank\" rel=\"noopener\"><span class=\"TextRun Underlined SCX47061178\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX47061178\">voting for what you\u2019d like t<\/span><\/span><span class=\"TextRun Underlined SCX47061178\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX47061178\">o see next<\/span><\/span><\/a><span class=\"TextRun SCX47061178\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX47061178\">.<\/span><\/span><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379&amp;WT.mc_id=Blog_PBI_Announce_DI\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-153431 size-full\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png\" alt=\"Download Power Query\" width=\"272\" height=\"40\" \/><\/a><\/p>\n<p><span class=\"TextRun SCX228364233\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX228364233\">\u2014Miguel <\/span><\/span><span class=\"TextRun SCX228364233\" xml:lang=\"EN-US\"><span class=\"SpellingError SCX228364233\">Llopis<\/span><\/span><span class=\"TextRun SCX228364233\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX228364233\">, program manager on the Power Query team<\/span><\/span><span class=\"TextRun SCX228364233\" xml:lang=\"EN-US\"><span class=\"NormalTextRun SCX228364233\">.<\/span><\/span><\/p>\n<hr \/>\n<p>Power Query for Excel is available with an Office 365 ProPlus subscription, Office 2010 Professional Plus with Software Assurance, Office 2013 Professional Plus or Excel 2013 Standalone.\u202fPower Query for Excel is also available in all other Excel 2013 Desktop SKUs with reduced functionality. Check out the System Requirements section on <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noopener\">this page<\/a> for more details.<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noopener\">Download the add-in<\/a> and learn more about <a href=\"https:\/\/support.office.com\/en-us\/article\/Introduction-to-Microsoft-Power-Query-for-Excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605\" target=\"_blank\" rel=\"noopener\">getting started<\/a>.<\/p>\n<ul>\n<li>Learn more about <a href=\"https:\/\/support.office.com\/en-us\/article\/Introduction-to-Microsoft-Power-Query-for-Excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605\" target=\"_blank\" rel=\"noopener\">Power Query<\/a><\/li>\n<li>Get your <a href=\"http:\/\/products.office.com\/home\" target=\"_blank\" rel=\"noopener\">Office 365 subscription<\/a><\/li>\n<li>Try <a href=\"https:\/\/www.powerbi.com\/\" target=\"_blank\" rel=\"noopener\">Power BI<\/a><\/li>\n<li>Follow us: <a href=\"https:\/\/www.facebook.com\/mspowermap\" target=\"_blank\" rel=\"noopener\">Facebook<\/a> and <a href=\"https:\/\/twitter.com\/mspowermap\" target=\"_blank\" rel=\"noopener\">Twitter<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This month\u2019s\u202fPower Query\u202ffor Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.<\/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":[4034],"product":[4047,4036],"audience":[4081,4101,4102],"tags":[],"coauthors":[4437],"class_list":["post-153361","post","type-post","status-publish","format-standard","hentry","content-type-news","product-excel","product-microsoft-365","audience-enterprise","audience-personal-and-family","audience-small-business","review-flag-1680288349-139","review-flag-1680288349-963","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>6 updates in Power Query for Excel | 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\/07\/15\/6-updates-in-power-query-for-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6 updates in Power Query for Excel | Microsoft 365 Blog\" \/>\n<meta property=\"og:description\" content=\"This month\u2019s\u202fPower Query\u202ffor Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft 365 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-15T16:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-30T21:29:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.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=\"3 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\/07\/15\/6-updates-in-power-query-for-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/\"},\"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\":\"6 updates in Power Query for Excel\",\"datePublished\":\"2015-07-15T16:00:45+00:00\",\"dateModified\":\"2024-08-30T21:29:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/\"},\"wordCount\":823,\"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\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/\",\"name\":\"6 updates in Power Query for Excel | 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\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png\",\"datePublished\":\"2015-07-15T16:00:45+00:00\",\"dateModified\":\"2024-08-30T21:29:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"6 updates in Power Query for Excel\"}]},{\"@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":"6 updates in Power Query for Excel | 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\/07\/15\/6-updates-in-power-query-for-excel\/","og_locale":"en_US","og_type":"article","og_title":"6 updates in Power Query for Excel | Microsoft 365 Blog","og_description":"This month\u2019s\u202fPower Query\u202ffor Excel update is now available to you and is packed with lots of new features including improvements to the ODBC Connector and the Navigator dialog, the ability to download queries faster, expanded support for Salesforce Custom environments, and improvements to date and time parsing and the Unpivot column features.","og_url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/","og_site_name":"Microsoft 365 Blog","article_published_time":"2015-07-15T16:00:45+00:00","article_modified_time":"2024-08-30T21:29:55+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png"}],"author":"The Microsoft 365 Marketing Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Microsoft 365 Marketing Team","Est. reading time":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/"},"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":"6 updates in Power Query for Excel","datePublished":"2015-07-15T16:00:45+00:00","dateModified":"2024-08-30T21:29:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/"},"wordCount":823,"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\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/","name":"6 updates in Power Query for Excel | 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\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png","datePublished":"2015-07-15T16:00:45+00:00","dateModified":"2024-08-30T21:29:55+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2015\/07\/Download-Power-Query-image.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2015\/07\/15\/6-updates-in-power-query-for-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/"},{"@type":"ListItem","position":2,"name":"6 updates in Power Query for Excel"}]},{"@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\/153361"}],"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=153361"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/153361\/revisions"}],"predecessor-version":[{"id":274480,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/posts\/153361\/revisions\/274480"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/media?parent=153361"}],"wp:term":[{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/content-type?post=153361"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/product?post=153361"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/audience?post=153361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/tags?post=153361"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-json\/wp\/v2\/coauthors?post=153361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}