Training model builder error for Forecasting due to datetime

[vzhuqin]

System Information (please complete the following information):

• Model Builder Version (available in Manage Extensions dialog): 16.13.2.2211002
• Microsoft Visual Studio Enterprise 2022 (64-bit) Version 17.0.6

Describe the bug

• On which step of the process did you run into an issue: Forecasting>Training error

Data source
https://github.com/dotnet/machinelearning-samples/raw/main/samples/csharp/getting-started/Forecasting_BikeSharingDemand/BikeDemandForecasting/Data/DailyDemand.mdf

To Reproduce
Steps to reproduce the behavior:

1. Select Create a new project from the Visual Studio 2022 start window;
2. Choose the C# Console App (.NET Core) project template with .Net 6.0;
3. Add model builder by right click on the project;
4. Select Forecasting and input above data source;
5. Set "TotalRentals" as Label, "Rental Data" as Time series;
6. Start training, prompts model builder error that: Unable to cast object of type 'System.DateTime' to type 'System.String

Expected behavior
No error during training.

Screenshots
Data settings:

Error screenshot:

Additional context
Error message:
at System.Data.SqlClient.SqlBuffer.get_String()
at Microsoft.ML.Data.DatabaseLoader.Cursor.<>c__DisplayClass38_0.b__0(ReadOnlyMemory`1& value)
at Microsoft.Data.Analysis.StringDataFrameColumn.AddValueUsingCursor(DataViewRowCursor cursor, Delegate getter)
at Microsoft.ML.IDataViewExtensions.ToDataFrame(IDataView dataView, Int64 maxRows, String[] selectColumns)
at Microsoft.ML.ModelBuilder.AutoMLService.Proposer.ResampleStrategyProposer.InitializeForecasting(TrialParameter trialParameter) in //src/Microsoft.ML.ModelBuilder.AutoMLService/Proposer/ResampleStrategyProposer.cs:line 127
at Microsoft.ML.ModelBuilder.AutoMLService.Proposer.ResampleStrategyProposer.Propose(TrialParameter trialParameter) in //src/Microsoft.ML.ModelBuilder.AutoMLService/Proposer/ResampleStrategyProposer.cs:line 51
at Microsoft.ML.ModelBuilder.AutoMLService.Proposer.Controller.Propose() in //src/Microsoft.ML.ModelBuilder.AutoMLService/Proposer/Controller.cs:line 66
at Microsoft.ML.ModelBuilder.AutoMLService.Experiments.LocalAutoMLExperiment.d__15.MoveNext() in //src/Microsoft.ML.ModelBuilder.AutoMLService/Experiments/LocalAutoMLExperiment.cs:line 163
--- 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.ML.ModelBuilder.AutoMLEngine.d__21.MoveNext() in /_/src/Microsoft.ML.ModelBuilder.AutoMLService/AutoMLEngineService/AutoMLEngine.cs:line 160

[cmckechney]

I am having the exact same error. ML 2022 and VS2022 w/ SQL Server data column

[beccamc]

Just checked this with the addition of DateTime type and it looks like it's blocked by the DataFrame bug - dotnet/machinelearning#6213

[beccamc]

Duplicate of #2166. This fix will ship in the Fall Model Builder release.