{"id":26825,"date":"2021-05-21T13:17:00","date_gmt":"2021-05-21T11:17:00","guid":{"rendered":"https:\/\/alistar.net\/?p=26825"},"modified":"2026-10-02T15:48:26","modified_gmt":"2026-10-02T13:48:26","slug":"power-bi-tabular-editor","status":"publish","type":"post","link":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/","title":{"rendered":"Power BI \u2013 Tabular Editor"},"content":{"rendered":"<p class=\"wp-block-paragraph\">For developers of tabular models, Tabular Editor is a familiar tool\u2014one that is frequently used to develop models. Unlike Visual Studio, this tool is very user-friendly, easy to use, and, above all, very fast. This is because you\u2019re editing only the model\u2019s metadata without loading any data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Good news! Tabular Editor can now also be used to edit Power BI datasets, as well as to edit datasets directly in the online Power BI environment.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Installing Tabular Editor<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">After installing Tabular Editor via the&nbsp;<a href=\"https:\/\/tabulareditor.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Tabular Editor Website<\/a>&nbsp;It will automatically appear under \"External Tools\" in Power BI Desktop. The tool can also be used as a standalone application to connect directly to a Power BI dataset in the cloud. In terms of functionality, the following features are currently supported, but it is possible that other features may be added in the future.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Creating and Editing Measurement Values<\/li>\n\n\n\n<li>Creating and Editing Calculation Groups and Calculation Items<\/li>\n\n\n\n<li>Creating and Editing Perspectives<\/li>\n\n\n\n<li>Easily edit metadata for multiple objects at once&nbsp;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Power BI Desktop&nbsp;<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In Power BI Desktop, you can use this tool to edit the dataset for the current report. When you open Tabular Editor via \u201cExternal Tools\u201d in the menu, the model loads immediately. Changes can be made in Tabular Editor as usual and are immediately visible and usable in Power BI.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Power BI service<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As mentioned in the introduction, it\u2019s also possible to edit a dataset directly from the Power BI cloud. However, this requires Power BI Premium. It\u2019s a shame that this functionality isn\u2019t available to Pro users. If you want to open a dataset from the cloud, you can do so by opening the dataset\u2019s connection string in Tabular Editor (File -&gt; Open -&gt; From DB). You can find the connection string in the server settings under the dataset\u2019s properties.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Edit the entire model<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As described earlier, the features that can be used within Tabular Editor in conjunction with Power BI Desktop are still limited. However, there is also the option to enable additional functionality. You can do this by checking the box for \u201cAllow unsupported Power BI features (experimental)\u201d in the preferences. However, this can also cause the pbix file to become corrupted. For example, adding tables would still not be possible, so I would be cautious with this option and, in principle, only use the supported features.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you open a Power BI dataset in Tabular Editor, the following message appears clearly. This means it\u2019s not possible to use functions in Tabular Editor without realizing it, which could potentially cause data corruption.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Since I spend a lot of time editing Tabular models, I\u2019ve been familiar with Tabular Editor for a long time and actually use it every day. So I think the addition of the ability to edit Power BI datasets with Tabular Editor is a really great development. I see the ability to edit datasets from powerbi.com as a major advantage in particular. Since you\u2019re only changing the metadata, this works a lot faster and more efficiently.&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>For developers of tabular models, Tabular Editor is a familiar tool. It is widely used to develop models. Unlike Visual Studio, this tool is very user-friendly, easy to use, and, above all, very fast.<\/p>","protected":false},"author":16,"featured_media":28571,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[27],"tags":[203],"industrie-type":[],"interesses":[],"techologie":[],"alistar_language":[],"class_list":["post-26825","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-nl","tag-powerbi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power BI - Tabular Editor - Alistar<\/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:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI - Tabular Editor - Alistar\" \/>\n<meta property=\"og:description\" content=\"Voor de ontwikkelaars van tabular modellen is Tabular Editor geen onbekende tool. Een tool die veelvuldig gebruikt wordt om modellen te ontwikkelen. In tegenstelling tot Visual Studio is deze tool erg gebruiksvriendelijk, makkelijk in gebruik en vooral erg snel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/\" \/>\n<meta property=\"og:site_name\" content=\"Alistar\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-21T11:17:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-02T13:48:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/alistar.net\/wp-content\/uploads\/2021\/05\/shutterstock_1723923499-scaled.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Shardae Castelen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shardae Castelen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/\"},\"author\":{\"name\":\"Shardae Castelen\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\"},\"headline\":\"Power BI &#8211; Tabular Editor\",\"datePublished\":\"2021-05-21T11:17:00+00:00\",\"dateModified\":\"2026-10-02T13:48:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/\"},\"wordCount\":557,\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/shutterstock_1723923499-scaled.webp\",\"keywords\":[\"Power BI\"],\"articleSection\":[\"Blog NL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/\",\"name\":\"Power BI - Tabular Editor - Alistar\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/shutterstock_1723923499-scaled.webp\",\"datePublished\":\"2021-05-21T11:17:00+00:00\",\"dateModified\":\"2026-10-02T13:48:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#primaryimage\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/shutterstock_1723923499-scaled.webp\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/shutterstock_1723923499-scaled.webp\",\"width\":2560,\"height\":1707},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/blog\\\/power-bi-tabular-editor\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/alistar.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI &#8211; Tabular Editor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"name\":\"Alistar\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/alistar.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#organization\",\"name\":\"Alistar\",\"url\":\"https:\\\/\\\/alistar.net\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"contentUrl\":\"https:\\\/\\\/alistar.net\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/favicon-new.svg\",\"width\":260,\"height\":260,\"caption\":\"Alistar\"},\"image\":{\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/alistar\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/alistar.net\\\/en\\\/#\\\/schema\\\/person\\\/3c047614ccf88bd8927ae653882b3b50\",\"name\":\"Shardae Castelen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g\",\"caption\":\"Shardae Castelen\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI - Tabular Editor - Alistar","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:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/","og_locale":"en_US","og_type":"article","og_title":"Power BI - Tabular Editor - Alistar","og_description":"Voor de ontwikkelaars van tabular modellen is Tabular Editor geen onbekende tool. Een tool die veelvuldig gebruikt wordt om modellen te ontwikkelen. In tegenstelling tot Visual Studio is deze tool erg gebruiksvriendelijk, makkelijk in gebruik en vooral erg snel.","og_url":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/","og_site_name":"Alistar","article_published_time":"2021-05-21T11:17:00+00:00","article_modified_time":"2026-10-02T13:48:26+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/alistar.net\/wp-content\/uploads\/2021\/05\/shutterstock_1723923499-scaled.webp","type":"image\/webp"}],"author":"Shardae Castelen","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Shardae Castelen","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#article","isPartOf":{"@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/"},"author":{"name":"Shardae Castelen","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50"},"headline":"Power BI &#8211; Tabular Editor","datePublished":"2021-05-21T11:17:00+00:00","dateModified":"2026-10-02T13:48:26+00:00","mainEntityOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/"},"wordCount":557,"publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2021\/05\/shutterstock_1723923499-scaled.webp","keywords":["Power BI"],"articleSection":["Blog NL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/","url":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/","name":"Power BI - Tabular Editor - Alistar","isPartOf":{"@id":"https:\/\/alistar.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#primaryimage"},"image":{"@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#primaryimage"},"thumbnailUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2021\/05\/shutterstock_1723923499-scaled.webp","datePublished":"2021-05-21T11:17:00+00:00","dateModified":"2026-10-02T13:48:26+00:00","breadcrumb":{"@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#primaryimage","url":"https:\/\/alistar.net\/wp-content\/uploads\/2021\/05\/shutterstock_1723923499-scaled.webp","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2021\/05\/shutterstock_1723923499-scaled.webp","width":2560,"height":1707},{"@type":"BreadcrumbList","@id":"https:\/\/alistar.net\/en\/blog\/power-bi-tabular-editor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/alistar.net\/"},{"@type":"ListItem","position":2,"name":"Power BI &#8211; Tabular Editor"}]},{"@type":"WebSite","@id":"https:\/\/alistar.net\/en\/#website","url":"https:\/\/alistar.net\/en\/","name":"Alistar","description":"","publisher":{"@id":"https:\/\/alistar.net\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/alistar.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/alistar.net\/en\/#organization","name":"Alistar","url":"https:\/\/alistar.net\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/","url":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","contentUrl":"https:\/\/alistar.net\/wp-content\/uploads\/2025\/07\/favicon-new.svg","width":260,"height":260,"caption":"Alistar"},"image":{"@id":"https:\/\/alistar.net\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/alistar\/"]},{"@type":"Person","@id":"https:\/\/alistar.net\/en\/#\/schema\/person\/3c047614ccf88bd8927ae653882b3b50","name":"Shardae Castelen","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/da4b715240dd773d96635e681af70c4ca1c2efba4cbeddc37b21e50dc5fc9b0c?s=96&d=mm&r=g","caption":"Shardae Castelen"}}]}},"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/26825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/comments?post=26825"}],"version-history":[{"count":1,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/26825\/revisions"}],"predecessor-version":[{"id":76097,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/posts\/26825\/revisions\/76097"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media\/28571"}],"wp:attachment":[{"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/media?parent=26825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/categories?post=26825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/tags?post=26825"},{"taxonomy":"industrie-type","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/industrie-type?post=26825"},{"taxonomy":"interesses","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/interesses?post=26825"},{"taxonomy":"techologie","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/techologie?post=26825"},{"taxonomy":"alistar_language","embeddable":true,"href":"https:\/\/alistar.net\/en\/wp-json\/wp\/v2\/alistar_language?post=26825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}