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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Since Power BI April 2019 update I can´t open file

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

Status: Needs Info
Comments
v-yulgu-msft
Employee

Hi @Anonymous ,

 

Upload this .pbix file onto Power BI Service, test if it can be opened on service site. Then, download it locally, and open it via Power BI desktop to see if it works.

 

Regards,

Yuliana Gu

v-yulgu-msft
Employee
Status changed to: Needs Info