I am new to Power Query. I am attempting to load an Excel file. I get the message "Load to Data Model Failed". I tried loading from a folder & get the same message. It happens when I use my data & the practice files. Where should I start to look to see what is causing the error?
Hi Denise,
Are you able to load to a Table? What version of Excel are you using? Can you please attach a screenshot of the error in full screen so we can see where you are in the Excel window.
Thanks,
Mynda
No, it doesn't appear that I can load to a Table. I am using the 32 bit version of Excel 2013. I tried updating my version of PowerQuery, but I am still getting an error message. In addition to the error message, I noticed that before clicking "save & load to" in PowerQuery, I can see all the data (i.e. December, November & October). However, when I click "save & load to", in addition to the error message, it's only loading the December data & part of the November data to the Excel table. I'm not getting any October data loading at all. I am attaching a screen shot of the error message I am getting. I am also attaching the Excel file that I created using the practice files from pq_2.05_excel_workbooks.
Hi Denise,
Thanks for sharing the workbook and screenshot. The problem is caused when you try to load to a table and the data model. Normally you wouldn't want your data in a table as well as the data model as this would be doubling up on the amount of data in the file.
If you change the Load to settings by right-clicking on the query in the query pane > Load to > select 'connection only' and 'load to data model'. It should work, as it did for me.
Mynda
Mynda,
Thank you. I was able to load the query using "connection only".
