topic Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade in Report Server

Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

iamsordz — Tue, 12 Jan 2021 19:57:40 GMT

After upgrading the PowerBI report server from May 2020 to October 2020, connection to Azure Analysis Services is having error below:

I am able to test successfully the connection in the Data Source section of the PowerBI report, but error is displayed when opening the report.

Additional log from Report Server looks like this:

23:12:04.7976|ERROR|9|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=0x80040154, ProviderErrorMessage=[3186520CE32E085840919306AD0AF0265AB76B1C33A809D0A09358E4A37D0B51], ProviderGenericMessage=[Error Code = 0x80040154, External Code = 0x80040154:.], ErrorSource=User, ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Could not initialize connection];stackTrace: at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl() at Microsoft.PowerBI.DataExtension.Contracts.Utilities.RunSynchronously(Action action) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() at Microsoft.PowerBI.ReportServer.ExploreHost.WindowsUserIdentityConnectionImpersonator.<ExecuteInContextAsync>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportingServicesHost.PoolableConnectionWrapper.<OpenAsync>d__8.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.ReportingServicesHost.Utils.TaskExtensions.WaitAndUnwrapException(Task task) at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent);message:GetModelMetadata;| RequestID = d2a6dc7c-ecb1-d168-1d64-9e1e670eb10d ClientSessionID = 28b7447e-7336-43cf-4196-5c61d8511053 2021-01-12 23:12:04.7976|INFO|23|Received request GET /libs/scripts/visualHostCore.js| RequestID = s_1c9d5799-9a1c-441f-8711-0c87700da392 2021-01-12 23:12:04.8289|INFO|23|Received request GET /libs/scripts/textboxVisual.js| RequestID = s_111669b5-ce69-4e2f-a07e-88b4cee76c3f 2021-01-12 23:12:04.8445|INFO|18|Received request GET /libs/scripts/basicShapeVisual.js| RequestID = s_23ed50a7-2bb7-42b2-9202-dfc86d746160 2021-01-12 23:12:04.8758|ERROR|9|PBI.Win.ReportingServicesHostTrace|type:Error;message:library:Throwing Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: , Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'nzl-vtnz-CustomerCaptureIncentiveModel'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to open the MSOLAP connection. ---> MsolapWrapper.MsolapWrapperException: Could not initialize connection at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message) at MsolapWrapper.Connection.Open() at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl() --- End of inner exception stack trace --- at Microsoft.PowerBI.DataExtension.Msolap.Connection.OpenImpl() at Microsoft.PowerBI.DataExtension.Contracts.Utilities.RunSynchronously(Action action) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter.GetResult() at Microsoft.PowerBI.ReportServer.ExploreHost.WindowsUserIdentityConnectionImpersonator.<ExecuteInContextAsync>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.ReportingServicesHost.PoolableConnectionWrapper.<OpenAsync>d__8.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.ReportingServicesHost.Utils.TaskExtensions.WaitAndUnwrapException(Task task) at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent) --- End of inner exception stack trace ---;;| RequestID = d2a6dc7c-ecb1-d168-1d64-9e1e670eb10d ClientSessionID = 28b7447e-7336-43cf-4196-5c61d8511053 2021-01-12 23:12:04.9070|ERROR|16|Failure in conceptualschema| RequestID = d2a6dc7c-ecb1-d168-1d64-9e1e670eb10d ClientSessionID = 28b7447e-7336-43cf-4196-5c61d8511053 Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'nzl-vtnz-CustomerCaptureIncentiveModel'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to open the MSOLAP connection. ---> MsolapWrapper.MsolapWrapperException: Could not initialize connection

Any ideas to resolve above?

Thanks

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

Anonymous — Wed, 13 Jan 2021 07:05:07 GMT

iamsordz

I cannot reproduce this issue in my test with AS. The most recent updates version was release last week, 2021/1/7, which fixed some refresh bug, you may try update to this newest version.

In addition, you may follow the solution in this blog to fix this issue, which seems reasonable to me.

Power BI: We Couldn't Connect To The Analysis Services Server. Make Sure You've Entered The Connection String Correctly (devoworx.com)

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

iamsordz — Wed, 13 Jan 2021 09:31:40 GMT

Thanks Anonymous for the reply.

I did install the latest PowerBI report server (2021/1/7) as shown in the screenshot below:

I tried the link you've provided, able to test connection successfully but still same issue when opening the report, see screenshots below. This report is OK prior the October 2020 upgrade.

Please note that the report data source is Azure Analysis Services tabular model.

Thanks and looking forward to your further advise.

Thanks.

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

gsprague — Thu, 14 Jan 2021 02:19:05 GMT

Hi iamsordz

Thank for your patience.

We have found a mitigation for some customers that are experiencing this issue in the October release. Let me know if the following works for you:

Copy the following libraries from the bin directory of PowerBI Desktop for RS into PowerBI Report Server's PowerBI directory

For Desktop for RS, copy the following files from C:\Program Files\Microsoft Power BI Desktop RS\bin (adjusting for your base installation directory)
1. Microsoft.AnalysisServices.AzureClient.dll
2. Microsoft.AnalysisServices.AzureClient.dll.manifest
3. msolap.dll
Copy the files to Power BI Report server C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI (adjusting for your base installation directory)

Thanks,

Gabe

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

iamsordz — Thu, 14 Jan 2021 07:40:28 GMT

Thank you very much gsprague , your advise worked and fixed our issue.

Thanks guys gsprague Anonymous

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

iamsordz — Tue, 26 Jan 2021 10:11:33 GMT

Hi gsprague

Thanks for the workaround for PowerBI report connecting to Azure Analysis Services.

But now similar issue is encountered for published PowerBI report connecting to Azure SQL. Do I need to copy other files for this?

Here is the PowerBI log:

2021-01-26 23:03:10.2732|ERROR|53|PBI.Win.DataExtensionException|ExceptionType:Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException;DataExtensionErrorDetails:Details: Message=Failed to get CSDL., HResult=0x80004005, ErrorCode=QuerySystemError, Language=en-US, ProviderErrorCode=0xC1070000, ProviderErrorMessage=[2663DD5278984E7565A2F88E29150C3F45B0F0A259F58B6FD892970FE6450AA7], ProviderGenericMessage=[COM error: COM error.], ErrorSource=PowerBI, ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Failure encountered while getting schema];stackTrace: at Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion) at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent);message:GetModelMetadata;| RequestID = 2dfeffdb-1328-27b3-9a33-24f8395cd3b6 ClientSessionID = 95ce6add-0181-ae28-35c1-8e8a9ebca519 2021-01-26 23:03:10.2732|ERROR|53|PBI.Win.ReportingServicesHostTrace|type:Error;message:library:Throwing Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: , Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'f7e28acc-345b-4677-865c-740ed0704517_-233041988'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to get CSDL. ---> MsolapWrapper.MsolapWrapperException: Failure encountered while getting schema at MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message) at MsolapWrapper.CDbSchemaRowsetWrapper.ExecuteSchemaRowset(Guid schema, Object[] restrictions, PropertySetCollection propSets) at MsolapWrapper.SchemaCommand.ExecuteReader(Guid schema, Object[] restrictions) at MsolapWrapper.SchemaCommand.GetModelMetadata(Object[] restrictions) at Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion) --- End of inner exception stack trace --- at Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion) at Microsoft.PowerBI.ReportingServicesHost.LocalReportProcessingHost.ExecuteSchemaCommand[T](ExploreHostDataSourceInfo dataSourceInfo, IDbConnectionPool connectionPool, IConnectionFactory connectionFactory, IConnectionUserImpersonator connectionUserImpersonator, QueryExecutionOptionsBase queryExecutionOptions, ITelemetryService telemetryService, Func`2 action, String failTelemetryMessage, ServiceErrorStatusCode statusCode, ExploreBaseEvent exploreEvent) --- End of inner exception stack trace ---;;| RequestID = 2dfeffdb-1328-27b3-9a33-24f8395cd3b6 ClientSessionID = 95ce6add-0181-ae28-35c1-8e8a9ebca519 2021-01-26 23:03:10.2732|ERROR|53|Failure in conceptualschema| RequestID = 2dfeffdb-1328-27b3-9a33-24f8395cd3b6 ClientSessionID = 95ce6add-0181-ae28-35c1-8e8a9ebca519 Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'f7e28acc-345b-4677-865c-740ed0704517_-233041988'. Verify that the connection information is correct and that you have permissions to access the data source. ---> Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException: Failed to get CSDL. ---> MsolapWrapper.MsolapWrapperException: Failure encountered while getting schema

Thanks.

George

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

iamsordz — Tue, 26 Jan 2021 10:24:05 GMT

gsprague

Foudn a workaround and similar to your advice. Copied the same 3 files to the C:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine

Thanks.

Re: Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

Anonymous — Fri, 18 Jun 2021 11:51:58 GMT

Hi All

I have a similar issue using PowerBI Reports Server January 2020 connecting to Azure Analysis Services; after applying the above mentioned fix,workaround in our QA environment the reports work however when using the test connection in the data source configuration I get the following:

Couldn't connect
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details
Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials.

I have confirmed that the account in question doesn't have MFA enabled and it only started throwing this error after applying the fix in this thread.

So before I take this to production I would just like some clarity or feedback from the community.

Power BI Reports server version -15.0.1102.777

Thanks