none
PowerQuery problem RRS feed

  • Question

  • I use Excel 2016, but I have a problem with PowerQuery. The load into an Excel sheet, doesn’t work; not even the upload to Data Model (PowerPivot). I suppose the problem is the the new Office update, because if I reinstall, the problems disappears.

    What can I do?

    Thank you very much

    Ivo

    ps: I also use 64-bit version, but it's the same

    Saturday, January 4, 2020 7:39 PM

Answers

All replies

  • If reinstalling fixed the problem, what is the problem?

    Self Service BI Expert using Power Pivot http://exceleratorbi.com.au

    Saturday, January 4, 2020 10:33 PM
  • The problem (I'm assuming) is he reinstalls a previous version of Office (prior to the November update) and the problem is not present.  As soon as he allows Office to update to the most current version, the problem appears again because this is the same problem reported on November 21, 2019 that Power Query is hanging up when attempting to import data.
    Saturday, January 4, 2020 11:27 PM
  • Yes, that's correct! The problem is the update.
    I found the same problem (I hadn't seen it before) in another post: "https://social.technet.microsoft.com/Forums/en-US/aaf4823f-954d-400b-bde0-858639a475f4/power-query-load-to-data-model-constantly-stuckhanging?forum=powerquery". It seems there aren't any solutions, at the moment!

    Sunday, January 5, 2020 7:36 AM
  • Please stay tuned to the forum thread you linked to. Updates about this issue will be posted there.

    Ehren

    Thursday, January 30, 2020 8:27 PM
    Owner
  • Finally, it works!
    Friday, January 31, 2020 7:51 AM