Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Since Power BI April 2019, I can´t open one my Power BI desktop files.
The error starts with:
"Failed to save modifications to the server. Error returned: 'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. A circular dependency was detected: ..."
The file worked fine this morning, and when tried to open it later this evening after installing the April updated, I have not been able to open it.
Other files I have tried work fine.
Thanks in advance for your help.
Feedback Type:
Frown (Error)
Timestamp:
2019-04-10T21:28:44.6977567Z
Local Time:
2019-04-10T23:28:44.6977567+02:00
Session ID:
241e5ba3-7f5a-406e-bbb2-54787b4c1ac4
Release:
April 2019
Product Version:
2.68.5432.661 (19.04) (x64)
Stack Trace:
at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
at Microsoft.PowerBI.Modeler.ModelManager.SaveChanges(String description)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<Commit>b__14_0()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit()
at Microsoft.PowerBI.Client.Windows.ReportUpgrader.<>c__DisplayClass3_0.<Upgrade>b__0(IExtendedModelChangeScope scope)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.RunOutOfBandExtendedModelChange(Action`1 extendedModelChange, IAnalysisServicesDatabase analysisServicesDatabase, IModelManager modelManager, Boolean requireASDBToBeUnattached)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.RunOutOfBandExtendedModelChangeCore(Action`1 extendedModelChange, Boolean requireASDBToBeUnattached)
at Microsoft.PowerBI.Client.Windows.ReportUpgrader.Upgrade(Report report, String fileName, Version pbixFileVersion)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.UpgradeModel(Report report, IPowerBIWindowService windowService, String fileName, Version pbixFileVersion)
at Microsoft.PowerBI.Client.Windows.ReportPreparer.Prepare(Report report, PackageValidationResult mashupResult, IPowerBIWindowService windowService, String fileName, Nullable`1 entryPoint, Version pbixFileVersion)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIPackagingService.Open(FileStream fileStream, IPowerBIWindowService windowService, Nullable`1 entryPoint, PowerBIPackageOpenOptions options, ReportPreparerResult& prepareResult)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.<LoadFromPbix>d__20.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.<>c__DisplayClass15_0`1.<<BlockUIAndRun>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.WaitOnUIThreadForTaskCompletion(Task task)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.BlockUIAndRun[T](Func`1 asyncMethod)
at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(IPowerBIWindowService windowService, IPbixFile fileToOpen, Nullable`1 entryPoint)
at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IUIHost uiHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, String filePath, FileType fileType)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 es-ES)
CLR Version:
4.7 or later [Release Number = 461808]
Peak Virtual Memory:
37.2 GB
Private Memory:
209 MB
Peak Working Set:
297 MB
IE Version:
11.706.17134.0
User ID:
f7a3321a-a745-4a9c-acd0-1908053ffbe9
Telemetry Enabled:
True
DPI Scale:
125%
Supported Services:
Power BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.