{"id":176240,"date":"2024-01-07T15:11:15","date_gmt":"2024-01-07T14:11:15","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=176240"},"modified":"2024-01-07T15:12:10","modified_gmt":"2024-01-07T14:12:10","slug":"power-query-vba-how-does-it-work","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work","title":{"rendered":"Power Query VBA: How does it work?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"176240\" class=\"elementor elementor-176240\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ff61fb0 e-flex e-con-boxed e-con\" data-id=\"ff61fb0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bf2d95a elementor-widget elementor-widget-heading\" data-id=\"bf2d95a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Power Query VBA: Both can automate data transformation tasks in Excel and Power BI. Find out all you need to know about creating macros!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d1dba16 e-flex e-con-boxed e-con\" data-id=\"d1dba16\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d459f88 elementor-widget elementor-widget-text-editor\" data-id=\"d459f88\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>To import and transform data in <a href=\"https:\/\/datascientest.com\/en\/excel-to-power-bi-how-to-transform-a-pivot-table-in-excel-into-a-dataset-that-can-be-used-by-power-bi\">Excel and Power BI<\/a>, the <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">Power Query engine is commonly used.<\/a> This tool enables data to be manipulated from external sources.<\/p><p>However, many users are unaware that it is possible to use the <strong>VBA (Visual Basic for Applications)<\/strong> programming language to <strong>create data transformation automation macros.<\/strong><\/p><p>It&#8217;s an excellent way of making data manipulation tasks more efficient. Find out all you need to know on this subject!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e0e416f e-flex e-con-boxed e-con\" data-id=\"e0e416f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a77cacc elementor-widget elementor-widget-heading\" data-id=\"a77cacc\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power Query VBA - What is VBA?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2046e46 elementor-widget elementor-widget-text-editor\" data-id=\"2046e46\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <a href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\">VBA (Visual Basic for Applications) programming language<\/a> is directly integrated into the tools of the Microsoft 365 suite.<\/p><p>It lets you easily create macros to automate the most <a href=\"https:\/\/datascientest.com\/en\/excel-if-function-what-is-it-for-and-how-do-i-use-it\">repetitive tasks in software such as Excel,<\/a> Word, Access, PowerPoint and Outlook.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd68f67 elementor-widget elementor-widget-image\" data-id=\"bd68f67\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/visual-basic-for-applications.png\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e0b1bf6 e-flex e-con-boxed e-con\" data-id=\"e0b1bf6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2e6d9fe elementor-widget elementor-widget-heading\" data-id=\"2e6d9fe\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is Power Query?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b37981 elementor-widget elementor-widget-text-editor\" data-id=\"7b37981\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/excel-vs-power-bi-what-are-the-differences\">Integrated with Excel, Power BI and other tools<\/a> in the Microsoft Power Platform ecosystem, <a href=\"https:\/\/datascientest.com\/en\/dataflow-power-bi-everything-you-need-to-know-about-the-self-service-etl-tool\">Power Query enables data extraction, transformation and loading (ETL).<\/a><\/p><p>In particular, it is used to load, clean and transform data from a variety of sources. These include Excel, CSV files, databases, cloud services and web pages.<\/p><p><strong>Data transformation<\/strong> operations include filtering, sorting, grouping, column splitting and grouping. Custom columns can also be added using <strong>Power Query formulas.<\/strong><\/p><p>To create relationships between tables, they can also be linked using foreign keys. The tool also allows you to create dynamic queries to update data as it is added or modified in the external source.<\/p><p><strong>Power Query&#8217;s<\/strong> strong point is its intuitive, easy-to-use interface for importing and transforming data. However, repeating the same transformation tasks over and over again for different sources can quickly become tedious. The <strong>VBA language offers an alternative.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-594ca81 e-flex e-con-boxed e-con\" data-id=\"594ca81\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ccc2298 elementor-widget elementor-widget-heading\" data-id=\"ccc2298\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Why use Power Query VBA together?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3efb075 elementor-widget elementor-widget-text-editor\" data-id=\"3efb075\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>By <strong>using VBA in conjunction with Power Query,<\/strong> it is possible to automate data transformation tasks with the aim of increasing efficiency.<\/p><p>The first step is to create a <strong>Power Query, via the Excel user<\/strong> interface or the Power BI editor. Once the query has been created, it can be saved as an automation macro that can be freely modified. Here are a few examples of use cases.<\/p><p>Firstly, the process of importing data from different sources can be automated with <strong>VBA macros<\/strong>. You can then transform the data with <strong>Power Query<\/strong> to make it more usable, and create visualizations with Power BI.<\/p><p>For<a href=\"https:\/\/datascientest.com\/en\/data-cleaning-definition-methods-and-relevance-in-data-science\"> data cleansing tasks,<\/a> VBA can, for example, automate the deletion of duplicate rows and unnecessary columns, replace missing values, or convert data into different formats.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d077ec4 elementor-widget elementor-widget-image\" data-id=\"d077ec4\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/automatisation-taches.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5f58076 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5f58076\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn to use VBA with Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0dbba50 elementor-widget elementor-widget-text-editor\" data-id=\"0dbba50\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>VBA<\/strong> can also be used to <a href=\"https:\/\/datascientest.com\/en\/data-sources-understanding-the-definition-and-inner-workings\">combine several data sources<\/a> using Power Query. For example, several Excel sheets can be combined into a single query.<\/p><p>Similarly, data from different external sources can be combined. For example, a CSV file can be combined with a database.<\/p><p>There&#8217;s nothing to stop you creating a VBA macro to create <strong>Power Query<\/strong> connections for several Excel tables. This saves time compared with manually creating a connection for each table to be combined.<\/p><p>Another use case example is the use of a VBA macro to create a refresh button, enabling the user to automate queries directly in Excel or Power BI.<\/p><p>As a general rule, all repetitive transformation tasks can be automated with <strong>VBA<\/strong>. Its use is therefore highly relevant for processes to be carried out with Power BI on each new data source. However, there are limits to this synergy.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-aaa45df e-flex e-con-boxed e-con\" data-id=\"aaa45df\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b792cba elementor-widget elementor-widget-heading\" data-id=\"b792cba\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power Query VBA - What are the limits?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de69034 elementor-widget elementor-widget-text-editor\" data-id=\"de69034\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong>VBA macros<\/strong> are very useful, but cannot exceed a certain level of complexity. A data transformation task that is too arduous requires a complicated macro that will be difficult to maintain properly.<\/p><p>Similarly, <strong>Power Query<\/strong> is a powerful data manipulation tool, but does not support certain data sources. It is also limited in terms of data transformation.<\/p><p>On data sources with complex relationships between tables, automating <strong>transformation tasks can also be difficult.<\/strong><\/p><p>Alternatively, more advanced data manipulation tools such as Python, R or <a href=\"https:\/\/datascientest.com\/en\/sql-learn-all-about-the-programming-language-for-databases\">SQL can be used to create automation scripts.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8e001dc elementor-widget elementor-widget-image\" data-id=\"8e001dc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/pexels-pixabay-270557.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9097c5f e-flex e-con-boxed e-con\" data-id=\"9097c5f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d8ffa0a elementor-widget elementor-widget-heading\" data-id=\"d8ffa0a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Power Query VBA - Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f54c484 elementor-widget elementor-widget-text-editor\" data-id=\"f54c484\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The <strong>VBA language<\/strong> is very useful for automating data transformation tasks on <strong>Power Query for Excel and Power BI.<\/strong> It is a valuable asset for the most repetitive processes, although it does have its limitations for complex manipulations.<\/p><p>To learn how to<strong> handle Power Query,<\/strong> VBA and other advanced Excel or Power BI tools, you can choose DataScientest.<\/p><p>Our intensive Power BI training takes place over 38 hours, spread over 5 days. The first 3 days are dedicated to introductory training for beginners, and the following 2 days are designed to reinforce your expertise and are aimed at initiates.<\/p><p>You can take the whole course, or choose one of the two parts depending on your needs and skill level.<\/p><p>By the end of the course, you will have fully mastered Power BI and be able to use it to collect, transform and analyze data and create interactive dashboards.<strong> DAX, <a href=\"https:\/\/datascientest.com\/en\/power-query-m-language-avoid-these-mistakes\">M<\/a>, VBA and the Power Query engine<\/strong> will hold no secrets for you.<\/p><p>All our teachers are Microsoft Trainer certified, and our organization has Microsoft Learning Partner status. This means that we can accompany you all the way to Microsoft PL-300 certification to become a Power BI Data Analyst Associate!<\/p><p>The program is completed entirely by distance learning via the web, and we are eligible for funding options. Discover DataScientest!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6b09ae8 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"6b09ae8\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover DataScientest training courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-09147d0 e-flex e-con-boxed e-con\" data-id=\"09147d0\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-264b221 elementor-widget elementor-widget-html\" data-id=\"264b221\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is VBA?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The VBA (Visual Basic for Applications) programming language is directly integrated into the tools of the Microsoft 365 suite. It makes it easy to create macros, to automate the most repetitive tasks in software such as Excel, Word, Access, PowerPoint and Outlook.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"Integrated with Excel, Power BI and other tools in the Microsoft Power Platform ecosystem, Power Query enables the extraction, transformation and loading (ETL) of data. In particular, it is used to load, clean and transform data from a variety of sources. These include Excel, CSV files, databases, cloud services and web pages.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What's the use of VBA with Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"By using VBA in conjunction with Power Query, it is possible to automate data transformation tasks with the aim of increasing efficiency. The first step is to create a Power Query, via the Excel user interface or the Power BI editor. Once the query has been created, it can be saved as an automation macro that can be freely modified. Here are several examples of use cases.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Power Query VBA: Both can automate data transformation tasks in Excel and Power BI. Find out all you need to know about creating macros! To import and transform data in Excel and Power BI, the Power Query engine is commonly used. This tool enables data to be manipulated from external sources. However, many users are [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":176244,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Query VBA: How does it work?<\/title>\n<meta name=\"description\" content=\"Power Query VBA: When combining these two techniques, you should be aware of the process order to avoid that your...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query VBA: How does it work?\" \/>\n<meta property=\"og:description\" content=\"Power Query VBA: Both can automate data transformation tasks in Excel and Power BI. Find out all you need to know about creating macros! To import and\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-07T14:11:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-07T14:12:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/power-query-vba.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query VBA: How does it work?\",\"datePublished\":\"2024-01-07T14:11:15+00:00\",\"dateModified\":\"2024-01-07T14:12:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\"},\"wordCount\":909,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\",\"name\":\"Power Query VBA: How does it work?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-07T14:11:15+00:00\",\"dateModified\":\"2024-01-07T14:12:10+00:00\",\"description\":\"Power Query VBA: When combining these two techniques, you should be aware of the process order to avoid that your...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query VBA: How does it work?","description":"Power Query VBA: When combining these two techniques, you should be aware of the process order to avoid that your...","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:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work","og_locale":"en_GB","og_type":"article","og_title":"Power Query VBA: How does it work?","og_description":"Power Query VBA: Both can automate data transformation tasks in Excel and Power BI. Find out all you need to know about creating macros! To import and","og_url":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-07T14:11:15+00:00","article_modified_time":"2024-01-07T14:12:10+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/power-query-vba.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query VBA: How does it work?","datePublished":"2024-01-07T14:11:15+00:00","dateModified":"2024-01-07T14:12:10+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work"},"wordCount":909,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work","url":"https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work","name":"Power Query VBA: How does it work?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-07T14:11:15+00:00","dateModified":"2024-01-07T14:12:10+00:00","description":"Power Query VBA: When combining these two techniques, you should be aware of the process order to avoid that your...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-vba-how-does-it-work"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176240"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=176240"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176240\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/176244"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=176240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=176240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=176240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}