Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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)
There is not SPN configured on SSAS server. Do you think it's the trouble?
@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)
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 ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |