Power Query takes ages for just a few data rows

[FlorianF]

Hi guys,

I have a excel file while to convert data from an csv file which Power Query. The csv file has about 1.300 row.

I have a few queries in this excel to convert data, but I think there is nothing special.

But to update the query it this about 10-15 minutes.

Can anybody help to find out, what makes so long for just a few rows?

Thx!!

[FlorianF · Accepted solution]

True 😄

But I tried a lot at the weekend and found out what the reason was. I compared text coolumns for combining tables and that took ages. I solved it with an index for each text ad now it runs very quick 🙂

[ronrsnfld]

I'm thinking it would be difficult to provide assistance with no idea of your data or code.