Performance RRS feed

  • Question

  • I'm having trouble with performance when doing simple data transformations in Power Query. I'm using an ODataFeed from CRM, 64 bit Excel and the data only has 45 rows. It can take between 20 and 60 minutes to make a simple change such as replacing values or moving columns. Any thoughts on what might be causing this and how to resolve it?
    Thursday, November 13, 2014 4:32 AM


  • Is it the source data or the result data that has only 45 rows? If the result data, how big is the source data?

    Please consider using the "Send a Frown" feature in the Power Query toolbar to send us a copy of your queries along with a description of the problem and the answer to these questions.

    Thursday, November 13, 2014 12:23 PM