Forum Discussion
Anonymous
4 years agoNot applicable
Incremental load with joins in Query
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
Yes, as long as RangeStart and RangeEnd are part of the query conditions.
1 Reply
- lbendlin
Super User
Yes, as long as RangeStart and RangeEnd are part of the query conditions.