Forum Discussion
Importing and applying data changes too long
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?
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
2 Replies
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
Thank you so much for your reply. The problem with Unselecting Auto Date-time brokes all existing dates in the visuals.
