Cannot open dataset: something went wrong, unexpected failure

[Anonymous]

I cannot open my dataset with PowerBI Desktop even though it was working fine before, and even now is working normally in PBI service and I can connect to it live.

When I try to openn it I get the error: Something went wrong, unexpected failure

here is the trace of the error:

Feedback Type:
Frown (Error)

Error Message:
Unexpected failure: 

Stack Trace:
   at Microsoft.Mashup.Host.Document.OperationResult.ThrowIfFailed()
   at Microsoft.PowerBI.Client.Windows.Modeling.Utilities.ModelingMashupDocumentBuilder.<>c__DisplayClass18_0.<BuildQueries>b__2(PackageEditor packageEditor)
   at Microsoft.Mashup.Host.Document.Model.Queries.<>c__DisplayClass155_0.<InvokeWithWritablePackageEditor>b__0(PackageEditor packageEditor)
   at Microsoft.Mashup.Host.Document.Model.Queries.InvokeWithPackageEditor[T](Nullable`1 changeReason, Func`2 action)
   at Microsoft.Mashup.Host.Document.Model.Queries.InvokeWithWritablePackageEditor(ChangeReason changeReason, Action`1 action)
   at Microsoft.PowerBI.Client.Windows.Modeling.Utilities.ModelingMashupDocumentBuilder.BuildQueries()
   at Microsoft.PowerBI.Client.Windows.Modeling.Utilities.ModelingMashupDocumentBuilder.BuildRestorationInput()
   at Microsoft.PowerBI.Client.Windows.Modeling.Utilities.MashupQueryGenerator.GenerateRestorationInputFromModel(IDataModel dataModel, QueriesSettings queriesSettings)
   at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.CreateReportFromPowerBIPackage(IPowerBIPackage powerBIPackage, String pbixFilePath, Byte[] securityBindings, Boolean requiresConversionToReportLayout, PowerBIPackageOpenOptions options, IPowerBITelemetryService powerBITelemetryService, IAnalysisServicesService analysisServices, Version pbixFileVersion, PackageValidationResult& mashupValidationResult)
   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__DisplayClass1_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)

Stack Trace Message:
Unexpected failure: 

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.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.82.5858.641","ModuleName":"Microsoft.Mashup.Document.dll","Component":"Microsoft.Mashup.Host.Document.OperationResult","Error":"System.InvalidOperationException","MethodDef":"ThrowIfFailed","ErrorOffset":"34"}

[Anonymous]

mething looks similar here:

https://community.powerbi.com/t5/Issues/Can-t-open-Power-BI-after-June-2020-update-quot-We-weren-t-a...

probably an issue with June version

[Anonymous]

I think I found the root cause. every time I invoke an Azure machine learning service inside PBI Desktop and save the file, this error happens.

Microsoft, do you know why??

Regards

[deepak91g]

Hi @Anonymous 

You can download PBIX from PBI Service and try opening that in Power BI desktop. Looks like, original file is corrupted ( not sure).

Link for how to download PBIX from powerbi.com (if its previously published)

https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix

Thanks

Deepak

[Anonymous]

Thanks Deepak, but that's exactly what I tried already and I get the error once I try to open the donloaded pbix file.

I can understand if the working file gets corrupted, but the freshly downloaded file from the service? doesn't sound likely

[deepak91g]

Hi @Anonymous  Do you have access to another computer? If yes, try downloading and opening PBIX on a different computer.

[amitchandak]

@Anonymous , Have you downgraded the PBI version? Is this error with the latest version or issue after it upgraded to the latest version.

If the version is old, try with the latest version

[Anonymous]

@amitchandak , I am working with latest version (June 2020). I did many changes on the dataset during this week with the same PBI version. 

[amitchandak]

@Anonymous , Check and log issue at https://community.powerbi.com/t5/Issues/idb-p/Issues