question

PEREIRASamanta-8342 avatar image
0 Votes"
PEREIRASamanta-8342 asked MiguelEscobar-3907 answered

Power Query Slowness

Hi,

I' currently in a project where I have several xlsx and CSV files, total of 100k lines (more or less), I have some transformations and 1 append and 3 merges, but since the beginning, from the moment I when I pull in the data, power query's performance is incredibly slow. I search everything in the internet and I did it but nothing worked.
My PQ version is 2.61.5192.461 32-bit

Can you please help?

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MiguelEscobar-3907 avatar image
0 Votes"
MiguelEscobar-3907 answered

Could you please share the code that you're using? You could try and tackle that aspect by optimizing your code.

If you could also tell us an average of how many minutes it takes for those queries to run (individually), that would be help us understanding how slow the query might be running.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.