{"id":183212,"date":"2024-03-18T08:46:00","date_gmt":"2024-03-18T07:46:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=183212"},"modified":"2024-03-14T21:15:54","modified_gmt":"2024-03-14T20:15:54","slug":"power-query-sdk-everything-you-need-to-know-about-this-development-kit","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit","title":{"rendered":"Power Query SDK: everything you need to know about this development kit"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"183212\" class=\"elementor elementor-183212\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-be47bdc e-flex e-con-boxed e-con\" data-id=\"be47bdc\" 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-bb170b4 elementor-widget elementor-widget-heading\" data-id=\"bb170b4\" 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\">The Power Query SDK is the development kit for Power Query, the Microsoft query engine found in Excel and Power BI. It lets you create customized connectors for data sources. Find out what it's for and how to use it!<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e518fc0 elementor-widget elementor-widget-text-editor\" data-id=\"e518fc0\" 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 take full <a href=\"https:\/\/datascientest.com\/en\/online-data-scientist-training\">advantage of data<\/a> and the valuable information it contains, professionals today need a dynamic and powerful approach to manipulating and transforming data.<\/p><p>This is precisely what the <strong>Power Query SDK<\/strong> offers, enabling you to create connectors for data sources on well-known Microsoft solutions such as <a href=\"https:\/\/datascientest.com\/en\/streamline-data-analysis-how-to-apply-filters-in-excel\">Power BI and Excel<\/a>.<\/p><p>Whether you&#8217;re an experienced data analyst looking to optimize<a href=\"https:\/\/datascientest.com\/en\/etl-or-extract-transform-load-definition-and-use\"> ETL processes<\/a>, or a beginner looking to get started in this field, discover all the possibilities!<\/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-8ea0acd e-flex e-con-boxed e-con\" data-id=\"8ea0acd\" 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-aae299f elementor-widget elementor-widget-heading\" data-id=\"aae299f\" 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 the Power Query SDK?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53b4014 elementor-widget elementor-widget-text-editor\" data-id=\"53b4014\" 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 initials<strong> SDK stand for &#8220;Software Development Kit&#8221;.<\/strong> In this case, it&#8217;s a software toolbox developed by Microsoft to extend the functionalities of Power Query.<\/p><p>This query engine, natively integrated into applications such as <a href=\"https:\/\/datascientest.com\/en\/microsoft-power-bi-10-reasons-to-use-it\">Power BI,<\/a> Excel and Azure Data Factory, offers a user-friendly graphical interface for data preparation and transformation.<\/p><p>However, the SDK goes beyond this graphical interface by enabling developers to extend and customize <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">Power Query<\/a>&#8216;s functionalities. It therefore offers greater flexibility to meet the specific needs of each data integration project.<\/p><p>Whether for automating recurring tasks, creating advanced data transformations or integrating customized data sources, this tool provides a dynamic playground for professionals.<\/p><p>With this set of tools, you can create your own Power Query connectors. These are often referred to as custom connectors or <strong>Power Query extensions.<\/strong><\/p><p>These connectors can be used to create new data sources, or to customize and extend an existing one.<\/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-f825ce0 elementor-widget elementor-widget-image\" data-id=\"f825ce0\" 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\/12\/power_query_sdk1.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-1a27d76 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"1a27d76\" 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 our 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-b8f6c27 e-flex e-con-boxed e-con\" data-id=\"b8f6c27\" 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-58690a9 elementor-widget elementor-widget-heading\" data-id=\"58690a9\" 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 the purpose of the Power Query SDK?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de22b2c elementor-widget elementor-widget-text-editor\" data-id=\"de22b2c\" 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 main use cases for the<strong> Power Query SDK<\/strong> include the creation of a view accessible to business analysts for a <strong>REST API.<\/strong><\/p><p>The aim may also be to provide branding for a source that <strong>Power Query supports<\/strong> with an existing connector, or to implement an OAuth v2 authentication flow for a SaaS offering.<\/p><p>It can also mean exposing a filtered or limited view on your <a href=\"https:\/\/datascientest.com\/en\/data-sources-understanding-the-definition-and-inner-workings\">data source<\/a> to improve usability, or enabling <strong>DirectQuery<\/strong> for a data source using an <strong>ODBC driver.<\/strong><\/p><p>By connecting <strong>Power Query to data sources,<\/strong> it becomes possible to use the visual interface or scripting language to extract, transform and load data using queries.<\/p><p>Several key features make this<strong> SDK a preferred choice,<\/strong> including the ability to create custom connectors for integrating context-specific data sources.<\/p><p>These include the ability to apply filters to extract specific data or sort it according to defined criteria, as well as to join data from different sources.<\/p><p>It also enables the creation of complex transformations through advanced scripting, for exceptional adaptability to different data transformation scenarios.<\/p><p>Error handling and debugging also facilitate the development process, enabling potential problems to be quickly identified and resolved.<\/p><p>In this way, the SDK transcends the limitations of Power Query and delivers a broader palette of tools. Let&#8217;s now take a look at the prerequisites and the various stages of its use&#8230;<\/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-5ea2cd4 e-flex e-con-boxed e-con\" data-id=\"5ea2cd4\" 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-065365b elementor-widget elementor-widget-heading\" data-id=\"065365b\" 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\">Installation and configuration: the quick and easy guide<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d646df7 elementor-widget elementor-widget-text-editor\" data-id=\"d646df7\" 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>Before starting the installation process, it&#8217;s imperative to ensure that the environment is correctly configured.<\/p><p>Technical prerequisites may vary depending on the specific application you&#8217;re using, such as <strong>Power BI or Excel<\/strong>, but there are some common elements that require particular attention.<\/p><p>First of all, make sure you have a compatible <strong>IDE<\/strong> installed, such as Visual Studio. Also check that your version of the host application is compatible with the version of the kit you intend to use.<\/p><p>Regular updates are crucial, not only to benefit from the latest features, but also for security patches.<\/p><p>Your environment must also have the necessary permissions to access the data sources you plan to integrate. This may include <a href=\"https:\/\/datascientest.com\/en\/refactoring-databases-and-code-comprehensive-guide-to-the-essentials\">databases,<\/a> APIs, or other systems.<\/p><p>If all these prerequisites are checked, the installation process can begin. First of all, visit the official Microsoft website or use the package management tools to download the latest <strong>version of the SDK<\/strong>.<\/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-7d4d987 elementor-widget elementor-widget-image\" data-id=\"7d4d987\" 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\/12\/power_query_sdk2.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-e3280df elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e3280df\" 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-scientist-course\">\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\">Find out more about our 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<div class=\"elementor-element elementor-element-1d97830 elementor-widget elementor-widget-text-editor\" data-id=\"1d97830\" 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>There are currently two versions of the Power Query SDK: <strong>Visual Studio Power Query SDK<\/strong> launched in 2017 as an extension to Visual Studio 2017 and 2019, and Visual Studio Code Power Query SDK (Preview) launched in 2022 and recommended for creating Power Query connectors.<\/p><p>Microsoft is now encouraging developers to install and use this new version, which will soon become the <strong>default SDK.<\/strong><\/p><p>However, if you would like to install the Visual Studio Power Query SDK, start by installing it from the Visual Studio Marketplace. Create a new data connector project, and define your logical connector. Build the project to produce an extension file.<\/p><p>To install the new<strong> Visual Studio Code Power Query<\/strong> SDK, available since September 2022, go to the Visual Studio Code section of the Visual Studio Marketplace. Select &#8220;Install&#8221; to initiate the process.<\/p><p>In addition, certain configuration parameters may be required to align the <strong>SDK<\/strong> with your development environment. These include authentication, authorizations and data source connections.<\/p><p>After installation, the crucial step is to configure the <strong>SDK<\/strong> according to the specific needs of the project. Connections to <a href=\"https:\/\/datascientest.com\/en\/data-sources-understanding-the-definition-and-inner-workings\">data sources<\/a> must be configured using available connectors, or by creating custom connectors if necessary.<\/p><p>Also define the appropriate security settings to protect sensitive data. And if your project requires advanced scripting, configure the parameters related to customization to meet the requirements!<\/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-90b13fd e-flex e-con-boxed e-con\" data-id=\"90b13fd\" 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-2d8d4c5 elementor-widget elementor-widget-heading\" data-id=\"2d8d4c5\" 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\">How do I create a Power Query connector?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73440bf elementor-widget elementor-widget-text-editor\" data-id=\"73440bf\" 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>Both <strong>SDK versions use a similar process for developing a high-level connector.<\/strong> When creating a new project or workspace, the same main files are used.<\/p><p>These are the connector definition file (&lt;connectorName&gt;.pq), a query file (&lt;connectorName&gt;.query.pq), a resource file (resources.resx) and PNG files of various sizes used to create icons.<\/p><p>The SDK provides basic query execution capabilities, enabling you to test your extension without having to switch to <a href=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\">Power BI Desktop.<\/a> In addition to the extension file, a query file (name.query.pq) can be used to run tests within Visual Studio.<\/p><p>Query evaluation automatically includes the extension code, without the need to save the .pqx file. It is therefore possible to call or test any function shared in the extension code.<\/p><p>The query file can contain a single expression, a let expression like the one Power Query generates, or a section document.<\/p><p>Building the project produces a ZIP file with a .mez extension. At runtime, Power BI Desktop loads extensions from the [Documents]\\Microsoft Power BI Desktop\\Custom Connectors folder.<\/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-a54be3f elementor-widget elementor-widget-image\" data-id=\"a54be3f\" 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\/12\/power_query_sdk3.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-de8b2c1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"de8b2c1\" 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-scientist-course\">\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\">Find out about our 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-3393243 e-flex e-con-boxed e-con\" data-id=\"3393243\" 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-1925aca elementor-widget elementor-widget-heading\" data-id=\"1925aca\" 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\">The Power Query SDK in the Microsoft ecosystem<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-34dbd84 elementor-widget elementor-widget-text-editor\" data-id=\"34dbd84\" 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>Power Query connectors created with the SDK can be used not only on Power BI Desktop, but also throughout the<strong> Power Query Online experience,<\/strong> and in particular with Power BI dataflows and datamarts.<\/p><p>On <strong>Power BI Desktop<\/strong>, simply copy the .mez or .pqx file extension to [Documents]\/Power BI Desktop\/Custom Connectors.<\/p><p>However, you need to go to the settings, File &gt; Options &gt; Security &gt; Data extensions and authorize the loading of any extension without validation. A restart of Power BI is required, and the extensions will be loaded immediately.<\/p><p>If you are the owner of the data source and connector, you can also submit your connector to the certification program so that it is delivered with Power BI Desktop with every update. On Power Query Online, only certified connectors are shown.<\/p><p>This <strong>SDK extends the data transformation capabilities of Power BI<\/strong>, and also meets the specific needs of Excel <a href=\"https:\/\/datascientest.com\/en\/xplenty-the-key-points-of-this-data-integration-system\">data integration.<\/a> It thus offers consistency between the various Microsoft tools.<\/p><p>What&#8217;s more, it can be used in Azure Data Factory to create complex data pipelines, facilitating large-scale transfer and transformation. During the integration process, it also helps automate ETL tasks.<\/p><p>It can also be used in conjunction with SQL Server for more robust data integration scenarios, and with many other analysis tools for data preparation&#8230;<\/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-166b816 e-flex e-con-boxed e-con\" data-id=\"166b816\" 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-6137ad1 elementor-widget elementor-widget-heading\" data-id=\"6137ad1\" 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\">Conclusion: a Power Query SDK to create your own connectors<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-71e75b0 elementor-widget elementor-widget-text-editor\" data-id=\"71e75b0\" 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 allowing you to <strong>customize your data connectors,<\/strong> this SDK extends the possibilities offered by Power Query and provides an unprecedented degree of flexibility.<\/p><p>To learn how to handle <strong>Power Query and all its subtleties,<\/strong> you can choose DataScientest. Our various online training courses will enable you to acquire real expertise!<\/p><p>Our Power BI curriculum covers Power Query, the M and DAX languages, Data Visualization and advanced concepts such as Dataflow and incremental updating.<\/p><p>The two parts of this training course can be completed in just five days full-time or 30 days part-time, and lead to the state-recognized &#8220;Analyzing Data with Microsoft Power BI&#8221; certification.<\/p><p>You will also be prepared to take the Microsoft PL-300 exam, included in the training, to acquire the official Power BI Data Analyst Associate certification.<\/p><p>We also offer a Microsoft Excel training program that lets you study at your own pace, with unlimited access to our learning platform for 3 months.<\/p><p>The program covers Power Query, pivot tables, task automation via macros, as well as conditional formatting and function libraries.<\/p><p>At the end of the course, you&#8217;ll be fully proficient in Excel and able to take the TOSA RS5252 exam, which is highly recognized on the job market.<\/p><p>Our Data Analyst, Data Management and Digital Marketing &amp; Data training courses also include Power Query and its SDK.<\/p><p>These courses, offered as BootCamp, continuing education or sandwich courses, give you all the skills you need to start working in Data Science.<\/p><p>All our courses are offered online, and our organization is eligible for funding options. Don&#8217;t waste another moment, and 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-51e23e8 elementor-widget elementor-widget-image\" data-id=\"51e23e8\" 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\/12\/power_query_sdk4.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-c9bd79d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c9bd79d\" 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-scientist-course\">\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\">See our 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<div class=\"elementor-element elementor-element-cb5006d elementor-widget elementor-widget-html\" data-id=\"cb5006d\" 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 the Power Query SDK?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The initials SDK stand for \"Software Development Kit\". In this case, it's a software toolkit developed by Microsoft to extend the functionality of Power Query.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"What is the purpose of the Power Query SDK?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The main use cases for the Power Query SDK include the creation of a view accessible to business analysts for a REST API. It can also be used to expose a filtered or limited view on your data source to improve ergonomics, or to enable DirectQuery for a data source using an ODBC driver. It also enables the creation of complex transformations through advanced scripting, for exceptional adaptability to different data transformation scenarios.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"The Power Query SDK in the Microsoft ecosystem\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The Power Query connectors created with the SDK can be used on Power BI Desktop, but also throughout the Power Query Online experience and in particular with Power BI dataflows and datamarts.\"\n    }\n  }]\n}\n<\/script>\n\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>The Power Query SDK is the development kit for Power Query, the Microsoft query engine found in Excel and Power BI. It lets you create customized connectors for data sources. Find out what it&#8217;s for and how to use it! To take full advantage of data and the valuable information it contains, professionals today need [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":183213,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"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 SDK: everything you need to know about this development kit<\/title>\n<meta name=\"description\" content=\"Power Query SDK provides developers with the tools and resources to extend and customize Power Query, enabling organizations to ...\" \/>\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-sdk-everything-you-need-to-know-about-this-development-kit\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query SDK: everything you need to know about this development kit\" \/>\n<meta property=\"og:description\" content=\"The Power Query SDK is the development kit for Power Query, the Microsoft query engine found in Excel and Power BI. It lets you create customized\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit\" \/>\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-03-18T07:46:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-14T20:15:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/illu_Power_Query_SDK-768x439-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"439\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"8 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-sdk-everything-you-need-to-know-about-this-development-kit#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query SDK: everything you need to know about this development kit\",\"datePublished\":\"2024-03-18T07:46:00+00:00\",\"dateModified\":\"2024-03-14T20:15:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit\"},\"wordCount\":1604,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit\",\"name\":\"Power Query SDK: everything you need to know about this development kit\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-18T07:46:00+00:00\",\"dateModified\":\"2024-03-14T20:15:54+00:00\",\"description\":\"Power Query SDK provides developers with the tools and resources to extend and customize Power Query, enabling organizations to ...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit\"]}]},{\"@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 SDK: everything you need to know about this development kit","description":"Power Query SDK provides developers with the tools and resources to extend and customize Power Query, enabling organizations to ...","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-sdk-everything-you-need-to-know-about-this-development-kit","og_locale":"en_GB","og_type":"article","og_title":"Power Query SDK: everything you need to know about this development kit","og_description":"The Power Query SDK is the development kit for Power Query, the Microsoft query engine found in Excel and Power BI. It lets you create customized","og_url":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-18T07:46:00+00:00","article_modified_time":"2024-03-14T20:15:54+00:00","og_image":[{"width":768,"height":439,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/illu_Power_Query_SDK-768x439-1.jpg","type":"image\/jpeg"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query SDK: everything you need to know about this development kit","datePublished":"2024-03-18T07:46:00+00:00","dateModified":"2024-03-14T20:15:54+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit"},"wordCount":1604,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit","url":"https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit","name":"Power Query SDK: everything you need to know about this development kit","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-18T07:46:00+00:00","dateModified":"2024-03-14T20:15:54+00:00","description":"Power Query SDK provides developers with the tools and resources to extend and customize Power Query, enabling organizations to ...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-sdk-everything-you-need-to-know-about-this-development-kit"]}]},{"@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\/183212"}],"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=183212"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/183212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/183213"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=183212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=183212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=183212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}