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 - 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.