{"id":195334,"date":"2023-05-01T07:19:00","date_gmt":"2023-05-01T07:19:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=195334"},"modified":"2023-11-09T13:30:17","modified_gmt":"2023-11-09T13:30:17","slug":"langage-m-de-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/langage-m-de-power-query","title":{"rendered":"Langage M de Power Query : tout ce qu&rsquo;il faut savoir"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"195334\" class=\"elementor elementor-195334\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e334aed e-flex e-con-boxed e-con\" data-id=\"e334aed\" 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-c214542 elementor-widget elementor-widget-heading\" data-id=\"c214542\" 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\">Le langage de programmation M de Power Query permet d\u2019\u00e9crire des formules pour automatiser et personnaliser les transformations de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir !<\/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-00814de e-flex e-con-boxed e-con\" data-id=\"00814de\" 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-7af923d elementor-widget elementor-widget-text-editor\" data-id=\"7af923d\" 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><span style=\"font-weight: 400;\">Afin d\u2019extraire et transformer les donn\u00e9es, les utilisateurs de <a href=\"https:\/\/datascientest.com\/formation-excel\">Microsoft Excel<\/a> et <a href=\"https:\/\/datascientest.com\/power-bi-pour-les-nuls\">Power BI<\/a> peuvent utiliser l\u2019outil Power Query directement incorpor\u00e9 \u00e0 ces logiciels.<\/span><\/p><p><span style=\"font-weight: 400;\">\u00c0 l\u2019aide d\u2019un <strong>\u00e9diteur de requ\u00eates tr\u00e8s simple et intuitif<\/strong>, il est possible de collecter des donn\u00e9es en provenance d\u2019une large vari\u00e9t\u00e9 de sources et de les formater pour les rendre exploitables pour l\u2019analyse.<\/span><\/p><p><span style=\"font-weight: 400;\">Toutefois, pour personnaliser et automatiser les processus de <strong>transformation de donn\u00e9es<\/strong>, ou pour effectuer des <strong>transformations complexes<\/strong>, il est n\u00e9cessaire d\u2019utiliser le langage de programmation M.<\/span><\/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-520b932 e-flex e-con-boxed e-con\" data-id=\"520b932\" 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-94ee4e0 elementor-widget elementor-widget-heading\" data-id=\"94ee4e0\" 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\">Qu\u2019est-ce que le langage M ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fbda992 elementor-widget elementor-widget-text-editor\" data-id=\"fbda992\" 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><span style=\"font-weight: 400;\">D\u00e9velopp\u00e9 pour fournir aux utilisateurs de Power Query une <strong>interface simple de transformation de donn\u00e9es<\/strong>, M est un langage de programmation fonctionnel.<\/span><\/p><p><span style=\"font-weight: 400;\">Il se base sur une syntaxe claire et concise, ce qui facilite <strong>l\u2019\u00e9criture de requ\u00eates personnalis\u00e9es<\/strong>. Au fil des nouvelles versions, ce langage a \u00e9volu\u00e9 pour offrir des fonctionnalit\u00e9s plus avanc\u00e9es et de meilleures performances.<\/span><\/p><p><span style=\"font-weight: 400;\">Il s\u2019agit aujourd\u2019hui d\u2019un \u00e9l\u00e9ment essentiel de Power Query. On l\u2019utilise notamment pour les transformations complexes comme la <strong>fusion<\/strong>, la <strong>jointure<\/strong>, la <strong>division de colonnes<\/strong> ou encore l\u2019<strong>agr\u00e9gation<\/strong> et la <strong>r\u00e9organisation<\/strong> <strong>de donn\u00e9es<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">Par ailleurs, M permet aussi d\u2019\u00e9crire des <strong>requ\u00eates personnalis\u00e9es<\/strong>. Ceci peut servir \u00e0 extraire des donn\u00e9es \u00e0 partir de sources non prises en charge par Power Query, ou encore \u00e0 appliquer des transformations avanc\u00e9es pour r\u00e9pondre aux besoins sp\u00e9cifiques d\u2019une entreprise.<\/span><\/p><p><span style=\"font-weight: 400;\">En cas d\u2019erreurs lors d\u2019une transformation de donn\u00e9es, <strong>le langage M fournit des m\u00e9canismes de gestion<\/strong>. Il est possible de d\u00e9finir des r\u00e8gles comme la suppression des lignes contenant des valeurs manquantes, ou leur remplacement par des valeurs par d\u00e9faut.<\/span><\/p><p><span style=\"font-weight: 400;\">Enfin, les utilisateurs peuvent exploiter M pour <strong>optimiser les requ\u00eates<\/strong> en \u00e9liminant les op\u00e9rations inutiles et en r\u00e9duisant la taille des donn\u00e9es trait\u00e9es. Ceci permet d\u2019am\u00e9liorer les performances.<\/span><\/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-96d36cb e-flex e-con-boxed e-con\" data-id=\"96d36cb\" 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-fecb562 elementor-widget elementor-widget-heading\" data-id=\"fecb562\" 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\">Les principaux types de formules M<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a61c66b elementor-widget elementor-widget-text-editor\" data-id=\"a61c66b\" 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><span style=\"font-weight: 400;\">Ce langage M offre <strong>une large vari\u00e9t\u00e9 de formules de transformation de donn\u00e9es<\/strong>, r\u00e9pondant \u00e0 diff\u00e9rents cas d\u2019utilisation.<\/span><\/p><p><span style=\"font-weight: 400;\">Les formules de filtrage sont utilis\u00e9es pour filtrer les donn\u00e9es selon des crit\u00e8res sp\u00e9cifiques. Par exemple, \u00ab <strong>Filter Rows<\/strong> \u00bb se base sur la valeur d\u2019une colonne.<\/span><\/p><p><span style=\"font-weight: 400;\">On utilise aussi les formules de fusion pour combiner des donn\u00e9es provenant de plusieurs sources. Ainsi, \u00ab <strong>Merge Queries<\/strong> \u00bb permet de fusionner deux requ\u00eates en utilisant une colonne commune.<\/span><\/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-ae5d840 elementor-widget elementor-widget-image\" data-id=\"ae5d840\" 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\t\t\t<img decoding=\"async\" width=\"900\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query-1.png\" class=\"attachment-full size-full wp-image-195352\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query-1.png 900w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query-1-300x167.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/fusion-requete-power-query-1-768x427.png 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/>\t\t\t\t\t\t\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-9bbf4f0 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9bbf4f0\" 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\/formation-power-bi\">\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\">D\u00e9marrer une formation Power BI<\/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-c50234e elementor-widget elementor-widget-text-editor\" data-id=\"c50234e\" 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><span style=\"font-weight: 400;\">Pour la transformation, \u00ab <strong>Split Colum<\/strong> \u00bb permet par exemple de diviser une colonne en plusieurs. Il existe de nombreuses formules de cette cat\u00e9gorie permettant tous types de manipulations.<\/span><\/p><p><span style=\"font-weight: 400;\">Afin d\u2019effectuer des op\u00e9rations sur les donn\u00e9es, on peut utiliser les formules de calcul. Par exemple, \u00ab <strong>Add Column<\/strong> \u00bb permet d\u2019ajouter une colonne calcul\u00e9e \u00e0 une requ\u00eate.<\/span><\/p><p><span style=\"font-weight: 400;\">Enfin, il est possible de regrouper les donn\u00e9es en fonction de crit\u00e8res sp\u00e9cifiques \u00e0 l\u2019aide des formules de groupement. Par exemple, \u00ab<strong> Group By<\/strong> \u00bb rassemble les donn\u00e9es en fonction de la valeur d\u2019une colonne.<\/span><\/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-a707b80 e-flex e-con-boxed e-con\" data-id=\"a707b80\" 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-c33859d elementor-widget elementor-widget-heading\" data-id=\"c33859d\" 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\">Quels sont les avantages et inconv\u00e9nients du langage M ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a83c1f elementor-widget elementor-widget-text-editor\" data-id=\"2a83c1f\" 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><span style=\"font-weight: 400;\">Les principaux points forts du langage M sont la <strong>flexibilit\u00e9<\/strong> et la personnalisation des transformations de donn\u00e9es.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Il est possible de cr\u00e9er des transformations complexes, afin de <strong>r\u00e9pondre \u00e0 des besoins sp\u00e9cifiques<\/strong>. De plus, l&rsquo;automatisation est un autre avantage majeur.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">En effet, les utilisateurs peuvent \u00e9crire des requ\u00eates personnalis\u00e9es qui s\u2019ex\u00e9cutent automatiquement chaque fois qu\u2019une nouvelle source de donn\u00e9es est ajout\u00e9e. Ceci permet d\u2019<strong>\u00e9conomiser un temps consid\u00e9rable<\/strong>, mais aussi de r\u00e9duire les erreurs.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">L\u2019optimisation des requ\u00eates offre par ailleurs un <strong>gain de temps<\/strong> puisqu\u2019elle permet d\u2019obtenir des r\u00e9sultats plus rapidement et de traiter des volumes de donn\u00e9es plus importants.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">En revanche, malgr\u00e9 ses nombreuses forces, <strong>le langage M pr\u00e9sente des limites<\/strong>. D\u2019abord, la moindre erreur de syntaxe peut emp\u00eacher le fonctionnement d\u2019une requ\u00eate personnalis\u00e9e. Ceci peut s\u2019av\u00e9rer d\u00e9routant pour les d\u00e9butants.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Dans certaines situations, M n\u2019est pas adapt\u00e9. C\u2019est notamment le cas pour <strong>les calculs complexes ou les analyses statistiques avanc\u00e9es qui n\u00e9cessitent d\u2019autres outils<\/strong>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">De mani\u00e8re g\u00e9n\u00e9rale, ce puissant outil accro\u00eet les possibilit\u00e9s offertes par Power Query mais <strong>requiert une connaissance de base en programmation<\/strong>.<\/span><\/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-659ab26 e-flex e-con-boxed e-con\" data-id=\"659ab26\" 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-b5f8b97 elementor-widget elementor-widget-heading\" data-id=\"b5f8b97\" 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 : le langage M de Power Query, un outil puissant mais exigeant<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e4194fb elementor-widget elementor-widget-text-editor\" data-id=\"e4194fb\" 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><span style=\"font-weight: 400;\">Si Power Query est <strong>un outil accessible et simple d\u2019utilisation<\/strong>, il peut se r\u00e9v\u00e9ler trop restreint pour certaines t\u00e2ches de business intelligence. Le langage M permet de surmonter ses limites, en offrant des possibilit\u00e9s de personnalisation et d\u2019automatisation.<\/span><\/p><p><span style=\"font-weight: 400;\">Il garantit aussi <strong>une coh\u00e9rence dans le traitement des donn\u00e9es<\/strong>, puisque chaque transformation peut \u00eatre appliqu\u00e9e \u00e0 toutes les donn\u00e9es.<\/span><\/p><p><span style=\"font-weight: 400;\">Toutefois, ce puissant instrument requiert des comp\u00e9tences techniques plus approfondies. Afin d\u2019apprendre \u00e0 <strong>ma\u00eetriser Power Query<\/strong> et toutes ses subtilit\u00e9s, vous pouvez choisir la<strong> formation Power BI de DataScientest<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">En seulement <strong>5 jours<\/strong>, ce cursus permet d\u2019apprendre \u00e0 <strong>collecter<\/strong>, <strong>transformer<\/strong>, <strong>analyser les donn\u00e9es<\/strong> et <a href=\"https:\/\/datascientest.com\/comment-creer-un-tableau-de-bord-dans-power-bi\">cr\u00e9er des tableaux de bord<\/a> interactifs avec Power BI.<\/span><\/p><p><span style=\"font-weight: 400;\">Vous d\u00e9couvrirez Power Query et ses fonctions, les langages M et <a href=\"https:\/\/datascientest.com\/dax-power-bi\">DAX<\/a>, les fonctionnalit\u00e9s de <a href=\"https:\/\/datascientest.com\/quest-ce-la-dataviz-le-point-avec-nos-data-experts\">DataViz<\/a>, ou encore les concepts de <a href=\"https:\/\/datascientest.com\/dataflow-power-bi\">DataFlows<\/a> et d\u2019<strong>actualisation incr\u00e9mentielle<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">En fin de parcours, DataScientest vous propose de passer l\u2019<a href=\"https:\/\/datascientest.com\/cours-power-bi\">examen officiel Microsoft PL-300<\/a> afin d\u2019<a href=\"https:\/\/datascientest.com\/pl-300-tout-savoir\">obtenir la certification Power BI Data Analyst Associate<\/a>.<\/span><\/p><p><span style=\"font-weight: 400;\">Toutes nos formations s\u2019effectuent int\u00e9gralement \u00e0 distance, et sont \u00e9ligibles au <a href=\"https:\/\/datascientest.com\/cpf-definition-utlisation\">CPF<\/a> pour le financement. <strong>D\u00e9couvrez DataScientest !<\/strong><\/span><\/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-bd50153 elementor-widget elementor-widget-image\" data-id=\"bd50153\" 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\t\t\t<img decoding=\"async\" width=\"1099\" height=\"568\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/formation-power-query.jpg\" class=\"attachment-full size-full wp-image-195355\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/formation-power-query.jpg 1099w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/formation-power-query-300x155.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/formation-power-query-1024x529.jpg 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/formation-power-query-768x397.jpg 768w\" sizes=\"(max-width: 1099px) 100vw, 1099px\" \/>\t\t\t\t\t\t\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-24a31cc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"24a31cc\" 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\/formation-power-bi\">\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\">Je m'inscris \u00e0 la formation Power BI<\/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-2ee9b7b elementor-widget elementor-widget-text-editor\" data-id=\"2ee9b7b\" 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><span style=\"font-weight: 400;\">Vous savez tout sur le langage M de Power Query. Pour aller plus loin sur le m\u00eame sujet, d\u00e9couvrez <a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\">notre dossier sur Power Query<\/a> et <a href=\"https:\/\/datascientest.com\/power-bi\">notre dossier complet sur Power BI<\/a>.<\/span><\/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-7fbd173 e-flex e-con-boxed e-con\" data-id=\"7fbd173\" 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-fbde82b elementor-widget elementor-widget-html\" data-id=\"fbde82b\" 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\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu\u2019est-ce que le langage M ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"D\u00e9velopp\u00e9 pour fournir aux utilisateurs de Power Query une interface simple de transformation de donn\u00e9es, M est un langage de programmation fonctionnel. Il se base sur une syntaxe claire et concise, ce qui facilite l\u2019\u00e9criture de requ\u00eates personnalis\u00e9es. Au fil des nouvelles versions, ce langage a \u00e9volu\u00e9 pour offrir des fonctionnalit\u00e9s plus avanc\u00e9es et de meilleures performances.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Quels sont les avantages et inconv\u00e9nients du langage M ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les principaux points forts du langage M sont la flexibilit\u00e9 et la personnalisation des transformations de donn\u00e9es. Il est possible de cr\u00e9er des transformations complexes, afin de r\u00e9pondre \u00e0 des besoins sp\u00e9cifiques. De plus, l'automatisation est un autre avantage majeur. En effet, les utilisateurs peuvent \u00e9crire des requ\u00eates personnalis\u00e9es qui s\u2019ex\u00e9cutent automatiquement chaque fois qu\u2019une nouvelle source de donn\u00e9es est ajout\u00e9e. Ceci permet d\u2019\u00e9conomiser un temps consid\u00e9rable, mais aussi de r\u00e9duire les erreurs.\"\r\n    }\r\n  }]\r\n}\r\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>Le langage de programmation M de Power Query permet d\u2019\u00e9crire des formules pour automatiser et personnaliser les transformations de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir ! Afin d\u2019extraire et transformer les donn\u00e9es, les utilisateurs de Microsoft Excel et Power BI peuvent utiliser l\u2019outil Power Query directement incorpor\u00e9 \u00e0 [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":195341,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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>Langage M de Power Query : tout ce qu&#039;il faut savoir<\/title>\n<meta name=\"description\" content=\"Le langage de programmation M de Power Query permet d\u2019\u00e9crire des formules pour automatiser et personnaliser les transformations de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir !\" \/>\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\/langage-m-de-power-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Langage M de Power Query : tout ce qu&#039;il faut savoir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/langage-m-de-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-01T07:19:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/langage-m-datascientest.png\" \/>\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\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/langage-m-de-power-query\",\"url\":\"https:\/\/datascientest.com\/langage-m-de-power-query\",\"name\":\"Langage M de Power Query : tout ce qu'il faut savoir\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-05-01T07:19:00+00:00\",\"dateModified\":\"2023-11-09T13:30:17+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Le langage de programmation M de Power Query permet d\u2019\u00e9crire des formules pour automatiser et personnaliser les transformations de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir !\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/langage-m-de-power-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Langage M de Power Query : tout ce qu'il faut savoir","description":"Le langage de programmation M de Power Query permet d\u2019\u00e9crire des formules pour automatiser et personnaliser les transformations de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir !","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\/langage-m-de-power-query","og_locale":"fr_FR","og_type":"article","og_title":"Langage M de Power Query : tout ce qu'il faut savoir","og_url":"https:\/\/datascientest.com\/langage-m-de-power-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-05-01T07:19:00+00:00","article_modified_time":"2023-11-09T13:30:17+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/langage-m-datascientest.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/langage-m-de-power-query","url":"https:\/\/datascientest.com\/langage-m-de-power-query","name":"Langage M de Power Query : tout ce qu'il faut savoir","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-05-01T07:19:00+00:00","dateModified":"2023-11-09T13:30:17+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Le langage de programmation M de Power Query permet d\u2019\u00e9crire des formules pour automatiser et personnaliser les transformations de donn\u00e9es sur Excel et Power BI. D\u00e9couvrez tout ce que vous devez savoir !","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/langage-m-de-power-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/195334"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=195334"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/195334\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/195341"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=195334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=195334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=195334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}