Failed to parse CSDL into ConceptualSchema

[tomhafner]

Error while Loading Live Connecion OLAP Cube Schema:

Error Message:
Failed to parse CSDL into ConceptualSchema

Stack Trace:
Microsoft.PowerBI.ExploreHost.Errors.ConceptualSchemaCreationException: Failed to parse CSDL into ConceptualSchema ---> System.ArgumentException: An item with the same key has already been added.
   at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
   at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
   at Microsoft.InfoNav.Data.Edm.ConceptualEntity.BuildHierarchiesByName(IReadOnlyList`1 hierarchies, ReadOnlyDictionary`2& hierarchiesByName, ReadOnlyDictionary`2& hierarchiesByEdmName)
   at Microsoft.InfoNav.Data.Edm.ConceptualEntity..ctor(String name, String edmName, String displayName, String edmContainerName, ConceptualEntityVisibilityType visibility, Boolean isDateTable, Nullable`1 rowCount, IEnumerable`1 properties, IEnumerable`1 hierarchies, IEnumerable`1 displayFolders, IDictionary`2 edmNamesToProps, IEnumerable`1 keyColumns, IEnumerable`1 defaultFieldProperties, ConceptualColumn defaultLabel, ConceptualColumn defaultImage)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.CreateConceptualEntity(IEdmEntitySet edmEntitySet)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.CreateConceptualEntities(List`1& edmEntitySets)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.CreateConceptualSchema(String schemaId)
   at Microsoft.InfoNav.Data.Edm.ConceptualSchemaBuilder.TryCreateConceptualSchema(IEnumerable`1 schemaReaders, ITracer tracer, Version csdlVersion, String schemaId, ConceptualSchemaBuilderOptions options, IConceptualSchema& schema, IList`1& deserializationErrors)
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.ParseConceptualSchema(Stream dataModel)
   --- End of inner exception stack trace ---
   at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.ParseConceptualSchema(Stream dataModel)
   at Microsoft.PowerBI.ExploreHost.ExploreClient.GetConceptualSchema(String databaseID)
   at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLive.get_DataModel()
   at Microsoft.PowerBI.Client.Windows.Modeling.ModelProxy.TryGetModel(IDataModel& dataModel)
   at Microsoft.PowerBI.Client.Windows.Services.WarningDetectionService.DetectDataModelWarnings()
   at Microsoft.PowerBI.Client.Windows.Services.WarningDetectionService.<ScheduleAsyncDetection>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Delegate.DynamicInvokeImpl(Object[] args)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   at Microsoft.Mashup.Client.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)

Schema to Load: CSDL Cube Schema

[v-haibl-msft]

@tomhafner

Please confirm that if you have performed following steps in SSAS cube.

1) Create a parent child dimension, and set the ‘Naming Template’ property of the parent child attribute to use non-default naming for the levels.
2) Set the name of one of these levels to the same name as another attribute in the dimension.

If yes, the workaround is to rename the parent level as stated in description.

Best Regards,
Herbert

[tomhafner]

@v-haibl-msft

The affected cube does not contain a parent-child dimension. The schema of the cube is available for testing under the following link: Schema_MCO_Cube

[tomhafner]

After some search we found the cause of the error. It is a hierachy that has the same name as another. When creating the CSDL file, two identical keys are created. I do not know now whether that is an error of the PowerBi when interpreting the data or whether the SSAS services here erroneously works & Which can not handle 2 identical keys.

[Anonymous]

Hi,

getting the same error. having one parent child heirarchy but not referred in live connection report. anyway i can debug on  - Failed to get CSDL