Forum Discussion
Power Query taking forever to perform even simple steps
All,
My Power Query is taking forever to perform simple tasks. In the screenshot below, it is trying to create a date by first pulling the min year from a list of years. That list of years is a simple query itself that uses Date.Year(DateTime.LocalNow()) and creates a list.
For this particular value, there are no databases and no excel files involved, just DateTime.LocalNow() and math. The yellow dots just keep scrolling for minutes on end. I've cleared all 3 caches. I've restarted my machine. I don't know what else to do.
This file has a lot of queries and they are all taking forever. I just chose this one to illustrate how even simple queries are taking a long time.
Please help. Any advice or tips?
Thank you,
-Justin
Yellow Dots for minutes on end for a simple query.
7 Replies
Thank you, but that did not help. I already had all but the "Background Data" option unchecked, and unchecking that one did not do anything.
Also, I should note, my CPU is running at 100% the whole time, with PBI accounting for 75% of that, and within PBI there are 3 instances of "Microsoft Masup Evaluation Container" each taking about 25%.
Hi justinh ,
You can try to use Buffer() funtion to optimize your previous query like Table.buffer(), List.buffer().
Please refer:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
