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
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