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

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.

Not able to open PBIX file. It's giving error while opening file

Error: 

Feedback Type:
Frown (Error)

Timestamp:
2019-02-20T05:31:57.8750355Z

Local Time:
2019-02-19T21:31:57.8750355-08:00

Session ID:
8f161f0e-2622-4d7a-8062-b41ab684b2ea

Release:
March 2019

Product Version:
2.67.5404.221 (19.03) (x64)

Stack Trace:
at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
at System.Collections.Generic.List`1.Enumerator.MoveNextRare()
at Microsoft.Mashup.Host.Document.FormulaRegistry.<GetBuiltInFormulas>d__1.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaSet.FilteredFormulaSet.<GetFormulas>d__2.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaRegistry.<GetPotentialFormulasCore>d__19.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaRegistry.<GetPotentialFormulas>d__16.MoveNext()
at Microsoft.Mashup.Host.Document.FormulaRegistry.TryGetFormula(FormulaSet formulaSet, FormulaReference formulaReference, FormulaResult baseResult, Formula& formula)
at Microsoft.Mashup.Host.Document.FormulaRegistry.GetFormula(FormulaSet formulaSet, FormulaReference formulaReference, FormulaResult baseResult)
at Microsoft.Mashup.Client.UI.Shared.QueryExtensions.<>c__DisplayClass26_0.<IsCubeDirectQuery>b__0(PackageEditor packageEditor)
at Microsoft.Mashup.Host.Document.Model.Queries.<>c__DisplayClass156_0.<InvokeWithReadOnlyPackageEditor>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.InvokeWithReadOnlyPackageEditor(Action`1 action)
at Microsoft.Mashup.Client.UI.Shared.QueryExtensions.IsCubeDirectQuery(Query query)
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source, Func`2 predicate)
at Microsoft.PowerBI.Client.Windows.Report.UpdateCurrentDataProviderCapabilities()
at Microsoft.PowerBI.Client.Windows.Report..ctor(PackagePath packagePath, String reportViewDocumentContent, ReportVersionCompatibilityFlags versionCompatibility, ConnectionsSettings connectionSettings, CustomVisualCollection customVisuals, String diagramViewState, ReportLinguisticSchema linguisticSchema, ReportMetadata metadata, ReportSettings reportSettings, StaticResourceCollection staticResources, String diagramLayout)
at Microsoft.PowerBI.Client.Windows.Services.ReportFactory.CreateReportFromPowerBIPackage(IPowerBIPackage powerBIPackage, String pbixFilePath, Byte[] securityBindings, Boolean requiresConversionToReportLayout, PowerBIPackageOpenOptions options, IPowerBITelemetryService powerBITelemetryService, IAnalysisServicesService analysisServices, 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__19.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.17763.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461814]

Peak Virtual Memory:
37.3 GB

Private Memory:
157 MB

Peak Working Set:
224 MB

IE Version:
11.316.17763.0

User ID:
11060467-0d23-436b-ab15-a927adccd60c

Telemetry Enabled:
True

DPI Scale:
100%

Supported Services:
Power BI

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @v-alshah ,

 

It looks like the issue happens when you use Windows store version Power BI desktop to open the report? 

 

Does the issue happen to this specific pbix file only? If only this report has the issue and the report is getting data in Import mode, please share the pbix file with us. If possible, you can upload it to your OneDrive and send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Needs Info