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 ...

Diamond Contributor

Nov 20, 2019

SMiddel

Stephan, is that only with Power Query, are there any issues if you load data to data model by other way (e.g. through Add table to data model or by PivotTable)?

SMiddel

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.