Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Yes, as long as RangeStart and RangeEnd are part of the query conditions.
Yes, as long as RangeStart and RangeEnd are part of the query conditions.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.