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 ...
This is probably one of the worst "solutions" I've ever come up with, but...
If you open the workbook in Excel 2013, go to Workbook Queries (Power Query tab, Show Pane), hover over the query, click Load To... in the popup, then make sure Only Create Connection and Add this data to the Data Model are ticked in the next model, then click Load. Save everything and open en Excel 2016 again.
This has been the only way that I found so far to get around the load problem and actually be able to continue with work. And again, I know this is a really bad workaround.