Forum Discussion
Solved
Power Query takes ages for just a few data rows
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!!
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 🙂
2 Replies
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 🙂
I'm thinking it would be difficult to provide assistance with no idea of your data or code.
