SSAS Tabular Incremental Processing Causes Blank Date Value

Tim Menard 1 Reputation point
2021-11-19T13:08:33.087+00:00

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\""
]
}
}
]
}
]
}
}

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,310 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,891 Reputation points
    2021-11-22T02:30:41.26+00:00

    Hi @Tim Menard ,

    Welcome to Microsoft Q&A!

    Please refer to this blog to get the detail steps of incremental processing.

    Best regards,
    Carrin


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.