{"id":9384,"date":"2020-01-20T09:33:00","date_gmt":"2020-01-20T09:33:00","guid":{"rendered":"https:\/\/minova.nl\/?p=9384"},"modified":"2023-05-05T11:42:08","modified_gmt":"2023-05-05T11:42:08","slug":"change-a-column-name-in-the-power-bi-query-editor-without-hardcoding","status":"publish","type":"post","link":"https:\/\/minova.nl\/en\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/","title":{"rendered":"Changing a column name in the Power BI Query Editor without hardcoding"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"9384\" class=\"elementor elementor-9384\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-519dd79 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"519dd79\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5760595\" data-id=\"5760595\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6b41ccd elementor-widget elementor-widget-heading\" data-id=\"6b41ccd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Sometimes, when you enter data into the query editor, you need to change the name of a column that is not always the same in the source. This is one of those cases where the UI won't help much: by double-clicking on the column header and changing it to whatever you want, the column name will be hard-coded as it comes in. If in a new data refresh the column name is different, the query will break. Therefore, you will have to write some M yourself. Or steal the code below from me \ud83d\ude09<\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d969e78 elementor-widget elementor-widget-heading\" data-id=\"d969e78\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Here it is:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df46be2 elementor-widget elementor-widget-heading\" data-id=\"df46be2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<p class=\"elementor-heading-title elementor-size-default\"><pre><code>= Table.RenameColumns (\n\nThe table you want to refer to, usually the previous step in your query,\n\n{{ Table.ColumnNames ( The same table again ) { The number of the column },\n\n\"The new column name\" }}\n\n)\n\nAnd if you want to change the order of your columns dynamically, don't just move them around using the UI either. That will hard code all of the column names in your table. This is the code you want to use instead:\n\nTable.ReorderColumns (\n\nThe table you want to refer to which usually is the previous step in your query,\n\nList.InsertRange (\n\nList.Difference (\n\nTable.ColumnNames ( The same table again ),\n\n{ \"Columnname you want to move1\" , \"Columnname you want to moveN\"}\n\n),\n\nThe columnnumber you want to move the columns to,\n\n{ \"Columnname you want to move1\" , \"Columnname you want to moveN\"}\n\n)\n\n)<\/code><pre><\/p>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-67f12a0 elementor-widget elementor-widget-spacer\" data-id=\"67f12a0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Soms, wanneer je gegevens inbrengt in de query editor, moet je de naam van een kolom veranderen die niet altijd dezelfde is in de bron. Dit is een van die gevallen waar de UI niet veel zal helpen: door te dubbelklikken op de kolomkop en die te veranderen in wat je maar wilt, zal de [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":9390,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-9384","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-bi-query-editor"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding - Minova<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minova.nl\/en\/change-a-column-name-in-the-power-bi-query-editor-without-hardcoding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding - Minova\" \/>\n<meta property=\"og:description\" content=\"Soms, wanneer je gegevens inbrengt in de query editor, moet je de naam van een kolom veranderen die niet altijd dezelfde is in de bron. Dit is een van die gevallen waar de UI niet veel zal helpen: door te dubbelklikken op de kolomkop en die te veranderen in wat je maar wilt, zal de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minova.nl\/en\/change-a-column-name-in-the-power-bi-query-editor-without-hardcoding\/\" \/>\n<meta property=\"og:site_name\" content=\"Minova\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-20T09:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-05T11:42:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/minova.nl\/wp-content\/uploads\/2020\/01\/columnsPicturedjpf.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"511\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Marnix Jansen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Marnix Jansen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/\"},\"author\":{\"name\":\"Marnix Jansen\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"headline\":\"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding\",\"datePublished\":\"2020-01-20T09:33:00+00:00\",\"dateModified\":\"2023-05-05T11:42:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/\"},\"wordCount\":109,\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/columnsPicturedjpf.jpeg\",\"articleSection\":[\"Power BI Query Editor\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/\",\"url\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/\",\"name\":\"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding - Minova\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/columnsPicturedjpf.jpeg\",\"datePublished\":\"2020-01-20T09:33:00+00:00\",\"dateModified\":\"2023-05-05T11:42:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#primaryimage\",\"url\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/columnsPicturedjpf.jpeg\",\"contentUrl\":\"https:\\\/\\\/minova.nl\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/columnsPicturedjpf.jpeg\",\"width\":768,\"height\":511},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/minova.nl\\\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/minova.nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#website\",\"url\":\"https:\\\/\\\/minova.nl\\\/\",\"name\":\"Minova\",\"description\":\"Van data naar inzicht\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/minova.nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/minova.nl\\\/#\\\/schema\\\/person\\\/7c1b3b83cdb1ccdb93c0816dd157f20e\",\"name\":\"Marnix Jansen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g\",\"caption\":\"Marnix Jansen\"},\"sameAs\":[\"https:\\\/\\\/minova.nl\"],\"url\":\"https:\\\/\\\/minova.nl\\\/en\\\/author\\\/marnix\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Changing a column name in the Power BI Query Editor without hardcoding - Minova","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:\/\/minova.nl\/en\/change-a-column-name-in-the-power-bi-query-editor-without-hardcoding\/","og_locale":"en_US","og_type":"article","og_title":"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding - Minova","og_description":"Soms, wanneer je gegevens inbrengt in de query editor, moet je de naam van een kolom veranderen die niet altijd dezelfde is in de bron. Dit is een van die gevallen waar de UI niet veel zal helpen: door te dubbelklikken op de kolomkop en die te veranderen in wat je maar wilt, zal de [&hellip;]","og_url":"https:\/\/minova.nl\/en\/change-a-column-name-in-the-power-bi-query-editor-without-hardcoding\/","og_site_name":"Minova","article_published_time":"2020-01-20T09:33:00+00:00","article_modified_time":"2023-05-05T11:42:08+00:00","og_image":[{"width":768,"height":511,"url":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/01\/columnsPicturedjpf.jpeg","type":"image\/jpeg"}],"author":"Marnix Jansen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Marnix Jansen","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#article","isPartOf":{"@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/"},"author":{"name":"Marnix Jansen","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"headline":"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding","datePublished":"2020-01-20T09:33:00+00:00","dateModified":"2023-05-05T11:42:08+00:00","mainEntityOfPage":{"@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/"},"wordCount":109,"image":{"@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/01\/columnsPicturedjpf.jpeg","articleSection":["Power BI Query Editor"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/","url":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/","name":"Changing a column name in the Power BI Query Editor without hardcoding - Minova","isPartOf":{"@id":"https:\/\/minova.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#primaryimage"},"image":{"@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#primaryimage"},"thumbnailUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/01\/columnsPicturedjpf.jpeg","datePublished":"2020-01-20T09:33:00+00:00","dateModified":"2023-05-05T11:42:08+00:00","author":{"@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e"},"breadcrumb":{"@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#primaryimage","url":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/01\/columnsPicturedjpf.jpeg","contentUrl":"https:\/\/minova.nl\/wp-content\/uploads\/2020\/01\/columnsPicturedjpf.jpeg","width":768,"height":511},{"@type":"BreadcrumbList","@id":"https:\/\/minova.nl\/een-kolomnaam-wijzigen-in-de-power-bi-query-editor-zonder-hardcoding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minova.nl\/"},{"@type":"ListItem","position":2,"name":"Een kolomnaam wijzigen in de Power BI Query Editor zonder hardcoding"}]},{"@type":"WebSite","@id":"https:\/\/minova.nl\/#website","url":"https:\/\/minova.nl\/","name":"Minova","description":"From data to insight","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minova.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/minova.nl\/#\/schema\/person\/7c1b3b83cdb1ccdb93c0816dd157f20e","name":"Marnix Jansen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d0f8a0914d9cb667d4a598e0006a394cbe920eb4ec6356d0657ebcb790de8779?s=96&d=mm&r=g","caption":"Marnix Jansen"},"sameAs":["https:\/\/minova.nl"],"url":"https:\/\/minova.nl\/en\/author\/marnix\/"}]}},"_links":{"self":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9384","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/comments?post=9384"}],"version-history":[{"count":18,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9384\/revisions"}],"predecessor-version":[{"id":11057,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/posts\/9384\/revisions\/11057"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media\/9390"}],"wp:attachment":[{"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/media?parent=9384"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/categories?post=9384"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/minova.nl\/en\/wp-json\/wp\/v2\/tags?post=9384"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}