cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hmeegada Frequent Visitor
Frequent Visitor

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: power query evaluation stuck at 100%

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: power query evaluation stuck at 100%

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.

 

222.PNG

 

Regards,

Frank

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: power query evaluation stuck at 100%

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.