Forum Discussion
Power Pivot in Excel 2019 - From other Sources button wont work
Hi. I have exactly the same problem. I'm using Excel 2016. I'm on the Office 365 monthly update channel. I think it broke with the latest update that I installed last week. I installed it on 2 computers and both are broken.
What sort of data are you trying to import? If it is a text or CSV file, try using Data > Text/CSV. Make sure you click the drop-down arrow next to Load and select Load To. Then choose Connection Only and make sure you tick the Add to Data Model checkbox.
This seems to be Microsoft's preferred way of importing data (maybe they broke the button on purpose)
Hope this helps
Mike Thomas
http://theexceltrainer.co.uk
There is no loading data in a query. It is either a:
- Connection Only query. The data is loaded for processing, but isn't stored.
- Load to Table. The data is loaded to a table in a worksheet.
- Load to Data Model. Data is loaded to the data model for Power Pivot to use.
You can also load to both a table and data model at the same time. There are other options to load directly to a pivot table chart or pivot table and bypass the model.
You can see this by creating an absurdly large spreadsheet of 1 million rows. Add that to Power Query and do some transformations. Then save it but do not load it anywhere. Leave it as a connection. The file size only grows a few bytes for the M code of the power query, but the data isn't stored/loaded. It is just the steps to process it.
