Query Folding with MySQL

[Varishtha]

My data sits in MySql and I want to use incremental refresh feature, but it seems like my queries are not foldable. I checked every step in power query and 'View Native Query' option was greyed out for all steps, which means at no step can my query be folded. I read somewhere that without foldable queries incremental refresh is useless. How can I get around this?

Also can i use incremental refresh on more than 1 table inthe same power bi file?

[edhans · Accepted solution]

According to Query folding on native queries - Power Query | Microsoft Learn MySQL isn't supported for Query Folding, so this will not work. I am not aware of any way around it. To fold, Power Query needs to understand the query language of the server it is connected to and send the SQL commands back to have the server process it. It doesn't look like MS has included MySQL as a supported engine.

Without folding, IR is useless. If you have 6 partitions (months) for example, with IR, each month gets read into its proper partition and only recent months are refreshed. Without folding, the entire table is read in to every partition then whatever isn't needed is discarded, so it would actually in this example read the entire table in 6 times. So worse than useless, it will slow you down.

However, if you can get a supported datasource, then yes you can set up IR on as many tables in a single semantic model as you want.

Query folding on native queries - Power Query | Microsoft Learn