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