How to avoid pbi evaluating take very long

[Anonymous]

Hi All

i remember some one have face the same issue , and some one share how to go to setting and disable some tick and it will speed up the refresh on evaluating .... hope some one can share where to set ?

[Avenger24601]

For me, this issue occurs mostly with SharePoint connections when Power BI "forgets" my connection credentials. I click "Cancel" then click "Apply" again, which then lets me know I need to assert my credentials again. Hope this helps someone!

[amitchandak · Accepted solution]

@Anonymous ,

Check these

https://community.powerbi.com/t5/Power-Query/PowerBI-Refresh-is-stuck-on-quot-evaluating-quot/m-p/1096348

https://www.reddit.com/r/PowerBI/comments/cymrsv/power_bi_stuck_on_evaluating/

https://blog.crossjoin.co.uk/2018/12/27/data-privacy-settings-data-refresh-performance-power-bi-excel/

https://www.poweredsolutions.co/2019/03/19/lazy-evaluation-query-folding-in-power-bi-power-query/

[Anonymous]

Hi Amit

Thank you very much . 2 link is the right approach.