Forum Discussion
Incremental refresh with left join
joshua1990 - Well, you can do a left join in Power Query Editor using a Merge query. Not sure I 100% understand the dilemma with incremental refresh and such.
I mean, from a performance point of view I would do the join within a individual sql statement, right?
But that would also mean I can't add an incremental refresh in the end, right?
I guess I have to do all operations in Power Query.
joshua1990 - If you want to only load the main table once and do incremental on the ledger, then yes I would think you would need to do that in Power Query and then the Merge there. Alternatively, if you did the join in SQL as a view perhaps, could you do an incremental against that view? I'm not sure I see why not exactly but I may not be thinking it through 100%
Thank you so much for your support Greg_Deckler !
I have just read only rights in our data warehouse.
If I join the two tables in a sql I am working on a non foldable query, right?
that would mean I can't add an incremental refresh.
my question is: If I want to add an incremental refresh have I to use M to join two tables?
Or can I join two tables within a SQL select and then add an incremental refresh?
