Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am having some extremely slow performance when loading a very small spreadsheet (165 rows). My company reports on this every month and blend it with some other data but when I am simpy preparing table to be appended to previous months performance is dismal. When doing a simple task such as removing the top rows PowerQuery will freeze for 5-10 minutes. This has never happened in the past and I've tried uninstalling and reinstalling both from the Microsoft store and from online. Has anyone run into issues like this before? Any suggestions?
My computer has 16gb of ram and a 10th gen i7 processor so that shouldn't be an issue.
Thank you in advance!
Hi , @TheCAKurtle
You can use performance analyzer to check what is causing your report performance to be slow.
In addition , if help ,please refer some related post
https://community.powerbi.com/t5/Desktop/Power-Query-performance-issue/m-p/898380
https://community.powerbi.com/t5/Desktop/Power-Query-Performance-with-Excel/m-p/252993
Best Regards,
Community Support Team _ Eason
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |