So after i raised the ticket, I came back over the weekend after shutting down my computer find that it was working correctly. I then recieved a call from MS and they advised to clear power BI cache and to then restart.
Though I wasn't able to replicate this at that time that time, I ran into the same evaluation problem a few hours ago and after following the PBI team's advice - it appeared to have resolved the issue.
I followed the the steps in this link and just restarted my computer.
I am facing the exact same issue. Despite the fact that we use Power Bi Premium for Incremental refresh, it seems Power Bi is downloading the entire Datatable during 'Evaluating' when any changes are made in the queries. This makes making changes to queries very tiring and difficult when handling large databases.
In a nutshell, this eliminates the usefullness of Incremental refresh fundamentally. Can you kindly confirm why PowerBI talkes ages at evaluating and what is done to ensure that Power BI desktop doesnt end up downloading entire database tables in PowerBI Desktop?