Forum Discussion

Saraswathi_k's avatar
Saraswathi_k
Helper I
10 months ago
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...
Need Help
  • Saraswathi_k's avatar
    Saraswathi_k
    10 months ago

    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's avatar
Anonymous
Not applicable
10 months ago

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