When processing full, the dates are populated, when running XMLA script below to process, there are values in the table, but dates in the same table are blank... any thoughts what might cause this?
{
"refresh":{
"type":"add",
"objects":[
{
"database":"My_Database",
"table":"Pipeline",
"partition":"Partition"
}
],
"overrides":[
{
"partitions":[
{
"originalObject":{
"database":"My_Database",
"table":"Pipeline",
"partition":"Partition"
},
"source":{
"type":"m",
"expression":[
"let",
" Source = #\"Odbc/dsn=SnowflakeODBC\",",
" Database = Source{[Name=\"DatabaseName\",Kind=\"Database\"]}[Data],",
" DW_Schema = DatabaseName{[Name=\"DW\",Kind=\"Schema\"]}[Data],",
" view_fctOpportunity_View = DW_Schema{[Name=\"view_fctOpportunity\",Kind=\"View\"]}[Data],",
" #\"Removed Other Columns\" = Table.SelectColumns(view_fctOpportunity_View,{ \"OpportunityId\",\"ProductSkey\",\"AccountSkey\",\"OpportunityAmount\",\"OpportunitySubscriptionAmount\",\"OpportunityServiceAmount\",\"OpportunityLineQuantity\",\"StageName\",\"Team\",\"NewBookingsAmount\",\"FromTestAccount\",\"RemoveFromPipeline\",\"ForecastCategory\",\"LeadSource\",\"SalesRepSkey\",\"CloseDate\",\"CreatedDate\",\"SalesRepUserSkey\",\"OwnerUserSkey\",\"SnapshotDate\",\"HasOpportunityLineItem\",\"RevenueType\",\"Name\",\"BookingsType\",\"OwnerName\",\"NewLogoSale\",\"ContainsHRMS\",\"DealSize\",\"SalesTeam\",\"GTM\",\"SalesRegion\",\"SolutionConsultant_Name\",\"SDR_Name\",\"MarketingGeneratedLeadText\",\"RFP\",\"AccountSkey_EndUser\",\"EndUserId\",\"Age\",\"NextStep\",\"ItemId\",\"PipelineIndex\",\"PipelineAddDate\",\"SalesGuidanceCategory\"}),",
" #\"Filtered Rows\" = Table.SelectRows(#\"Removed Other Columns\", each ([SnapshotDate] = #date(2021, 11, 15)))",
"in",
" #\"Filtered Rows\""
]
}
}
]
}
]
}
}