cancel
Showing results for 
Search instead for 
Did you mean: 

Live Connection with SSAS MD Unexpected Error

 

Power BI report in Live connection with SSAS MD model brings up the error in SPORADIC way.

 

Error :  "An error occurred while loading the model for the item or data source 'QuerySystemError'. Verify that the connection information is correct and that you have permissions to access the data source.

 

We can confirm that there is no access issues to the data source.

 

Please find the Error Stack Trace from PBI Report.

 

Local Time:
2018-03-02T17:22:59.3356010+05:30

Session ID:
be19236e-724d-4908-801a-5a69b370fb05

Release:
February, 2018

Product Version:
2.55.5010.641 (PBIDesktop) (x64)

Error Message:
An error occurred while loading the model for the item or data source 'QuerySystemError'. Verify that the connection information is correct and that you have permissions to access the data source.

Stack Trace:
Microsoft.ReportingServices.Diagnostics.Utilities.CannotRetrieveModelException: An error occurred while loading the model for the item or data source 'QuerySystemError'. 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

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWin32Window activeWindow, WindowsHost windowsHost, FeedbackPacka

 

We researched to find the following :

 

Issue : https://community.powerbi.com/t5/Desktop/How-To-Troubleshoot-Unexpected-Error-Live-Connect-to-SSAS-O...

 

Recommended Fix:https://support.microsoft.com/en-sg/help/2964762/fix-event-id-22-or-error-0xc1000016-will-be-logged-...

 

As per recommendation we upgraded SQL Server -

 

We upgraded to latest packs -

 

SQL Server 2014 SP2 CU10 Developer version

 

Client has SQL Server SP2 CU8 for Enterprise version

 

Frequency of the error reduced after CU10 upgrade but still it appears. Please suggest.
-------

Status: New
Comments
Moderator

Hi @triparnaray,

 

Based on my research, this should be a limitation that the Power BI desktop connect live to SSAS cube Standard version. See: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#limitations-of-anal...

 

If there are Enterprise edition, please test with SSAS Enterprise version cube to see if the same issue occurs.  

 

Best Regards,
Qiuyun Yu