Power Query will be slow when using list.generate() or recursive RRS feed

  • Question

  • Hi,

    I have been using Power Query for a while. I found this tool is very useful for the users who do not have a lot of SQL language. However, Power Query is quite slow when I use list.generate() or recursive to manipulate some large data (Since there are no For Loop or While Loop function in Power Query).

    Do you have some ideas about this issue?

    My solution so far is when it comes to big data or loop functions, I will use R to do the data manipulation.

    Any other suggestions?


    Monday, October 12, 2015 9:06 PM


All replies