Share via

Problems loading to data model from get and transform (power query) with Excel 2016

Anonymous
2019-11-19T19:00:38+00:00

Since three weeks ago, I'm not able to load any data to the data model (Power Pivot) from get and transform (Power Query). I'm using Excel 2016 with the latest update. This is a procedure that is working fine in 2013, 2019 and 365. I teach advanced Excel and I was able to test it in classroom with PCs with different settings. All Excel 2016 with the latest updates are not working.

I just installed today's Office patch it did not solve it.

It's easy to try, just take any Excel 2016 professional plus with the last update and follow this steps:

  1. get and transform, from file,
  2. choose any csv file,
  3. load to data model connection only.

It stalls and won't load. ¿Is it happennig to you?

PS. Spanish version.

Thanks for any feedback in advance

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2020-02-03T11:54:31+00:00

Hi everyone,

After reading the latest posts in the thread https://social.technet.microsoft.com/Forums/en-US/aaf4823f-954d-400b-bde0-858639a475f4/power-query-load-to-data-model-constantly-stuckhanging?forum=powerquery I have tested if the latest Office update fixes this annoying bug that has been around for more than three months....

...The good news is that it is working.

This is the version right after the update

Please test your systems to see if the bug is fixed for good.

Thanks!

Was this answer helpful?

1 person found this answer helpful.
0 comments

39 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz365 38,201 Reputation points Volunteer Moderator
    2020-02-03T04:20:08+00:00

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Lz365 38,201 Reputation points Volunteer Moderator
    2019-12-10T10:37:43+00:00

    Hi David, Floris (& others)

    In case you haven't seen it: dubeg posted a possible temp. workaround on the Technet thread earlier today

    FYI, a separate thread re. this issue has been raised in the moderators section of this community - as of today it hasn't received feedback. Will keep you posted if any...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2019-11-23T22:34:17+00:00

    I've been using Power Pivot for YEARS and have never had this problem. I also have Excel 2016 with the latest updates and I have the same EXACT problem as you. I also tried this on another computer using Excel 2016 and I had the same result.

    Version 1910 Build 12130.20390

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2019-11-19T19:04:59+00:00

    Was this answer helpful?

    0 comments