Importing and applying data changes too long

[rocky09]

Hello, I have few tables and some tables has 3 - 4 lakhs rows in them. But, I add or update the query in query editor, it is taking nearly 20 to 50 minutes of time to applying the changes.  Is there a way to speed up the process. or can i just limit the apply the changes to initial loaded data. So, I will refresh the entire data once it is online. So, it won't waste my time.

Any inputs?

[v-yulgu-msft · Accepted solution]

Hi @rocky09,

Please try to uncheck below option: Files->options->current file->Data Load->Auto Date-time.

Also, please try to deselect “Allow data preview to download in the background” option.

Besides, here are two threads about speeding up Power Query:

Speed up the PowerBI and Power Query design process

Serious performance issues: Filtering and sorting 900k rows from 20 .xlsx takes literally for ever!

Best regards,

Yuliana Gu

[rocky09]

@v-yulgu-msft

Thank you so much for your reply.  The problem with Unselecting Auto Date-time brokes all existing dates in the visuals.