{"id":218478,"date":"2023-11-01T05:30:00","date_gmt":"2023-11-01T05:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=218478"},"modified":"2023-11-09T13:30:07","modified_gmt":"2023-11-09T13:30:07","slug":"gestion-erreurs-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/gestion-erreurs-power-query","title":{"rendered":"Power Query : Comment fonctionne la gestion des erreurs ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"218478\" class=\"elementor elementor-218478\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7fb78ae e-flex e-con-boxed e-con\" data-id=\"7fb78ae\" 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-c8da40c elementor-widget elementor-widget-heading\" data-id=\"c8da40c\" 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\">#NULL!, #REF!, #DIV\/0!, N\/A \u2026. Les tableaux de donn\u00e9es contiennent r\u00e9guli\u00e8rement des erreurs limitant l\u2019analyse des donn\u00e9es. Heureusement, il est possible de les corriger \u00e0 travers une bonne gestion des erreurs dans Power Query. DataScientest vous explique justement comment faire. <\/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-7faa287 e-flex e-con-boxed e-con\" data-id=\"7faa287\" 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-a22366f elementor-widget elementor-widget-heading\" data-id=\"a22366f\" 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\">La gestion des erreurs dans Power Query<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2ae4ea3 elementor-widget elementor-widget-text-editor\" data-id=\"2ae4ea3\" 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<a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\"><span style=\"font-weight: 400;\">L\u2019\u00e9diteur de requ\u00eates Power Query<\/a> conna\u00eet deux grands types d\u2019erreurs : celles au niveau de l\u2019\u00e9tape ou de la colonne. <\/span>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c31648 elementor-widget elementor-widget-heading\" data-id=\"6c31648\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Au niveau de l\u2019\u00e9tape<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bef14d0 elementor-widget elementor-widget-text-editor\" data-id=\"bef14d0\" 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 une erreur se situe au niveau de l\u2019\u00e9tape, la requ\u00eate ne peut pas se charger. Vous verrez alors <\/span><b>un message d\u2019erreur appara\u00eetre<\/b><span style=\"font-weight: 400;\"> dans une fen\u00eatre jaune. Celle-ci vous renseigne sur les diff\u00e9rents composants de l\u2019erreur, \u00e0 savoir la raison, le message et le d\u00e9tail. Et si vous souhaitez plus d\u2019informations, il est aussi possible de cliquer sur le bouton \u201c<\/span><b>Acc\u00e9der \u00e0 l\u2019erreur<\/b><span style=\"font-weight: 400;\">\u201d. Ce sont toutes ces donn\u00e9es qui vous permettent d\u2019adopter une gestion efficace des erreurs dans Power Query.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici maintenant les erreurs les plus courantes :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Source introuvable :<\/b><span style=\"font-weight: 400;\"> cette erreur appara\u00eet si vous ne pouvez acc\u00e9der \u00e0 la <a href=\"https:\/\/datascientest.com\/definition-data-source\">source de donn\u00e9es<\/a>, si vous ne <\/span><span style=\"font-weight: 400;\">disposez pas des informations d\u2019identification ou si la source a \u00e9t\u00e9 d\u00e9plac\u00e9e. Dans un tel cas, il convient de modifier le chemin d\u2019acc\u00e8s.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Colonne introuvable <\/b><span style=\"font-weight: 400;\">: c\u2019est ce qui se passe si vous avez mentionn\u00e9 une colonne qui n\u2019existe pas dans la requ\u00eate. Ici, plusieurs solutions sont possibles, notamment la suppression de l\u2019\u00e9tape faisant r\u00e9f\u00e9rence \u00e0 ladite colonne.\u00a0<\/span><\/li><li><b>Formula.Firewall<\/b><span style=\"font-weight: 400;\"> : cette erreur survient lorsque vous combinez ou fusionnez des donn\u00e9es entre plusieurs sources. Avant d\u2019appliquer une solution, il convient de comprendre l\u2019origine exacte du probl\u00e8me en acc\u00e9dant au pare-feu de confidentialit\u00e9 des donn\u00e9es.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-760beae elementor-widget elementor-widget-heading\" data-id=\"760beae\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Au niveau des colonnes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9462b6d elementor-widget elementor-widget-text-editor\" data-id=\"9462b6d\" 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;\">Dans cette hypoth\u00e8se, la requ\u00eate se charge, mais<\/span><b> la valeur appara\u00eet sous forme d\u2019erreur<\/b><span style=\"font-weight: 400;\"> dans la cellule correspondante. Pour comprendre l\u2019origine de l\u2019erreur, vous pouvez cliquer sur l\u2019espace blanc de la cellule concern\u00e9e (une nouvelle fen\u00eatre jaune appara\u00eetra) ou utiliser les outils de profilage des donn\u00e9es. Ces erreurs peuvent \u00eatre li\u00e9es \u00e0 un probl\u00e8me de conversion du <a href=\"https:\/\/datascientest.com\/type-de-donnes-ou-data-type\">type de donn\u00e9es<\/a>, des op\u00e9rations non prises en charge, <\/span><span style=\"font-weight: 400;\">des valeurs structur\u00e9es imbriqu\u00e9es, etc.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Quel que soit le probl\u00e8me, vous disposez de plusieurs solutions de gestion des erreurs avec Power Query. \u00c0 savoir :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>La suppression des erreurs <\/b><span style=\"font-weight: 400;\">: s\u00e9lectionnez la colonne concern\u00e9e puis rendez-vous dans<\/span><span style=\"font-weight: 400;\"> le groupe \u00ab\u00a0R\u00e9duire les lignes\u00a0\u00bb sous l\u2019onglet \u201cAccueil\u201d. Cliquez sur \u00ab\u00a0Supprimer les lignes\u00a0\u00bb, puis sur \u00ab\u00a0Supprimer les erreurs\u00a0\u00bb.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Le remplacement des erreurs : <\/b><span style=\"font-weight: 400;\">s\u00e9lectionnez la colonne concern\u00e9e puis rendez-vous dans<\/span><span style=\"font-weight: 400;\"> le groupe \u00ab\u00a0N\u2019importe quelle colonne\u00a0\u00bb sous l\u2019onglet \u00ab\u00a0Transformer\u00a0\u00bb. Cliquez sur \u201cRemplacer les valeurs\u201d, puis sur \u00ab\u00a0Remplacer les erreurs\u00a0\u00bb. Renseignez ensuite la nouvelle valeur (comme un nombre entier, un texte personnalis\u00e9\u2026).\u00a0<\/span><\/li><li><b>La conservation des erreurs<\/b><span style=\"font-weight: 400;\"> : cela vous permet d\u2019identifier plus facilement les lignes contenant des erreurs. La manipulation est la suivante :\u00a0 <em>Accueil &gt; R\u00e9duire les lignes &gt; Conserver les lignes &gt; Conserver les erreurs<\/em>.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c26a85 elementor-widget elementor-widget-image\" data-id=\"7c26a85\" 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=\"725\" height=\"600\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query1.jpg\" class=\"attachment-full size-full wp-image-218502\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query1.jpg 725w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query1-300x248.jpg 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/>\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-d60766a elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"d60766a\" 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\">Apprendre \u00e0 g\u00e9rer les erreurs dans 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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-349ccdd e-flex e-con-boxed e-con\" data-id=\"349ccdd\" 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-2101676 elementor-widget elementor-widget-heading\" data-id=\"2101676\" 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\">La gestion personnalis\u00e9e des erreurs sur l\u2019\u00e9diteur de requ\u00eate<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc1ea91 elementor-widget elementor-widget-text-editor\" data-id=\"cc1ea91\" 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;\">Au-del\u00e0 des solutions susmentionn\u00e9es, il est aussi possible de g\u00e9rer les erreurs avec l\u2019\u00e9diteur Power Query en adoptant sa propre logique.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici comment faire :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Remplacer une erreur par une autre valeur<\/b><span style=\"font-weight: 400;\"> : pour cela, il suffit d\u2019ajouter une colonne personnalis\u00e9e en pr\u00e9voyant diff\u00e9rentes options. Ainsi, dans la <\/span><span style=\"font-weight: 400;\">fen\u00eatre \u00ab\u00a0Colonne personnalis\u00e9e\u00a0\u00bb, vous pouvez entrez la requ\u00eate :<\/span><pre><span style=\"font-weight: 400;\">try [colonne-1] otherwise [Colonne-2]<\/span><\/pre><span style=\"font-weight: 400;\">Si aucune erreur n\u2019est trouv\u00e9e dans la colonne-1, ce sont ses donn\u00e9es qui appara\u00eetront. \u00c0 d\u00e9faut, ce sont les donn\u00e9es de la colonne-2.<\/span><\/li><li><b>Personnaliser les nouveaux r\u00e9sultats <\/b><span style=\"font-weight: 400;\">: l\u00e0 encore, vous devez utiliser la colonne personnalis\u00e9e, mais la requ\u00eate diff\u00e8re :<\/span><pre><span style=\"font-weight: 400;\">try [colonne-1] catch (r)=&gt; if r[Message] &lt;&gt; \"Invalid cell value '#REF!'.\" then [colonne-2] else null. <\/span><\/pre><span style=\"font-weight: 400;\">Dans ce cas, la colonne-1 ne sera remplac\u00e9e par la colonne-2 que si le message d\u2019erreur est diff\u00e9rent de #REF! ( #NULL! ou #DIV\/0!). \u00c0 d\u00e9faut, la colonne-1 sera remplac\u00e9e par \u201cnull\u201d.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-19e1756 elementor-widget elementor-widget-text-editor\" data-id=\"19e1756\" 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<span style=\"font-weight: 400;\">Pour g\u00e9rer efficacement toutes ces erreurs avec Power Query, mieux vaut se former. C\u2019est justement possible avec DataScientest. \u00c0 travers nos programmes, vous apprendrez \u00e0 ma\u00eetriser l\u2019\u00e9diteur de requ\u00eate et de nombreuses tables de donn\u00e9es. <a href=\"https:\/\/datascientest.com\/formations-data\">Rejoignez nos formations<\/a>. <\/span>\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-fdf6d79 e-flex e-con-boxed e-con\" data-id=\"fdf6d79\" 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-4af42dc elementor-widget elementor-widget-heading\" data-id=\"4af42dc\" 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\">Ce qu\u2019il faut retenir : <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99b7023 elementor-widget elementor-widget-text-editor\" data-id=\"99b7023\" 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<ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Au vu des volumes de donn\u00e9es regroup\u00e9es au sein d\u2019une table, les erreurs sont tr\u00e8s courantes. Ce qui peut limiter le traitement et l\u2019analyse des donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Heureusement, une gestion des erreurs efficaces est possible avec Power Query.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">L\u2019\u00e9diteur de requ\u00eate pr\u00e9voit plusieurs manipulations pour corriger les bugs en fonction du type d\u2019erreur.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vous pouvez aussi personnaliser les options de correction en fonction de vos besoins.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2c386d elementor-widget elementor-widget-image\" data-id=\"a2c386d\" 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=\"754\" height=\"600\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query2.jpg\" class=\"attachment-full size-full wp-image-218506\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query2.jpg 754w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query2-300x239.jpg 300w\" sizes=\"(max-width: 754px) 100vw, 754px\" \/>\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-06c3bf1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"06c3bf1\" 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\">Suivre une formation 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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d32f001 e-flex e-con-boxed e-con\" data-id=\"d32f001\" 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\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>#NULL!, #REF!, #DIV\/0!, N\/A \u2026. Les tableaux de donn\u00e9es contiennent r\u00e9guli\u00e8rement des erreurs limitant l\u2019analyse des donn\u00e9es. Heureusement, il est possible de les corriger \u00e0 travers une bonne gestion des erreurs dans Power Query. DataScientest vous explique justement comment faire. La gestion des erreurs dans Power Query L\u2019\u00e9diteur de requ\u00eates Power Query conna\u00eet deux grands [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":218490,"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>Power Query : Comment fonctionne la gestion des erreurs ?<\/title>\n<meta name=\"description\" content=\"Pour traiter vos donn\u00e9es efficacement, la gestion des erreurs avec Power Query s\u2019av\u00e8re indispensable. D\u00e9couvrez comment faire.\" \/>\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\/gestion-erreurs-power-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query : Comment fonctionne la gestion des erreurs ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/gestion-erreurs-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-01T05:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:30:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query.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=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/gestion-erreurs-power-query\",\"url\":\"https:\/\/datascientest.com\/gestion-erreurs-power-query\",\"name\":\"Power Query : Comment fonctionne la gestion des erreurs ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-11-01T05:30:00+00:00\",\"dateModified\":\"2023-11-09T13:30:07+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Pour traiter vos donn\u00e9es efficacement, la gestion des erreurs avec Power Query s\u2019av\u00e8re indispensable. D\u00e9couvrez comment faire.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/gestion-erreurs-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":"Power Query : Comment fonctionne la gestion des erreurs ?","description":"Pour traiter vos donn\u00e9es efficacement, la gestion des erreurs avec Power Query s\u2019av\u00e8re indispensable. D\u00e9couvrez comment faire.","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\/gestion-erreurs-power-query","og_locale":"fr_FR","og_type":"article","og_title":"Power Query : Comment fonctionne la gestion des erreurs ?","og_url":"https:\/\/datascientest.com\/gestion-erreurs-power-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-11-01T05:30:00+00:00","article_modified_time":"2023-11-09T13:30:07+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/erreurs_Power_Query.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/gestion-erreurs-power-query","url":"https:\/\/datascientest.com\/gestion-erreurs-power-query","name":"Power Query : Comment fonctionne la gestion des erreurs ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-11-01T05:30:00+00:00","dateModified":"2023-11-09T13:30:07+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Pour traiter vos donn\u00e9es efficacement, la gestion des erreurs avec Power Query s\u2019av\u00e8re indispensable. D\u00e9couvrez comment faire.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/gestion-erreurs-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\/218478"}],"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=218478"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/218478\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/218490"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=218478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=218478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=218478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}