{"id":1419,"date":"2015-01-09T06:03:53","date_gmt":"2015-01-09T06:03:53","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=1419"},"modified":"2023-02-24T21:39:49","modified_gmt":"2023-02-24T21:39:49","slug":"error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/","title":{"rendered":"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook"},"content":{"rendered":"

I recently was working with a customer and trying to get a PowerPivot workbook working. We were running into the following error.<\/p>\n

\"\"<\/p>\n

I found the following blog post, which helped me get past the issue.<\/p>\n

http:\/\/www.bidn.com\/blogs\/DevinKnight\/ssis\/5362\/dealing-with-power-pivot-to-tabular-upgrade-errors<\/a><\/p>\n

The recommendation in the blog post is as follows:<\/p>\n

Translation<\/strong>: The Service Account that is running the SSAS Tabular does not have rights to the folder that the PowerPivot workbook is stored in. You can find out which account this is by launching the SQL Server Configuration Manager and find the instance name.<\/p>\n

Solution<\/strong>: Grant the Service Account the permissions it needs or move the PowerPivot workbook to a folder that the Service Account does have access to.<\/p>\n

If you know the Service Account does indeed have access but still is not able to import with this error then again you likely need to upgrade to SQL Server 2012 SP1<\/a>.<\/p>\n

Many thanks to the author of the blog post above, Devin Knight!<\/p>\n","protected":false},"excerpt":{"rendered":"

I recently was working with a customer and trying to get a PowerPivot workbook working. We were running into the following error. I found the following blog post, which helped me get past the issue. http:\/\/www.bidn.com\/blogs\/DevinKnight\/ssis\/5362\/dealing-with-power-pivot-to-tabular-upgrade-errors The recommendation in the blog post is as follows: Translation: The Service Account that is running the SSAS Tabular … <\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[17,21,7,32],"tags":[],"acf":[],"yoast_head":"\nError: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook - Archive<\/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:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook - Archive\" \/>\n<meta property=\"og:description\" content=\"I recently was working with a customer and trying to get a PowerPivot workbook working. We were running into the following error. I found the following blog post, which helped me get past the issue. http:\/\/www.bidn.com\/blogs\/DevinKnight\/ssis\/5362\/dealing-with-power-pivot-to-tabular-upgrade-errors The recommendation in the blog post is as follows: Translation: The Service Account that is running the SSAS Tabular …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-09T06:03:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:39:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/\",\"name\":\"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png\",\"datePublished\":\"2015-01-09T06:03:53+00:00\",\"dateModified\":\"2023-02-24T21:39:49+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#primaryimage\",\"url\":\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png\",\"contentUrl\":\"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png\",\"width\":469,\"height\":181},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook - Archive","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:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/","og_locale":"en_US","og_type":"article","og_title":"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook - Archive","og_description":"I recently was working with a customer and trying to get a PowerPivot workbook working. We were running into the following error. I found the following blog post, which helped me get past the issue. http:\/\/www.bidn.com\/blogs\/DevinKnight\/ssis\/5362\/dealing-with-power-pivot-to-tabular-upgrade-errors The recommendation in the blog post is as follows: Translation: The Service Account that is running the SSAS Tabular …","og_url":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/","og_site_name":"Archive","article_published_time":"2015-01-09T06:03:53+00:00","article_modified_time":"2023-02-24T21:39:49+00:00","og_image":[{"url":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png"}],"author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/","url":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/","name":"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png","datePublished":"2015-01-09T06:03:53+00:00","dateModified":"2023-02-24T21:39:49+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#primaryimage","url":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png","contentUrl":"https:\/\/regroove.ca\/archive\/wp-content\/uploads\/sites\/6\/2015\/01\/010915_0603_ErrorThePow1.png","width":469,"height":181},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2015\/01\/09\/error-the-powerpivot-workbook-could-not-be-imported-the-service-account-for-the-workspace-database-server-does-not-have-permission-to-read-from-the-powerpivot-workbook\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"Error: The PowerPivot workbook could not be imported. The service account for the workspace database server does not have permission to read from the PowerPivot workbook"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1419"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=1419"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1419\/revisions"}],"predecessor-version":[{"id":1860,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/1419\/revisions\/1860"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=1419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=1419"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=1419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}