computer source Power View DS3 Report Data Test connection on SP1 source Fails because a double-hop is involved. Trace reveals that user attempting the connection appears as NT AUTHORITY\ANONYMOUS LOGON. To resolve: Use stored credentials Use Set Execution Context option Configure Kerberos Report Fails if user connecting with one of the three options listed does not have permission to read the data in the Analysis Services tabular instance. Power View DS3 Report Data Test connection on SP2 source same as above Report same as above Power View DS3 BISM Test connection on SP1 If you set up Kerberos, succeeds when RS impersonates BI\BIAdmin and queries data from DS3. If you have not set up Kerberos, succeeds because RS sets the EffectiveUserName property to a value of BI\BIAdmin when it connects as BI\BIService, its identity. This tactic succeeds because BI\BIAdmin has permission on the cube. Note: To make the <EffectiveUserName> connection string property work, the user making the connection to Analysis Services must be a member of the Server Administrator role in Analysis Services. If the service accounts for AS and RS did not match, you would have to add the identity of the RS service application to the Server Administrator role on DS3. Report A blank Power View report appears with an open connection to DS3. The connection is made by BI\BIService on behalf of the logged in user. Power View DS3 BISM Test connection on SP2 same as above Report same as above In short, if a double-hop is involved, you can use stored credentials or use the EffectiveUserName property, assuming the accounts on the Reporting Services and Analysis
computer source Power View on SP1 DS3 Report Data source Test connection Fails because a double-hop is involved. Trace reveals that user attempting the connection appears as NT AUTHORITY\ANONYMOUS LOGON. To resolve: Use stored credentials Use Set Execution Context option Configure Kerberos Report Fails if user connecting with one of the three options listed does not have permission to read the data in the Analysis Services tabular instance. Power View on SP2 DS3 Report Data source Test connection same as above Report same as above Power View on SP1 DS3 BISM Test connection If you set up Kerberos, succeeds when RS impersonates BI\BIAdmin and queries data from DS3. If you have not set up Kerberos, succeeds because RS sets the EffectiveUserName property to a value of BI\BIAdmin when it connects as BI\BIService, its identity. This tactic succeeds because BI\BIAdmin has permission on the cube. Note: To make the <EffectiveUserName> connection string property work, the user making the connection to Analysis Services must be a member of the Server Administrator role in Analysis Services. If the service accounts for AS and RS did not match, you would have to add the identity of the RS service application to the Server Administrator role on DS3. Report A blank Power View report appears with an open connection to DS3. The connection is made by BI\BIService on behalf of the logged in user. Power View on SP2 DS3 BISM Test connection same as above Report same as above In short, if a double-hop is involved, you can use stored credentials or use the EffectiveUserName property, assuming the accounts on the Reporting Services and Analysis
Power%20View%20Infrastructure%20Configuration%20and%20Installation%20Step-by-Step%20and%20Scripts.docx