Sql Analysis olap datacube connection failed

[JannesL05]

My Problem is that I can't connect my Sql Analysis Services Server Olap Cube. It shows me the following Error:

Feedback Type:
Frown (Error)

Timestamp:
2025-05-16T06:05:18.9690597Z

Local Time:
2025-05-16T08:05:18.9690597+02:00

Session ID:
5ce81dca-db15-4df2-a68d-36c5bef2bfa1

Release:
April 2025

Product Version:
2.142.1277.0 (25.04)+014fde450f93691fc9537f0758d73d1c5df153ef (x64)

Stack Trace:
Host:
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.ParseConceptualSchema(Stream dataModel, ConceptualSchemaBuilderOptions schemaBuilderOptions, ModelDaxCapabilities& daxCapabilities) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 422.
bei Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetConceptualSchema(ModelMetadataRequest request, ConceptualSchemaBuilderOptions builderOptions, ParseConceptualSchema parse) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ReportingServicesHost\ModelMetadata\ModelMetadataProvider.cs:Zeile 199.
bei Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetConceptualSchema(String modelMetadataVersion, Nullable`1 translationsBehavior, ParseConceptualSchema parse) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ReportingServicesHost\ReportingSession.cs:Zeile 169.
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass38_0.<GetConceptualSchema>b__0() in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 258.
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptions[T](Func`1 wrappedCall, ServiceErrorStatusCode statusCode) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 328.
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchemaAndHandleExceptions(Func`1 getConceptualSchema, String maxModelMetadataVersion, ModelDaxCapabilities& daxCapabilities) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 312.
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchema(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior, ModelDaxCapabilities& daxCapabilities) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 257.
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass31_0.<TryGetConceptualSchema>b__0() in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 90.
bei Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.TryGetStructureImpl[T](Int64 modelID, ServiceErrorExtractor extractor, Func`1 getStructure, Func`2 validateStructure, T& structure, ServiceError& serviceError) in D:\a\_work\1\s\Sql\Rosetta\Dev\src\PowerBI\ExploreHost\Utils\ExploreHostUtils.cs:Zeile 198.

Javascript&colon;ShowErrorDialog
at ErrorHostService.ShowErrorDialog(args)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.142.1277.0","ModuleName":null,"Component":"Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils","Error":null,"MethodDef":"ParseConceptualSchema","ErrorOffset":"","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 de-DE)

CLR Version:
4.8 or later [Release Number = 533325]

Peak Virtual Memory:
70.9 GB

Private Memory:
697 MB

Peak Working Set:
975 MB

IE Version:
11.3636.19041.0

User ID:
0013cb5c-88f6-4dae-8eac-c780e1fca35b

Workbook Package Info:
1* - de-DE, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_snowflakeAdbcVersionEnabled
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_odspSaveBackgroundUpload
PBI_modernOfficeFilePicker
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_directLakeRemoteModeling
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_desktopReportAuthoringCopilot
PBI_UserInstalledVerticaODBCDriver
PBI_sqlDbNativeArtifactsOnDesktop

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_publishDialogsSupportSubfolders
PBI_enhancedReportFormat
PBI_directLakeOnOneLake
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_qnaImproveLsdlCopilot
PBI_tmdlViewToggle
MashupFlight_EnableOracleBundledOdacProvider

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

[v-sathmakuri]

Hi @JannesL05 ,

Thank you for reaching out to Microsoft Fabric Community.

There are certain limitations to using SSAS MD:

• Only enterprise and BI editions of SQL Server 2014 support live connections. For the standard edition of SQL Server, SQL Server 2016 or later is required for live connections. This is documented in the Microsoft documentation below.

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-ssas-multidimensional 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-analysis-services-tabular-data 

If your version is compatible, check whether the user account has required access permissions. Try accessing it from SSMS and confirm that you have access. Also, try using import mode to narrow down the issue is related to the live connection.

your error logs shows  de-DE (German locale). If the cube includes translated metadata or localized attribute names, try launching Power BI in English (en-US) using the following process: 

File -> Options & settings -> Options ->  Regional Settings → Change model language to English.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!

[JannesL05]

Hi @v-sathmakuri thanks for your help!

I'am using SQL 2022 and I have four different cubes. One of them works with the live connection, but the other three give me the error. Changing the language didn't help, unfortunately.

[v-sathmakuri]

Hi @JannesL05 ,

Compare the configurations of the working cube with the non-working cubes to identify any differences. Double check if there are any security or role based restrictions on the non working cubes that might be preventing Power BI from accessing the metadata.

Please check whether you have access to the other cubes. If you have access, reprocess the non-working cubes in SSMS to ensure no processing errors exist.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!

[v-sathmakuri]

Hi @JannesL05 ,

May I ask if the provided solution helped in resolving the issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have

similar problems to solve it faster.

Thank you!!

[JannesL05]

Hi @v-sathmakuri Unfortunately, the problem hasn't been resolved yet. I have all the rights, and in Excel, for example, I can connect the cubes. In Power BI, too, however, there are problems with the live connection.

[v-sathmakuri · Accepted solution]

Hi @JannesL05 ,

As the troubleshooting steps did not resolve your issue, could you please raise a Microsoft support ticket for further investigation? You can create a Microsoft support ticket using the link below.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Thank you!!

[v-sathmakuri]

Hi @JannesL05 ,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you!!