Error when opening PBIX file with, cannot open the file in PowerBI Desktop

[Anonymous]

I cannot open a PBIX file. 

It said that PowerBI cannot save modifications to the server because of

User Cannot Log In.

Is there any solution to fix this?

I tried things such as:

1. Editing the current credentials in Data Source Settings -> Global Permissions.
2. Refreshing the dataset in the PowerBI Portal.
3. Checking whether the gateway is running.

*Thank you in advance

The details are as follows:

Feedback Type:
Frown (Error)

Error Message:
Failed to save modifications to the server. Error returned: 'ユーザー '' はログインできませんでした。. The exception was raised by the IDbConnection interface.
A connection could not be made to the data source with the Name of '52fd81aa-0b55-433a-aad6-3b9b7793a961'.
ユーザー '' はログインできませんでした。. The exception was raised by the IDbConnection interface.
A connection could not be made to the data source with the Name of '52fd81aa-0b55-433a-aad6-3b9b7793a961'.
'.

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.<>c__DisplayClass14_0.<Commit>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(Boolean preventRecalc)
at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ExtendedModelChangeScopeBase.ExecuteChange(ModelChange modelChange, Boolean saveChange, Boolean preventRecalc)
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.AnalysisServices.AnalysisServicesDatabaseLocal.UpdateMashupProviderGlobalPipeReferences(String newGlobalPipeName)
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.Windows.Services.FileOperationUIHandler.OpenFileInternal(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IQueryServices queryServices, IOpenSaveUI openSaveUI, TelemetryUserActionId entryPoint, IPbixFile pbixFile, Boolean fromRecentFile)
at Microsoft.PowerBI.Client.Windows.Services.FileOperationUIHandler.OpenLocalFile(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IQueryServices queryServices, TelemetryUserActionId entryPoint, String filePath, Boolean fromRecentFile)
at Microsoft.PowerBI.Client.Windows.FileCommands.OpenFileLocal(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, OpenFileCommandParameter openParameters)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
Failed to save modifications to the server. Error returned: 'ユーザー '' はログインできませんでした。. The exception was raised by the IDbConnection interface.
A connection could not be made to the data source with the Name of '52fd81aa-0b55-433a-aad6-3b9b7793a961'.
ユーザー '' はログインできませんでした。. The exception was raised by the IDbConnection interface.
A connection could not be made to the data source with the Name of '52fd81aa-0b55-433a-aad6-3b9b7793a961'.
'.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.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 Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>c__DisplayClass4_0.<.ctor>b__0(Object arg)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.<Execute>d__10.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parameter)
at Microsoft.Practices.Prism.Commands.DelegateCommand`1.<Execute>d__5.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.Practices.Prism.Commands.DelegateCommand`1.Execute(T parameter)
at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)
at Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
at Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)
at Microsoft.PowerBI.Client.Windows.Ribbon.ApplicationRibbonCommandActionHandler.OpenRecentFile(UInt32 itemIndex, String itemLabel)
at Microsoft.Mashup.Client.UI.Windows.Ribbon.RibbonCommandHandler.Execute(UInt32 commandId, CommandExecutionVerb verb, PropertyKeyRef keyRef, PropVariantRef currentValue, IUISimplePropertySet commandExecutionProperties)
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.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
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)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

Model Default Mode:
Empty

Snapshot Trace Logs:
C:\Users\rahman\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1775376144.zip

Performance Trace Logs:
C:\Users\rahman\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_keyDrivers
PBI_userFavoriteResourcePackagesEnabled

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBINonFatalError_MethodDefDescription:
-1055784933,-1055784824,-1055784933,-1055784824

ModelChangeResult:
{"changes":[{"updateDataSourceConnectionString":{"dataSource":"8cb0db32-efec-4212-9bf3-f028eda7ea93","connectionString":"provider=Microsoft.PowerBI.OleDb;global pipe=adab166d-097f-4f91-bf98-2b7d20fb1c6f;mashup=UEsDBBQAAgAIAICMCE/0F9hLqgAAAPoAAAASABwAQ29uZmlnL1BhY2thZ2UueG1sIKIYACigFAAAAAAAAAAAAAAAAAAAAAAAAAAAAIWPPQ6CMBzFr0K600IRFfKnDG5GEhIT49qUClUoBorlbg4eyStIohg3t/fxG9573h+Qjk3t3GTXq1YnyMcecqQWbaF0maDBnNw1ShnkXFx4KZ0J1n089kWCKmOuMSHWWmwD3HYloZ7nk2O224tKNhx9YfUfdpXuDddCIgaH9xhG8crHYUgDHC18IHMMmdKznnoc0GiJPSA/MWyG2gydZGfubnMgswXy+cFeUEsDBBQAAgAIAICMCE8PyumrpAAAAOkAAAATABwAW0NvbnRlbnRfVHlwZXNdLnhtbCCiGAAooBQAAAAAAAAAAAAAAAAAAAAAAAAAAABtjksOwjAMRK8SeZ+6sEAINWUB3IALRMH9iOajxkXhbCw4ElcgbXeIpWfmeebzelfHZAfxoDH23inYFCUIcsbfetcqmLiRezjW1fUZKIocdVFBxxwOiNF0ZHUsfCCXncaPVnM+xxaDNnfdEm7LcofGOybHkucfUFdnavQ0sLikLK+1GQdxWnNzlQKmxLjI+JewP3kdwtAbzdnEJG2UdiFxGV5/AVBLAwQUAAIACACAjAhPrLagW8IBAAD4AgAAEwAcAEZvcm11bGFzL1NlY3Rpb24xLm0gohgAKKAUAAAAAAAAAAAAAAAAAAAAAAAAAAAAbVLLbtNAFN1Hyj+MzGYsLEulaahUdUGTggCJNLEp1FEVDfZNOjCPMnOdB1GW8C3s+aZKfAYzjOOqVe/G8rmPc+65Y6FErhXJwvfgpNvpduwNM1CRTBscmQoMOSUCsNshLjJdmxIckrMvAtLXRsuJXln6zmqVDnVZS1BIz7hiZpMOodTy1oC1e8TX57BGGvHe0ScwhTg8Xr5Zf9T9TBfvbW4m2bfnn/NDub76+n3MVrkEPR7KslgcLUd4kR2/eDkuNnkx4Ver89MoIWHuuSp1xdUiPWMW+r04IYOGmHtZMBcMIXaw24PM0MmnFDe3QNBpiYkEZGSageFM8B9QpV6iK0JTw3VMuCKh2K9Mpne/fv79/efA5WeYkL1DM7yOk+DRs2hww9TCWZi7tqg1KzdM2bk2cqBFLZVPWhoMTbbbqJnrlmql7RKyjf4zOPStwn4v9V273Z7qVY16AlIvoQpDrdcVcu3NfOCDk10yUQN9pDMhU+cUqwWGUR+Y9IeO2ncQtRv6MIG2nRtkNCqocybADTCaew4Pb++9bDY17pmYqvkR3OIujgMPV/d8T3roNVraSHGUzrN0IIApN2Df/IRHJ/8AUEsBAi0AFAACAAgAgIwIT/QX2EuqAAAA+gAAABIAAAAAAAAAAAAAAAAAAAAAAENvbmZpZy9QYWNrYWdlLnhtbFBLAQItABQAAgAIAICMCE8PyumrpAAAAOkAAAATAAAAAAAAAAAAAAAAAPYAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAACAAgAgIwIT6y2oFvCAQAA+AIAABMAAAAAAAAAAAAAAAAA5wEAAEZvcm11bGFzL1NlY3Rpb24xLm1QSwUGAAAAAAMAAwDCAAAA9gMAAAAA;location=SortOrder"}}],"hasQueryImpact":true}

Formulas:

section Section1;

[v-yuta-msft]

@Anonymous ,

Could you please let me know if you have you solved this issue currently?

Regards,

Jimmy Tao

[v-yuta-msft · Accepted solution]

@Anonymous ,

Firstly, please check if the power bi desktop has been updated to the latest version. 

If you mean you can't login SSAS in power bi desktop. Please check if credentails is valid and if the AS instance is in the same domain. Also, check if the AD you use has been added as an admin account of AS instance.

 

And if you mean you can't sign in power bi account. Please check if you have configured any proxy settings or change the firewall block list? This issue seems to be related to the network settings of your server.   Please whitelist the domains below:

• app.powerbi.com
• api.powerbi.com
• domains in the *.analysis.windows.net namespace

Regards,

Jimmy Tao