Query Refresh - Evaluating forever

[bridgwan]

I have an Oracle Database Query which takes about 40 minutes to run in SQL Developer as it is complex. Up until a couple of days ago there was no problem in Power BI. Now the query gets to Refresh - Evaluating and never completes. I have left it running for two and a half hours and still stays on Evaluating. I see that similar questons have been asked before. Does anyone know how to get passed the Evaluating stage? 

[Anonymous]

Hi @bridgwan ,

Please try to turn off the below option.

Or refer to the blog to optimize performance:

Power BI, Caching, Parallelism And Power Query Refresh Performance

Best Regards,

Stephen Tao

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