Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
iamsordz
Frequent Visitor

Error connecting to Azure Analysis Services after PowerBI October 2020 upgrade

Hi 

 

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

iamsordz_0-1610362752070.png

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

2 ACCEPTED SOLUTIONS
gsprague
Employee
Employee

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

  1. 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
  2. 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

View solution in original post

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

View solution in original post

7 REPLIES 7
gsprague
Employee
Employee

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

  1. 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
  2. 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

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

 

Thanks guys @gsprague @V-pazhen-msft 

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

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

V-pazhen-msft
Community Support
Community Support

@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 Connecti...

 


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

Thanks @V-pazhen-msft for the reply.

 

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

2021-01-13 22_20_13-Window.png

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.

 

2021-01-13 22_24_56-Window.png

 

2021-01-13 22_29_34-Window.png

 

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

 

Thanks and looking forward to your further advise.

 

Thanks.

Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.