Power BI RS: error connection on SSAS with windows authentification

[gringo89]

Hi,

We have got an error when i want to connect with power bi report on SSAS datasource.

The connection on SSAS is with authentification windows of connected user and i have this error :

|ERROR|22|PBI.Win.DataExtensionException|ExceptionType:Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException;DataExtensionErrorDetails:Details: Message=Failed to open the MSOLAP connection., HResult=0x80004005, ErrorCode=OpenConnectionError, Language=en-US, ProviderErrorCode=0x00000000, ProviderErrorMessage=[7A59B7A8A1D3F5DFF802B686DA37E746230D73D342093788372E08D29F9BAF29], ProviderGenericMessage=[Error Code = 0x00000000, External Code = 0x00000000:.], ErrorSource=PowerBI, ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Could not initialize connection];stackTrace: à Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl()
à Microsoft.PowerBI.DataExtension.Contracts.Utilities.RunSynchronously(Action action)

When I forced the user authentification, the connection to SSAS is OK.

Report Server and SSAS are on different server.

Please, Can you help me?

[gringo89]

There is not SPN configured on SSAS server. Do you think it's the trouble?

[d_gosbell · Accepted solution]

---

@gringo89 wrote:

There is not SPN configured on SSAS server. Do you think it's the trouble?

---

Yes, if SSAS and PBIRS are on separate servers then you will need to have SPNs and Constrained Delegation configured in order to get Kerberos Authentication working (see https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports)

[SylvainC]

I've already tried to manage this but delegation tab doesn't appear in ADUC ... I already manage SPNs and some of them already exists for my PBIRS service account (SVCUserSQL for example either on HTTP and OLAP). I don't find a solution ...

Can you help me ?