Incremental load with joins in Query

[mikro87]

Hello everybody,

I would like to know if a query with a join like this will work with the incremental load in PowerBI:

SELECT 
[TransactionDateDimCalendarId], 
b.[Date], 
a.LastUpdate ,
*
FROM [CT dwh 03 Intelligence].[sales].[tFactOrder] as a
join [CT dwh 03 Intelligence].[dim].[tDimCalendar] as b
on a.TransactionDateDimCalendarId = b.DimCalendarId

Then I would filter date for current year and LastUpdate for the incremental load. 

Will this work?

Thanks

mikro87

[lbendlin · Accepted solution]

Yes, as long as RangeStart and RangeEnd are part of the query conditions.