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.
I'm using SQL Server 2016 MOLAP cube.
I added calculated mesaures (like average of) in my model. When I want to open the cube in PowerBI, there is an error after selecting the cube and the schema is not opening.
When I clear all the calculated measures, the cube is opening. I add them one at a time and I can have 4 before stopping again.
Is there any limit or characters that PowerBI is not able to deal with? I can browse my cube in Analysis services without having any problem.
Hi @jgagnon69 ,
It may be not sufficient space.
Similar questions refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
I have 41 gigs left. As mentionned, the cube is working well if I delete calculated fields, made by VS project
No there are no limits like this, I've seen models with thousands of measures. Can you post the actual error message? (there should be a "more details" link or something like that which will give you the full error message). That should give us some information on how to help you resolve this.
Here is the error:
Feedback Type:
Frown (Error)
Timestamp:
2021-10-25T13:07:31.5058550Z
Local Time:
2021-10-25T09:07:31.5058550-04:00
Session ID:
312b968f-eca9-4d34-a966-25fc6733427c
Release:
October 2021
Product Version:
2.98.882.0 (21.10) (x64)
Error Message:
Nous ne pouvons pas vous connecter à votre base de données Analysis Services. Vérifiez que les noms de vos serveur et base de données sont corrects et que vous êtes autorisé à y accéder.
Error Message Detail:
Erreur interne : Une erreur inattendue s'est produite.
Stack Trace:
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
à MsolapWrapper.Utils.ThrowErrorIfHrFailed(Int32 hr, String message)
à MsolapWrapper.CDbSchemaRowsetWrapper.ExecuteSchemaRowset(Guid schema, Object[] restrictions, PropertySetCollection propSets)
à MsolapWrapper.SchemaCommand.ExecuteReader(Guid schema, Object[] restrictions)
à MsolapWrapper.SchemaCommand.GetModelMetadata(Object[] restrictions)
à Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion, Boolean ignoreTranslations)
--- Fin de la trace de la pile d'exception interne ---
à Microsoft.PowerBI.DataExtension.Msolap.SchemaCommand.GetModelMetadata(String catalogName, String perspectiveName, String supportedVersion, Boolean ignoreTranslations)
à 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)
--- Fin de la trace de la pile d'exception interne ---
à 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)
à Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.<>c__DisplayClass10_1.<GetModelMetadata>b__1(ExploreBaseEvent timedEvent)
à Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.<>c__DisplayClass4_0`1.<RunInActivity>b__0(ExploreBaseEvent activity)
à Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity(String activityName, Action`1 action)
à Microsoft.PowerBI.ReportingServicesHost.ExploreTelemetryService.RunInActivity[T](String activityName, Func`2 action)
à Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetModelMetadata(ModelMetadataRequest request)
à Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetConceptualSchema(ModelMetadataRequest request, ConceptualSchemaBuilderOptions builderOptions, ParseConceptualSchema parse)
à Microsoft.PowerBI.ReportingServicesHost.ReportingSession.GetConceptualSchema(String modelMetadataVersion, Nullable`1 ignoreTranslations, ParseConceptualSchema parse)
à Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass33_0.<GetConceptualSchema>b__0()
à Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptions[T](Func`1 wrappedCall, String databaseID, ServiceErrorStatusCode statusCode, FeatureSwitches featureSwitches)
à Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchemaAndHandleExceptions(Func`1 getConceptualSchema, IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 ignoreTranslations, ModelDaxCapabilities& daxCapabilities)
à Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetConceptualSchema(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 ignoreTranslations, ModelDaxCapabilities& daxCapabilities)
à Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass26_0.<TryGetConceptualSchema>b__0()
à Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.TryGetStructureImpl[T](Int64 modelID, ServiceErrorExtractor extractor, Func`1 getStructure, Func`2 validateStructure, T& structure, ServiceError& serviceError)
Invocation Stack Trace:
à Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
à Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
à Microsoft.PowerBI.Client.Windows.ErrorHostService.GetErrorDetails(ShowErrorDialogArgs args)
à Microsoft.PowerBI.Client.Windows.ErrorHostService.<>c__DisplayClass4_0.<ShowErrorDialogCore>b__0()
à System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
à System.Delegate.DynamicInvokeImpl(Object[] args)
à System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
à System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbacks()
à System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
à System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
à System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
à Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
à Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass5_0.<ExecuteOnUIThread>b__0(Object t)
à System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
à System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
à System.Delegate.DynamicInvokeImpl(Object[] args)
à System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
à System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
à System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
à System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
à System.Windows.Forms.Control.InvokeMarshaledCallbacks()
à System.Windows.Forms.Control.WndProc(Message& m)
à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
à System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
à System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
à Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
à Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
à Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
à Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
à Microsoft.PowerBI.Client.Program.Main(String[] args)
OS Version:
Microsoft Windows NT 10.0.19041.0 (x64 fr-CA)
CLR Version:
4.7 or later [Release Number = 528372]
Peak Virtual Memory:
102 GB
Private Memory:
501 MB
Peak Working Set:
696 MB
IE Version:
11.789.19041.0
User ID:
72a521c5-42bf-4ea0-8569-1d36ef400064
Workbook Package Info:
1* - fr-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
AS Live Connection:
True
Performance Trace Logs:
C:\Users\jgagnon\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip
Enabled Preview Features:
PBI_compositeModelsOverAS
PBI_rdlNativeVisual
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_dynamicParameters
PBI_enhancedTooltips
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |