Forum Discussion
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 ...
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)?
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.
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.
- 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.
