INCREMENTAL REFERSH IN MYSQL DATABASE

[Pramod2699]

Hi i am trying to use incremental refresh on my power bi (pro) with mysql database i manage to active native query, and used parametrs for rangestart and end  to my table but still i could not able to use incremental refresh for my reports

[Greg_Deckler · Accepted solution]

@Pramod2699 Incremental refresh only works with data sources that support query folding and MySQL does not:

Power BI data sources - Power BI | Microsoft Docs

[Jen-CSG]

Greg, the link you provided doesn't mention query folding at all. The only 'No' for MySQL is in the DirectQuery/Live Connection column, which is a different animal. 

When I look at my queries (in Desktop), I appear to have query folding working just fine (until I try something that breaks it, like doing an append).

[Greg_Deckler]

 This is where that came from and I may have misread it a bit. But, still needs query folding and if you break it I don't think it will work according to this:Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

Supported data sources

Incremental refresh and real-time data works best for structured, relational data sources, like SQL Database and Azure Synapse, but can also work for other data sources. In any case, your data source must support the following:

Date column - The table must contain a date column of date/time or integer data type. The RangeStart and RangeEnd parameters (which must be date/time data type) filter table data based on the date column. For date columns of integer surrogate keys in the form of yyyymmdd, you can create a function that converts the date/time value in the RangeStart and RangeEnd parameters to match the integer surrogate keys of the date column. To learn more, see Configure incremental refresh - Convert DateTime to integer.

Query folding - Incremental refresh is designed for data sources that support query folding, which is Power Query's ability to generate a single query expression to retrieve and transform source data, especially if getting the latest data in real time with DirectQuery. Most data sources that support SQL queries support query folding. Data sources like flat files, blobs, and some web feeds often do not.

@Jen-CSG