{"id":182564,"date":"2024-03-27T03:03:00","date_gmt":"2024-03-27T02:03:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=182564"},"modified":"2024-03-10T15:40:38","modified_gmt":"2024-03-10T14:40:38","slug":"power-query-error-handling-how-does-error-handling-work","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work","title":{"rendered":"Power Query Error Handling: How does error handling work?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"182564\" class=\"elementor elementor-182564\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d248d6 e-flex e-con-boxed e-con\" data-id=\"6d248d6\" 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-3e567df elementor-widget elementor-widget-heading\" data-id=\"3e567df\" 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 .... Data tables regularly contain errors that limit data analysis. Fortunately, it's possible to correct them through Power Query Error Handling. DataScientest shows you how.<\/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-658a600 e-flex e-con-boxed e-con\" data-id=\"658a600\" 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-a3c64c1 elementor-widget elementor-widget-heading\" data-id=\"a3c64c1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\"> Power Query Error Handling<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-083c29f elementor-widget elementor-widget-text-editor\" data-id=\"083c29f\" 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>There are two main types of error in the<a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\"> Power Query<\/a> editor: step and column errors.<\/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-fddee8a elementor-widget elementor-widget-heading\" data-id=\"fddee8a\" 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\">Stage level<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83a050e elementor-widget elementor-widget-text-editor\" data-id=\"83a050e\" 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>If an error occurs in the step, the request cannot be loaded. You will then see an error message appear in a yellow window.<\/p><p>This provides information on the various components of the error: reason, message and details<\/p><p>And if you need more information, you can also click on the &#8220;Access error&#8221; button. It&#8217;s all this data that enables you to adopt effective error management in <strong>Power Query.<\/strong><\/p><p>Here are the most common errors:<\/p><ul><li><strong>Source not found:<\/strong> this error appears if you can&#8217;t access the data source, if you don&#8217;t have identification information or if the source has been moved. In such cases, you should modify the access path.<\/li><li><strong>Column not found:<\/strong> this is what happens if you&#8217;ve specified a column that doesn&#8217;t exist in the query. There are several possible solutions here, including deleting the step referring to the column in question.<\/li><li><strong>Formula.firewall:<\/strong> this error occurs when you combine or merge data from several sources. Before applying a solution, you need to understand the exact cause of the problem by accessing the data confidentiality firewall.<\/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-d019695 elementor-widget elementor-widget-heading\" data-id=\"d019695\" 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\">Column level<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f6fee3 elementor-widget elementor-widget-text-editor\" data-id=\"4f6fee3\" 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>In this case, the <strong>query loads, but the value appears as an error in the corresponding cell.<\/strong> To understand the origin of the error, you can click on the white space of the cell concerned (a new yellow window will appear) or use the data profiling tools.<\/p><p>These errors can be linked to a data type conversion problem, unsupported operations, nested structured values, etc.<\/p><p>Whatever the problem, there are a number of error management solutions available with<strong> Power Query.<\/strong> Here&#8217;s what you need to know:<\/p><ul><li><strong>Deleting errors:<\/strong> select the column concerned, then go to the &#8220;Reduce rows&#8221; group under the &#8220;Home&#8221; tab. Click on &#8220;Delete rows&#8221;, then on &#8220;Delete errors&#8221;.<\/li><li><strong>Replacing errors:<\/strong> select the column concerned, then go to the &#8220;Any column&#8221; group under the &#8220;Transform&#8221; tab. Click on &#8220;Replace values&#8221;, then on &#8220;Replace errors&#8221;. Then enter the new value (as an integer, custom text, etc.).<\/li><li><strong>Keeping errors:<\/strong> this makes it easier to identify lines containing errors. The procedure is as follows: Home &gt; Reduce lines &gt; Keep lines &gt; Keep errors.<\/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-90d5961 elementor-widget elementor-widget-image\" data-id=\"90d5961\" 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\/10\/erreurs_Power_Query1.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-f2e4b25 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"f2e4b25\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn how to handle errors in 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-8a7948f e-flex e-con-boxed e-con\" data-id=\"8a7948f\" 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-4ad0b24 elementor-widget elementor-widget-heading\" data-id=\"4ad0b24\" 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\">Customized  Power Query Error Handling<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bbf8217 elementor-widget elementor-widget-text-editor\" data-id=\"bbf8217\" 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;\">Beyond the above solutions, it&#8217;s also possible to handle errors with the <strong>Power Query editor<\/strong> by adopting its own logic. <\/span><\/p><p><span style=\"font-weight: 400;\">Here&#8217;s how to do it:<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>Replace an error with another value<\/b><span style=\"font-weight: 400;\">: to do this, simply add a custom column with different options. So, in the <\/span><span style=\"font-weight: 400;\">&#8220;Custom column&#8221; window, you can enter the query:<\/span><pre><span style=\"font-weight: 400;\">try [column-1] otherwise [Column-2]<\/span><\/pre><p><span style=\"font-weight: 400;\">If no error is found in column-1, its data will appear. Otherwise, the data in column-2 will appear.<\/span><\/p><\/li><li><b>Customize new results <\/b><span style=\"font-weight: 400;\">: again, you need to use the custom column, but the query differs:<\/span><pre><span style=\"font-weight: 400;\">try [column-1] catch (r)=&gt; if r[Message] &lt;&gt; \"Invalid cell value '#REF!'.\" then [column-2] else null. <\/span><\/pre><p><span style=\"font-weight: 400;\">In this case, column-1 will be replaced by column-2 only if the error message is different from #REF! ( #NULL! or #DIV\/0!). Otherwise, column-1 will be replaced by &#8220;null&#8221;.<\/span><\/p><\/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-4dfb9d7 elementor-widget elementor-widget-text-editor\" data-id=\"4dfb9d7\" 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>To effectively manage all these errors with Power Query, it&#8217;s best to get trained. With DataScientest, you can do just that. Through our programs, you&#8217;ll learn to master the query editor and numerous data tables. Join our training courses.<\/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-2dadf88 e-flex e-con-boxed e-con\" data-id=\"2dadf88\" 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-58569a8 elementor-widget elementor-widget-heading\" data-id=\"58569a8\" 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\">Things to remember :<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-93780f8 elementor-widget elementor-widget-text-editor\" data-id=\"93780f8\" 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\">Given the sheer volume of data contained within a table, errors are very common. This can limit data processing and analysis.<\/li><li style=\"font-weight: 400;\" aria-level=\"1\">Fortunately, efficient error management is possible with Power Query.<\/li><li style=\"font-weight: 400;\" aria-level=\"1\">The query editor provides several manipulations to correct bugs according to the type of error.<\/li><li style=\"font-weight: 400;\" aria-level=\"1\">You can also customize the correction options to suit your needs.<\/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-31bd67f elementor-widget elementor-widget-image\" data-id=\"31bd67f\" 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\/10\/erreurs_Power_Query2.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-5e61ddf elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5e61ddf\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/power-bi-training\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Power Query training<\/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\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>#NULL!, #REF!, #DIV\/0!, N\/A &#8230;. Data tables regularly contain errors that limit data analysis. Fortunately, it&#8217;s possible to correct them through Power Query Error Handling. DataScientest shows you how. Power Query Error Handling There are two main types of error in the Power Query editor: step and column errors. Stage level If an error occurs [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":182566,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Power Query Error Handling: How does error handling work?<\/title>\n<meta name=\"description\" content=\"Explore the intricacies of Power Query Error Handling and learn how to effectively manage errors within ..\" \/>\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-error-handling-how-does-error-handling-work\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Query Error Handling: How does error handling work?\" \/>\n<meta property=\"og:description\" content=\"#NULL!, #REF!, #DIV\/0!, N\/A .... Data tables regularly contain errors that limit data analysis. Fortunately, it&#039;s possible to correct them through Power\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-27T02:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-10T14:40:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/03\/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=\"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=\"4 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-error-handling-how-does-error-handling-work#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"Power Query Error Handling: How does error handling work?\",\"datePublished\":\"2024-03-27T02:03:00+00:00\",\"dateModified\":\"2024-03-10T14:40:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work\"},\"wordCount\":639,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work\",\"url\":\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work\",\"name\":\"Power Query Error Handling: How does error handling work?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-03-27T02:03:00+00:00\",\"dateModified\":\"2024-03-10T14:40:38+00:00\",\"description\":\"Explore the intricacies of Power Query Error Handling and learn how to effectively manage errors within ..\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Query Error Handling: How does error handling work?","description":"Explore the intricacies of Power Query Error Handling and learn how to effectively manage errors within ..","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-error-handling-how-does-error-handling-work","og_locale":"en_GB","og_type":"article","og_title":"Power Query Error Handling: How does error handling work?","og_description":"#NULL!, #REF!, #DIV\/0!, N\/A .... Data tables regularly contain errors that limit data analysis. Fortunately, it's possible to correct them through Power","og_url":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-03-27T02:03:00+00:00","article_modified_time":"2024-03-10T14:40:38+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/en\/files\/2024\/03\/erreurs_Power_Query.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"Power Query Error Handling: How does error handling work?","datePublished":"2024-03-27T02:03:00+00:00","dateModified":"2024-03-10T14:40:38+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work"},"wordCount":639,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work","url":"https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work","name":"Power Query Error Handling: How does error handling work?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-03-27T02:03:00+00:00","dateModified":"2024-03-10T14:40:38+00:00","description":"Explore the intricacies of Power Query Error Handling and learn how to effectively manage errors within ..","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/power-query-error-handling-how-does-error-handling-work"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182564"}],"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=182564"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/182564\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/182566"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=182564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=182564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=182564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}