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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Ben32876
Frequent Visitor

Power BI error on Initilizing model

I isntalled Power BI today and it fails to start with error (pasted below). 

 

Please help, thanks!

 

Timestamp:
2017-05-20T02:58:06.0601168Z

Local Time:
2017-05-19T22:58:06.0601168-04:00

Product Version:
2.39.4526.362 (PBIDesktop) (x64)

Release:
September 2016

IE Version:
11.1198.14393.0

OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 en-US)

CLR Version:
4.6.2. or later [Release Number = 394802]

Peak Working Set:
197 MB

Private Memory:
153 MB

Peak Virtual Memory:
33.3 GB

Error Message:
Input string was not in a correct format.

Stack Trace:
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
   at Microsoft.AnalysisServices.Tabular.ImpactDataSet..ctor(DataSet data, Dictionary`2 attributes)
   at Microsoft.AnalysisServices.Tabular.ExecuteUtil.RunCommand(String commandText, IEnumerable`1 parameters, Boolean requestImpact, Int64 impactSinceVersion, Server server, ImpactDataSet& impactDataSet)
   at Microsoft.AnalysisServices.Tabular.ExecuteUtil.TryExecuteXmla(String xmlaRequest, Database db, Model model, TxManager txManager, XmlaResultCollection& xmlaResults)
   at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
   at Microsoft.PowerBI.Modeler.DateTableSubsystem.CreateDateTableTemplate(DateTableDefinition definition)
   at Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables()
   at Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableAutomaticLocalDateTables()
   at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass13.<ExecuteChange>b__12()
   at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange)
   at Microsoft.PowerBI.Client.Windows.ReportUpgrader.EnableTimeIntelligenceAndUpdateSchema(IDataModel dataModel, IOutOfBandModelAuthoringTransaction transaction)
   at Microsoft.PowerBI.Client.Windows.ReportUpgrader.Upgrade(Report report)
   at Microsoft.PowerBI.Client.Windows.Report.Upgrade()
   at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(String filePathToOpen, IWin32Window ownerWindow, ReportUpgradeResult& upgradeResult)
   at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(WindowsHost windowsHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, IPowerBIStringProvider stringProvider, String filePath, PBIWinLoadPBIAppAction loadEvent, Report& report, String& importFromExcelFilePath, String& templateFilePath, String& autoRecoveredFilePath, ReportUpgradeResult& upgradeResult)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)

2 REPLIES 2
v-caliao-msft
Microsoft Employee
Microsoft Employee

@Ben32876,

 

Why do you install September 2016 version Power BI desktop. Currently, the latest version of Power BI desktop is May 2017 (Version:2.46.4732.721). Please try to install it and check if this issue persists or not. The latest version of Power BI is available on the link below.
https://powerbi.microsoft.com/en-us/desktop/

 

Regards,

Charlie Liao

It was the 64bit version I downloaded from the site yesterday. I also tried 32bit version (similar error below) and 64 bit on different computer (but same account). Looks liek powerbi tries to load some old model and fails.

Feedback Type:
Frown (Error)

Timestamp:
2017-05-22T05:44:36.5731000Z

Local Time:
2017-05-22T01:44:36.5731000-04:00

Product Version:
2.46.4732.721 (PBIDesktop) (x86)

Release:
May 2017

IE Version:
11.1198.14393.0

OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 en-US)

CLR Version:
4.6.2. or later [Release Number = 394802]

Peak Working Set:
157 MB

Private Memory:
124 MB

Peak Virtual Memory:
767 MB

Error Message:
Input string was not in a correct format.

Stack Trace:
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt64(String value, NumberStyles options, NumberFormatInfo numfmt)
   at Microsoft.AnalysisServices.Tabular.ImpactDataSet..ctor(DataSet data, Dictionary`2 attributes)
   at Microsoft.AnalysisServices.Tabular.ExecuteUtil.RunCommand(String commandText, IEnumerable`1 parameters, Boolean requestImpact, Int64 impactSinceVersion, Server server, ImpactDataSet& impactDataSet)
   at Microsoft.AnalysisServices.Tabular.ExecuteUtil.TryExecuteXmla(String xmlaRequest, Database db, Model model, TxManager txManager, XmlaResultCollection& xmlaResults)
   at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveOptions saveOptions)
   at Microsoft.AnalysisServices.Tabular.Model.SaveChanges(SaveFlags saveFlags)
   at Microsoft.PowerBI.Modeler.DateTableSubsystem.CreateDateTableTemplate(DateTableDefinition definition)
   at Microsoft.PowerBI.Modeler.DateTableSubsystem.SynchronizeLocalDateTables()
   at Microsoft.PowerBI.Modeler.DateTableSubsystem.EnableAutomaticLocalDateTables()
   at Microsoft.PowerBI.Modeler.ModelManager.EnableAutomaticLocalDateTables()
   at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Visit(SetTimeIntelligenceSchemaChange schemaChange)
   at Microsoft.PowerBI.Client.Windows.Modeling.SetTimeIntelligenceSchemaChange.Accept(ISchemaChangeVisitor visitor)
   at Microsoft.PowerBI.Client.Windows.Modeling.SchemaChangeApplier.Apply(IModelManager modelManager, IEnumerable`1 changes)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.<>c__DisplayClass13.<ExecuteChange>b__12()
   at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringExceptionHandler.AddModelChangeResultToExceptions(Action action, ModelChangeResult modelChangeResult)
   at Microsoft.PowerBI.Client.Windows.Modeling.AsyncModelAuthoringService.ModelAuthoringTransaction.ExecuteChange(ModelChange modelChange)
   at Microsoft.PowerBI.Client.Windows.ReportUpgrader.EnableTimeIntelligenceAndUpdateSchema(IDataModel dataModel, IOutOfBandModelAuthoringTransaction transaction)
   at Microsoft.PowerBI.Client.Windows.ReportUpgrader.Upgrade(Report report)
   at Microsoft.PowerBI.Client.Windows.Report.Upgrade()
   at Microsoft.PowerBI.Client.Windows.Services.FileManager.OpenFile(ILiveConnectionPropertiesValidator validator, String filePathToOpen, ReportUpgradeResult& upgradeResult)
   at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(WindowsHost windowsHost, ISplashScreen splashScreen, IFileManager fileManager, IFileHistoryManager fileHistoryManager, IPowerBIStringProvider stringProvider, String filePath, PBIWinLoadPBIAppAction loadEvent, Report& report, String& importFromExcelFilePath, String& templateFilePath, String& autoRecoveredFilePath, ReportUpgradeResult& upgradeResult)
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassd.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
ced67481-4cda-4f33-ab53-02c18c0ca522

Session ID:
4eaa62e0-3b82-438c-b1e8-bd0537afeee6

Telemetry Enabled:
True

ModelChangeResult:
{"changes":[{"setTimeIntelligence":{"enabled":true}}]}

ModelChangeResultSerializationErrors:
Error getting value from 'IsSchemaChangeListComplete' on 'Microsoft.PowerBI.Client.Windows.Modeling.ModelChangeResult'.
Error getting value from 'HasQueryImpact' on 'Microsoft.PowerBI.Client.Windows.Modeling.ModelChangeResult'.

DPI Scale:
100%

Supported Services:
Power BI

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors