Natives Queries or ODBC with Incremental Refresh in Power BI

Are you wanting to use Incremental Refresh in Power BI but need to use ODBC, native queries or something that doesn’t fold properly? Adam shows you a solution for Power BI Desktop and Power BI dataflows!

Native Queries
https://docs.microsoft.com/power-query/native-database-query

Using Incremental Refresh with dataflows
https://docs.microsoft.com/power-query/dataflows/incremental-refresh

Configure Increment Refresh for Datasets (includes DateKey function)
https://docs.microsoft.com/power-bi/connect-data/incremental-refresh-configure