Forum Discussion
Incremental refresh with left join
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 I do not believe that joining two tables in SQL necessarily creates a non-foldable query. Give it a shot and see if you can see the native query. It's worth the 10 minutes it would take to write the join SQL syntax.
https://docs.microsoft.com/en-us/power-query/power-query-folding
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding