Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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