Forum Discussion

rocky09's avatar
rocky09
Icon for Solution Sage rankSolution Sage
8 years ago
Solved

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 ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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's avatar
    rocky09
    Icon for Solution Sage rankSolution Sage
    8 years ago

    v-yulgu-msft

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