Snowflake connector 2.0 crashes with timestamp_tz(3) columns

[Paul_J_Keenan]

Using the July release.  Can trigger each time with

let
Source = Value.NativeQuery(Snowflake.Databases("xxxxx.us-east-2.aws.snowflakecomputing.com","CORP_USER_WH",[Implementation="2.0", Role="xxxxx"]){[Name="INSIGHT"]}[Data], "select '2025-08-12 20:45:34.123 +00:00'::timestamp_tz(3) as timestamp_tz_3", null, [EnableFolding=true])
in
Source

Changing to Implementation="1.0" is enough to make the problem go away.
--

pjk

Feedback Type:
Frown (Error)

Timestamp:
2025-08-12T19:46:13.9455550Z

Local Time:
2025-08-12T20:46:13.9455550+01:00

Session ID:
1a91a19f-a096-4810-b7d9-9010fe262005

Release:
August 2025

Product Version:
2.146.705.0 (25.08)+b71502aff0a01340c88f384884ef42771068f115 (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.146.705.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""}

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-GB)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
71.6 GB

Private Memory:
1.03 GB

Peak Working Set:
1.27 GB

IE Version:
11.3636.19041.0

User ID:
09d326fd-1a24-4c46-a5e1-d0419e40575a

Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_googleBigQueryAdbcVersionEnabled
PBI_scorecardVisual
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_odspSaveBackgroundUpload
PBI_modernOfficeFilePicker
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_directLakeRemoteModeling
PBI_directLakeOnOneLake
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_visualCalculationsAuthoring
PBI_tmdlViewToggle
PBI_copilotUnifiedTooling
PBI_UserInstalledVerticaODBCDriver
PBI_sqlDbNativeArtifactsOnDesktop

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_publishDialogsSupportSubfolders
PBI_enhancedReportFormat
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_qnaImproveLsdlCopilot
PBI_UserInstalledNetezzaODBCDriver
MashupFlight_EnableOracleBundledOdacProvider
PBI_dataFunctionActions

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
150%

Supported Services:
Power BI

WebView2 Runtime Version:
139.0.3405.86

WebView2 SDK Version:
1.0.2365.46