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?
Hi @justinh ,
You can try to use Buffer() funtion to optimize your previous query like Table.buffer(), List.buffer().
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.
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%.
Unfortunetly, it looks like there is something borked with this file. I created a brand new PBIX file and wrote the same Date.Year(DateTime.FixedLocalNow()) in both. New file gave me the result instantly, old file is still spinning its wheels.
It hasn't worked out quite yet. I really don't want to have to start over with a new file.
Thank you for your time, though. I appreciate it.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.