{"id":8744,"date":"2022-07-12T11:42:00","date_gmt":"2022-07-12T09:42:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=8744"},"modified":"2022-07-12T19:05:52","modified_gmt":"2022-07-12T17:05:52","slug":"tabular-model-error-occured-while-opening","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/","title":{"rendered":"Tabular model error occurred while opening"},"content":{"rendered":"\n<p>Visual studio error : Error occurred while opening tabular model, it occurs when opening the SSAS model on the workspace. Then Visual Studio crashes because the network connection was lost. The exact error message is something like : An error occurred while opening the model on the workspace database. For example, the local tabular model development environment lose connectivity to the repository for a few seconds.<\/p>\n\n\n\n<p>Indeed, it&#8217;s then impossible to open the SSAS Tabular model main object. In other words, the <strong>model.bim<\/strong> file. Visual studio somehow locked the project.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-tabular-model-error-occurred-while-opening-an-ssas-model-with-visual-studio-2019\">Tabular model error occurred while opening an SSAS model with Visual Studio 2019<\/h2>\n\n\n\n<p>The system displays this error: <\/p>\n\n\n\n<p><strong>Tabular Model Designer error in Visual Studio: This model is already open in another location by the same user. Please close the other project before working on this one.<\/strong><\/p>\n\n\n\n<p>The full error message is the following:<\/p>\n\n\n\n<p>This model is already open in another location by the same user, please close the other project before working on this one. An error occurred while opening the model on the workspace database. Reason: This model is already open in another location by the same user, please close the other project before working on this one.<br> <\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-solution-is-to-remove-the-settings-file\">Solution is to remove the settings file<\/h3>\n\n\n\n<p><strong>Go to the project folder and delete the settings file, with the .settings extension.<\/strong><\/p>\n\n\n\n<p>For example if the SSAS Tabular Model still have the default name : <strong>Model.bim<\/strong>. <\/p>\n\n\n\n<p>And the settings file looks like this: <strong>Model.bim_YourUserName.settings<\/strong><\/p>\n\n\n\n<p>This article shows a tip on how to fix the <mark>error<\/mark> while <mark>opening<\/mark> the <mark>model<\/mark> on the <mark>workspace<\/mark> in Visual Studio. Check the <a href=\"https:\/\/expert-only.com\/en\/power-bi\/last-month-value-with-power-bi-and-dax\/\">DAX Functions section to learn how to use time functions in Power BI<\/a> and more.<\/p>\n\n\n\n<p>Check the <a href=\"https:\/\/www.daxpatterns.com\/\">DAX patterns<\/a> blog for more useful formulas.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-et-exemples-sql-server-et-microsoft-it wp-block-embed-tutoriels-et-exemples-sql-server-et-microsoft-it\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/en\/power-bi\/last-month-value-with-power-bi-and-dax\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Visual studio error : Error occurred while opening tabular model, it occurs when opening the SSAS model on the workspace. Then Visual Studio crashes because the network connection was lost. The exact error message is something like : An <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\" title=\"Tabular model error occurred while opening\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5735,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[600],"tags":[],"class_list":{"0":"post-8744","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-ssas"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tabular model error occurred while opening - SSAS<\/title>\n<meta name=\"description\" content=\"SSAS tabular model Error occurred while opening the model on the workspace. The model is already open in another location.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabular model error occurred while opening\" \/>\n<meta property=\"og:description\" content=\"SSAS tabular model Error occurred while opening the model on the workspace. The model is already open in another location.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-12T09:42:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-12T17:05:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920-1024x576.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Tabular model error occurred while opening\",\"datePublished\":\"2022-07-12T09:42:00+00:00\",\"dateModified\":\"2022-07-12T17:05:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\"},\"wordCount\":304,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png\",\"articleSection\":[\"SSAS\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\",\"url\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\",\"name\":\"Tabular model error occurred while opening - SSAS\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png\",\"datePublished\":\"2022-07-12T09:42:00+00:00\",\"dateModified\":\"2022-07-12T17:05:52+00:00\",\"description\":\"SSAS tabular model Error occurred while opening the model on the workspace. The model is already open in another location.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabular model error occurred while opening\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Tabular model error occurred while opening - SSAS","description":"SSAS tabular model Error occurred while opening the model on the workspace. The model is already open in another location.","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:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/","og_locale":"en_US","og_type":"article","og_title":"Tabular model error occurred while opening","og_description":"SSAS tabular model Error occurred while opening the model on the workspace. The model is already open in another location.","og_url":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-07-12T09:42:00+00:00","article_modified_time":"2022-07-12T17:05:52+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920-1024x576.png","type":"image\/png"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Tabular model error occurred while opening","datePublished":"2022-07-12T09:42:00+00:00","dateModified":"2022-07-12T17:05:52+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/"},"wordCount":304,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png","articleSection":["SSAS"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/","url":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/","name":"Tabular model error occurred while opening - SSAS","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png","datePublished":"2022-07-12T09:42:00+00:00","dateModified":"2022-07-12T17:05:52+00:00","description":"SSAS tabular model Error occurred while opening the model on the workspace. The model is already open in another location.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/06\/board-953155_1920.png","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssas\/tabular-model-error-occured-while-opening\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Tabular model error occurred while opening"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8744","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=8744"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8744\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5735"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=8744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=8744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=8744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}