{"id":6127,"date":"2019-09-19T08:00:00","date_gmt":"2019-09-19T15:00:00","guid":{"rendered":""},"modified":"2025-06-11T08:02:00","modified_gmt":"2025-06-11T15:02:00","slug":"whats-new-in-dataflows-and-data-integration-september-2019","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-and-data-integration-september-2019\/","title":{"rendered":"What\u2019s New in Dataflows and Data Integration \u2013 September 2019"},"content":{"rendered":"<p>We\u2019ve released lots of new features and enhancements to our Data Integration capabilities in PowerApps recently, enabling users to seamlessly connect to, transform and combine data from a wide range of data sources and load it into the Common Data Service, from where it can be used for creating apps, automated flows or analytics.<\/p>\n<p>Here\u2019s a recap of everything that\u2019s new:<\/p>\n<ul>\n<li>\u201cData Integration\u201d renamed to \u201cDataflows\u201d<\/li>\n<li>Support for Analytical dataflows<\/li>\n<li>New Connectors:\u00a0PDF Files,\u00a0Teradata,\u00a0MySQL and\u00a0PostgreSQL<\/li>\n<li>Merge Queries \u2013 Visual join kind selection<\/li>\n<li>Fill Up\/Down<\/li>\n<li>Move Columns left\/right\/beginning\/end<\/li>\n<li>Replace Errors<\/li>\n<li>List Transforms: Statistics, Sort, Keep\/Remove\/Reverse items<\/li>\n<li>Select Related Tables as part of Get Data<\/li>\n<li>M Intellisense support in Advanced Query Editor<\/li>\n<li>More descriptive error messages within Power Query Online<\/li>\n<li>Support for going Back from \u201cMap Entities\u201d to the \u201cEdit Queries\u201d stage.<\/li>\n<\/ul>\n<p>You can continue reading below for more details about each of these new capabilities.<\/p>\n<h2>\u201cData Integration\u201d renamed to \u201cDataflows\u201d<\/h2>\n<p>We\u2019re renaming the \u201cData Integration\u201d tab in the PowerApps navigation bar to \u201cDataflows\u201d. Data Integration projects are now also called \u201cDataflows\u201d. This change provides naming consistency with our <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/common-data-service\/self-service-data-prep-with-dataflows\">Dataflows capabilities available across the Power Platform<\/a>.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6130 size-large\" height=\"283\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png\" width=\"525\"\/><\/a><\/p>\n<h2>Support for Analytical dataflows<\/h2>\n<p>This month we\u2019re introducing an enhancement that allows creation of Dataflows containing only Analytical entities. This option can be selected within the \u201cNew dataflow\u201d screen.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-2.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6131 size-large\" height=\"299\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-2-1024x584.png\" width=\"525\"\/><\/a><\/p>\n<p>Analytical dataflows allow free-form entities to be created, but also provide built-in experiences for harmonizing those entities into standard Common Data Model entity schemas, using the \u201cMap to standard entity\u201d dialog accessible from the Power Query Editor. Dataflow entities are also stored in <a href=\"https:\/\/docs.microsoft.com\/en-us\/common-data-model\/data-lake\">CDM Folders<\/a> within Azure Data Lake, allowing integration with other Azure Data and AI services, analytics and insights scenarios.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-3.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6132 size-large\" height=\"265\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-3-1024x516.png\" width=\"525\"\/><\/a><\/p>\n<p>Analytical dataflows can also be used as intermediate building blocks for other dataflows. This allows organizations to create multiple layers of refinement and specialization of entities within an environment that can be ultimately loaded into the Common Data Service.<\/p>\n<p>Please note that this is just an initial release of these new Analytical dataflows capabilities. We&#8217;re planning to make significant additions to this area over time. Stay tuned.<\/p>\n<p>You can find more information about Analytical dataflows in our documentation articles: <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/common-data-service\/create-and-use-dataflows\">https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/common-data-service\/create-and-use-dataflows<\/a><\/p>\n<h2>New Data Connectors &#8211; PDF Files, Teradata, MySQL and PostgreSQL<\/h2>\n<p>Four new data connectors have been recently enabled within Dataflows, allowing users to get data from an increasing number of data sources, spanning across Files, Databases, Azure and other online services.<\/p>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-4.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6133 size-large\" height=\"312\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-4-1024x608.png\" width=\"525\"\/><\/a><\/p>\n<p>You can find these connectors within the \u201cChoose data source\u201d screen in the Dataflows wizard.<\/p>\n<h2>New Data Transformations<\/h2>\n<p>Over the past few weeks several new data transformation capabilities have been added within the Power Query Online Editor stage of the Dataflows authoring wizard, including:<\/p>\n<ul>\n<li><strong>Merge Queries \u2013 Visual join kind selection<\/strong>: The Merge Queries dialog now provides more visual ways to select the join kind for a given merge operation. This dialog can be accessed from the \u201cCombine Tables\u201d menu in the Power Query Editor toolbar.<br \/>\n<a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-5.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6134\" height=\"595\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-5-837x1024.png\" width=\"486\"\/><\/a><\/li>\n<li><strong>Fill Up\/Down<\/strong>: A new Fill section has been added to the \u201cTransform Column\u201d menu in the Power Query Online Editor toolbar, allowing customers to propagate up\/down non-empty cell values to all consecutive empty cells. These two transformations can also be accessed from the right-click context menu for a column in the data preview.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-6.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6135 size-large\" height=\"168\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-6-1024x328.png\" width=\"525\"\/><\/a><\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><strong>Move Columns left\/right\/beginning\/end<\/strong>: We\u2019ve added options to allow users to easily move columns within the data preview, either one position to the left or right, or all the way to become the left-most or right-most column in the table. Note that these options are available also when selecting multiple columns at once. These capabilities can be accessed via the \u201cTransform Column\u201d menu in the toolbar or the column context menu in the data preview.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<ul>\n<li><strong>Replace Errors<\/strong>: Another new transformation added this month to the \u201cTransform Column\u201d menu allows users to quickly replace error values within a column with another value, such as a default. Error values can happen under many circumstances, such as parsing errors when trying to convert a column from type text to number or date, for example. By using Replace Errors, users can ensure that there\u2019s a good fall back value to be loaded. Alternatively, users can leverage the Keep Errors and Remove Errors options under the \u201cReduce Rows\u201d menu to narrow down rows in a table to only the ones with or without errors.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-7.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6136 size-large\" height=\"184\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-7-1024x359.png\" width=\"525\"\/><\/a><\/p>\n<ul>\n<li><strong>List Transforms: Statistics, Sort, Keep\/Remove\/Reverse items and more<\/strong> \u2013 When working with lists in the Power Query Editor, users can apply several different transformations (check the <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerquery-m\/power-query-m-function-reference\">full M reference for details<\/a>), but up until a few weeks ago the Power Query Editor did not expose such options via the UX. With our recent updates, most commonly used transformations are now easily accessible from the Power Query Editor toolbar.<\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-8.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6137 size-large\" height=\"135\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-8-1024x264.png\" width=\"525\"\/><\/a>\u00a0<\/strong><\/p>\n<h2>Other authoring improvements<\/h2>\n<p>We\u2019ve made a few other improvements across different areas of the Dataflows Authoring experience:<\/p>\n<ul>\n<li><strong>Select Related Tables as part of Get Data<\/strong>: Earlier this month, we released an update that lights up the \u201cSelect Related Tables\u201d capability within the Navigator (or Choose data) stage of the Power Query experience. This option allows users to easily identify and select all tables that have relationships in the data source to the currently selected tables. This new \u201cSelect Related Tables\u201d option is available for those connectors that expose relationships information, such as relational databases (SQL Server, Oracle, MySQL, etc.), OData and other sources.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-9.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6138 size-large\" height=\"315\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-9-1024x615.png\" width=\"525\"\/><\/a><\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><strong>M Intellisense support in Advanced Query Editor and Formula Bar<\/strong>: One of the most frequently requested features from users has been Intellisense support when authoring M code in the Power Query Editor. Recently we enabled M Intellisense in the Advanced Query Editor (accessible via the right-click menu on queries within the Queries pane) and the formula bar.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-10.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6139 size-large\" height=\"311\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-10-1024x607.png\" width=\"525\"\/><\/a><\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><strong>More descriptive error messages within Power Query Online<\/strong>: We have improved the error message information within the Power Query Editor, so that error details from the M Engine are now also exposed to users. This enables better diagnostics of errors.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<ul>\n<li><strong>Support for going Back from \u201cMap Entities\u201d to the \u201cEdit Queries\u201d stage<\/strong>: Another very frequently requested usability enhancement from Dataflows users was the ability to go back from the \u201cMap Entities\u201d to the Power Query Editor screen within the Dataflows authoring wizard. This is a common action given that users might have forgotten certain columns or transformations to be applied before they can successfully map to target entities in the Common Data Service.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-11.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"aligncenter wp-image-6140 size-large\" height=\"311\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-11-1024x607.png\" width=\"525\"\/><\/a><\/p>\n<p>\u00a0<\/p>\n<p>That\u2019s all for this month. We hope that you find these features useful and are looking forward to your feedback.<\/p>\n<p>Please let us know if you have any suggestions for how to improve Dataflows by using the Dataflows category in the PowerApps Ideas Forum: <a href=\"https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Ideas\/idb-p\/PowerAppsIdeas\/label-name\/dataflows\">https:\/\/powerusers.microsoft.com\/t5\/PowerApps-Ideas\/idb-p\/PowerAppsIdeas\/label-name\/dataflows<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We\u2019ve released lots of new features and enhancements to our Data Integration capabilities in PowerApps recently, enabling users to seamlessly connect to, transform and combine data from a wide range of data sources and load it into the Common Data Service, from where it can be used for creating apps, automated flows or analytics.<\/p>\n","protected":false},"author":182,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3424],"job-role":[],"product":[3473],"property":[],"topic":[],"coauthors":[2166],"class_list":["post-6127","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-news","product-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What\u2019s New in Dataflows and Data Integration \u2013 September 2019 - Microsoft Power Platform 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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What\u2019s New in Dataflows and Data Integration \u2013 September 2019 - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We\u2019ve released lots of new features and enhancements to our Data Integration capabilities in PowerApps recently, enabling users to seamlessly connect to, transform and combine data from a wide range of data sources and load it into the Common Data Service, from where it can be used for creating apps, automated flows or analytics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-and-data-integration-september-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-19T15:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:02:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2507\" \/>\n\t<meta property=\"og:image:height\" content=\"1352\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Miguel Llopis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Miguel Llopis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/miguel-llopis\/\",\"@type\":\"Person\",\"@name\":\"Miguel Llopis\"}],\"headline\":\"What\u2019s New in Dataflows and Data Integration \u2013 September 2019\",\"datePublished\":\"2019-09-19T15:00:00+00:00\",\"dateModified\":\"2025-06-11T15:02:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/\"},\"wordCount\":1148,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png\",\"keywords\":[\"Dataverse\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/\",\"name\":\"What\u2019s New in Dataflows and Data Integration \u2013 September 2019 - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png\",\"datePublished\":\"2019-09-19T15:00:00+00:00\",\"dateModified\":\"2025-06-11T15:02:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage\",\"url\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png\",\"contentUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What\u2019s New in Dataflows and Data Integration \u2013 September 2019\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/6251391b226568dced2079fdc0eccc12\",\"name\":\"Miguel Llopis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=gd905e082f13e06f06dbbd215315601e8\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g\",\"caption\":\"Miguel Llopis\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/millopis\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What\u2019s New in Dataflows and Data Integration \u2013 September 2019 - Microsoft Power Platform 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:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/","og_locale":"en_US","og_type":"article","og_title":"What\u2019s New in Dataflows and Data Integration \u2013 September 2019 - Microsoft Power Platform Blog","og_description":"We\u2019ve released lots of new features and enhancements to our Data Integration capabilities in PowerApps recently, enabling users to seamlessly connect to, transform and combine data from a wide range of data sources and load it into the Common Data Service, from where it can be used for creating apps, automated flows or analytics.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-apps\/whats-new-in-dataflows-and-data-integration-september-2019\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2019-09-19T15:00:00+00:00","article_modified_time":"2025-06-11T15:02:00+00:00","og_image":[{"width":2507,"height":1352,"url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png","type":"image\/png"}],"author":"Miguel Llopis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Miguel Llopis","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/miguel-llopis\/","@type":"Person","@name":"Miguel Llopis"}],"headline":"What\u2019s New in Dataflows and Data Integration \u2013 September 2019","datePublished":"2019-09-19T15:00:00+00:00","dateModified":"2025-06-11T15:02:00+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/"},"wordCount":1148,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png","keywords":["Dataverse"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/","name":"What\u2019s New in Dataflows and Data Integration \u2013 September 2019 - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png","datePublished":"2019-09-19T15:00:00+00:00","dateModified":"2025-06-11T15:02:00+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#primaryimage","url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png","contentUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/09\/PPDFSep19-1-1024x552.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2019\/09\/19\/whats-new-in-dataflows-and-data-integration-september-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"What\u2019s New in Dataflows and Data Integration \u2013 September 2019"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/6251391b226568dced2079fdc0eccc12","name":"Miguel Llopis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=gd905e082f13e06f06dbbd215315601e8","url":"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4658d23d1c78d434d571261ae820d24327cd861390563d156834208039471d0f?s=96&d=mm&r=g","caption":"Miguel Llopis"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/millopis\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/6127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/182"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=6127"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/6127\/revisions"}],"predecessor-version":[{"id":130774,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/6127\/revisions\/130774"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=6127"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=6127"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=6127"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=6127"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=6127"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=6127"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=6127"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=6127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}