Forum Discussion
Power BI - Getting Incremental Refresh Error
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.
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.
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.