BISM: value of the 'EffectiveUserName' XML for Analysis property is not valid

Published Jan 15 2019 02:24 PM 720 Views
Microsoft
First published on MSDN on Apr 25, 2012

I’ve been working with Power View reports and one of the items I was setting up was using a BISM Data source connecting to an Analysis Services Instance in Tabular Mode.  When I went to spin up a new Power View Report against the BISM Connection, I got the following error:

Within the details, we saw the following:

<Source>Microsoft SQL Server 2012 Analysis Services</Source><Message>The 'HSGCONTOSO\asaxton' value of the 'EffectiveUserName' XML for Analysis property is not valid.</Message>

Of note, the asaxton account is a Domain Admin and is listed as a Server Administrator on the Analysis Services service, and is a Farm Administrator for the SharePoint Farm.

Searching Bing didn’t pull anything up specific to BISM for this error.  However, I stumbled across the following documentation.

Grant Analysis Services Administrative Permissions to Shared Service Applications
http://technet.microsoft.com/en-us/library/hh230972.aspx#bkmk_ssas

The Service account I was using for the PowerPivot Shared Service was the spservice account.  After adding that account to the AS Server Admins, the report came up without error.

Adam W. Saxton | Microsoft Escalation Services
https://twitter.com/awsaxton

%3CLINGO-SUB%20id%3D%22lingo-sub-316997%22%20slang%3D%22en-US%22%3EBISM%3A%20value%20of%20the%20'EffectiveUserName'%20XML%20for%20Analysis%20property%20is%20not%20valid%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-316997%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Apr%2025%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EI%E2%80%99ve%20been%20working%20with%20Power%20View%20reports%20and%20one%20of%20the%20items%20I%20was%20setting%20up%20was%20using%20a%20BISM%20Data%20source%20connecting%20to%20an%20Analysis%20Services%20Instance%20in%20Tabular%20Mode.%26nbsp%3B%20When%20I%20went%20to%20spin%20up%20a%20new%20Power%20View%20Report%20against%20the%20BISM%20Connection%2C%20I%20got%20the%20following%20error%3A%3C%2FP%3E%0A%20%20%3CBLOCKQUOTE%3E%0A%20%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F67058iA807FA520A147FE4%22%20%2F%3E%3C%2FP%3E%0A%20%20%3C%2FBLOCKQUOTE%3E%0A%20%20%3CP%3EWithin%20the%20details%2C%20we%20saw%20the%20following%3A%3C%2FP%3E%0A%20%20%3CBLOCKQUOTE%3E%0A%20%20%20%3CP%3E%3CSOURCE%3EMicrosoft%20SQL%20Server%202012%20Analysis%20Services%3C%2FSOURCE%3E%3CMESSAGE%3EThe%20'HSGCONTOSO%5Casaxton'%20value%20of%20the%20'EffectiveUserName'%20XML%20for%20Analysis%20property%20is%20not%20valid.%3C%2FMESSAGE%3E%3C%2FP%3E%0A%20%20%3C%2FBLOCKQUOTE%3E%0A%20%20%3CP%3EOf%20note%2C%20the%20asaxton%20account%20is%20a%20Domain%20Admin%20and%20is%20listed%20as%20a%20Server%20Administrator%20on%20the%20Analysis%20Services%20service%2C%20and%20is%20a%20Farm%20Administrator%20for%20the%20SharePoint%20Farm.%3C%2FP%3E%0A%20%20%3CP%3ESearching%20Bing%20didn%E2%80%99t%20pull%20anything%20up%20specific%20to%20BISM%20for%20this%20error.%26nbsp%3B%20However%2C%20I%20stumbled%20across%20the%20following%20documentation.%3C%2FP%3E%0A%20%20%3CBLOCKQUOTE%3E%0A%20%20%20%3CP%3EGrant%20Analysis%20Services%20Administrative%20Permissions%20to%20Shared%20Service%20Applications%20%3CBR%20%2F%3E%20%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fhh230972.aspx%23bkmk_ssas%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fhh230972.aspx%23bkmk_ssas%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3C%2FBLOCKQUOTE%3E%0A%20%20%3CP%3EThe%20Service%20account%20I%20was%20using%20for%20the%20PowerPivot%20Shared%20Service%20was%20the%20spservice%20account.%26nbsp%3B%20After%20adding%20that%20account%20to%20the%20AS%20Server%20Admins%2C%20the%20report%20came%20up%20without%20error.%3C%2FP%3E%0A%20%20%3CBLOCKQUOTE%3E%0A%20%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F67060i50681A1643C94E07%22%20%2F%3E%3C%2FP%3E%0A%20%20%20%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F67062iFFFC128617618320%22%20%2F%3E%3C%2FP%3E%0A%20%20%3C%2FBLOCKQUOTE%3E%0A%20%20%3CP%3EAdam%20W.%20Saxton%20%7C%20Microsoft%20Escalation%20Services%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fawsaxton%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3E%20https%3A%2F%2Ftwitter.com%2Fawsaxton%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-316997%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Apr%2025%2C%202012%20I%E2%80%99ve%20been%20working%20with%20Power%20View%20reports%20and%20one%20of%20the%20items%20I%20was%20setting%20up%20was%20using%20a%20BISM%20Data%20source%20connecting%20to%20an%20Analysis%20Services%20Instance%20in%20Tabular%20Mode.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-316997%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalysis%20Services(SSAS)%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 02:24 PM
Updated by: