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.
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 :
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.
-------
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.