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?joshua1990 - do NOT use the Advanced Query feature in Power BI where you can enter a SQL statement. It prohibits all further query folding and Incremental Refresh will not work. It seems that might be what you are doing, but you haven't specifically said.
Either create a View in SQL Server and connect Power BI to that, or do all of it in the Power query editor itself. It will fold just fine.
If this doesn't help, please post back with what you are specifically doing all the way through.
