Forum Discussion
Power Pivot in Excel 2019 - From other Sources button wont work
Hi guys, I have recently upgrade my Microsoft Office to version 2019. I have no idea why the "From other sources" button in the Data Model window jus wont work. I tried repairing it locally, repa...
This is ok but it will also load the data in a query. Same for me too. Does not open anymore and did an update recently. I wou;ld like to load in the data model ... only!!
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.