Forum Discussion

hmeegada's avatar
hmeegada
Frequent Visitor
7 years ago
Solved

power query evaluation stuck at 100%

Hi,

 

I have a 4.45 gb .csv file and had to undergo tranformations. So instead of importing the entire file, I took a small  no of rows and performed all the necessary tranformations, created visuiizations and everything worked fine. Now i replaced the path of file in advanced editor to the original file location(4.45 gb). 

 

Now as power query tries to evaluate all the steps and eventually reaches 4.45gb, and is stuck at that point. It does not end at all.

 

Everything is same, just changed the file path.

 

Any idea why this is hapenning, TIA

 

 

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi hmeegada,

     

    Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.

     
    Regards,
    Frank

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi hmeegada,

     

    Based on my test, I cannot reproduce your issue here. Could you please try to change the file path of data source by this way? If the issue still occur, kindly share your M code and Pbix to me.

     

     

    Regards,

    Frank

     

     

    • v-frfei-msft's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi hmeegada,

       

      Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.

       
      Regards,
      Frank