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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AKAB
New Member

Error in report with Direct Query to MS SQL in Power BI Report Server 2024 May

After update from Power BI Report Server 2024 January there are error in all reports with Direct Query to MS SQL

Error message in log like this

2024-06-07 14:06:25.9995|ERROR|4|PBI.Win.DataExtensionException|ExceptionType:Microsoft.PowerBI.DataExtension.Contracts.DataExtensionException;DataExtensionErrorDetails:Details: ErrorCode=QuerySystemError, ProviderErrorCode=0xC112001B, ErrorSource=PowerBI, Message=Failed to get CSDL., HResult=0x80004005, Language=en-US, ProviderErrorMessage=[<ccon>[content removed]</ccon>], ProviderGenericMessage=[Errors in the high-level relational engine. . The exception was raised by the IDbConnection interface.], ErrorSourceOrigin=MsolapWrapper, OnPremErrorCode=, InnerErrorDetails=[Type=MsolapWrapper.MsolapWrapperException, Message=Failure encountered while getting schema];stackTrace: в Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion, TranslationsBehavior translationsBehavior)
в Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.<>c__DisplayClass10_0.<GetModelMetadata>b__0(IDbSchemaCommand command)
в Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.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 = 525e21e9-b08c-9d72-ada4-699b9333f5db ClientSessionID = 8c981325-95a5-c834-1d08-c0baa0d6da6e
2024-06-07 14:06:25.9995|ERROR|32|Failure in conceptualschema catalogObjectId=6539e747-5436-4812-a4dc-06a980b4bc0f| RequestID = 525e21e9-b08c-9d72-ada4-699b9333f5db ClientSessionID = 8c981325-95a5-c834-1d08-c0baa0d6da6e Microsoft.PowerBI.ReportingServicesHost.CannotRetrieveModelException: An error occurred while loading the model. 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

 

 

 

1 ACCEPTED SOLUTION
2 REPLIES 2
v-xiandat-msft
Community Support
Community Support

Hi @AKAB ,

Thanks so much for hearing that you have a solution and thanks so much for sharing it, you can mark your answer as solution.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AKAB
New Member

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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