Forum Discussion

Copper Contributor

Nov 20, 2019

Get&Transform / Power Query stuck on load to Data Model

Hi all, I have been working with Power Query / Get&Transform for several years now, and have now run into a problem I have never encountered before. What I am trying to do is load a new query to ...

Copper Contributor

Nov 21, 2019

Thank you both for your replies.

Abiola1 : Unfortunately clearing the cache / restoring defaults has not solved the issue.

SergeiBaklan : I can add (pivot) tables to the data model without any problem.

SergeiBaklan

Diamond Contributor

Nov 21, 2019

SMiddel

And if you do one more test - run Excel in safe mode (just in case, Win+R->excel /safe) and try to load query in data model. Power Pivot is not available in safe mode, but data model itself exists and Power Query works. You may check the data model after that by re-opening the file in normal mode.

SMiddel
Copper Contributor
Nov 21, 2019
SergeiBaklan
The query gets stuck on load even in safe mode.

I also sent one of the stuck workbooks to a colleague, and he can load the query without issues.
- SergeiBaklan
  Diamond Contributor
  Nov 21, 2019
  SMiddel
  
  If your colleague is on exactly the same version as your are when I have no idea what it could be. If so, not a bug in concrete build, data model itself works, other add-ins don't affect connection with data model.
  
  I'll ask other expert if they have a guess.
  - SMiddel
    Copper Contributor
    Nov 22, 2019
    SergeiBaklan
    
    Thanks for putting in the time. Yes, my colleague is on the same version. The only thing I can think of is reinstalling the OS from scratch and hope for the best..