Power BI - Getting Incremental Refresh Error

[Saraswathi_k]

Step 1 : Get the data from MySQL to Power BI desktop.

Step 2 : Go to power query and change sales date data type text to date/time, after this View Native                            Query. it's grey color

Step 3 : Create the parameters

                    RangeStart 1/1/2021 12:00:00 AM

                    RangeEnd  9/9/2025 12:00:00 AM

Step 4 : Filter sales date using parameters, after this View Native Query. it's grey color

then apply and close

Step 5 : Right Click on the table and select incremental refresh, getting "Unable to confirm if the M query can be folded. It is not recommended to use incremental refresh with non-foldable queries.

[Saraswathi_k]

Thank you for your response.

The problem was that in Power Query, I changed the SalesDate column data type from Text to DateTime. After this step, the “View Native Query” option was greyed out in the applied steps, which means query folding was broken.

Just now I found the solution: instead of changing the data type in Power Query, I changed the SalesDate column to DateTime directly in MySQL. Then I brought the data into Power Query, created parameters, and applied incremental refresh.

[Anonymous]

Hi @Saraswathi_k,

Just following up to see if the Response provided by community members were helpful in addressing the issue. If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Anonymous]

Hi @Saraswathi_k,

Just following up to see if the Response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[Anonymous]

Hi @Saraswathi_k,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @lbendlin  for prompt and helpful response.

If the provided response from @lbendlin helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Thanks & Regards,

Prasanna Kumar

[lbendlin]

1. Make sure that RangeStart is inclusive and RangeEnd is exclusive

2. Use the Query Diagnostics in Power Query to check if the query folds (despite the "View Native Query" being greyed out)

3. Set up the incremental refresh, publish, run a refresh on the service and then use SSMS to see if multiple partitions have been created.

[Saraswathi_k · Accepted solution]

Thank you for your response.

The problem was that in Power Query, I changed the SalesDate column data type from Text to DateTime. After this step, the “View Native Query” option was greyed out in the applied steps, which means query folding was broken.

Just now I found the solution: instead of changing the data type in Power Query, I changed the SalesDate column to DateTime directly in MySQL. Then I brought the data into Power Query, created parameters, and applied incremental refresh.