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, repair online. Nothing, I hit the button multiple times, it does not respond at all. But the rest of the button like "Existing Connection", "From Database" all working fine. Please help, is anyone facing the same problem as well?
32 Replies
annahui Same problem here...would LOVE to see a quick resolution...it's been a couple of months now and is a real pain point.
Hi
Same problem. However, and strangely, seems to work fine in Power BI Desktop.
Cfo-Bi_65 wrote:Hi
Same problem. However, and strangely, seems to work fine in Power BI Desktop.
That button always launches Power Query in Power BI. There isn't an equivalent button in Power BI that corresponds to the "From Other Sources" button in Power Pivot for Excel that launches the table import wizard.
Maybe they will modify that button to just launch Power Query in Excel. ¯\_(ツ)_/¯
Looks like it's acknowledged as a bug, and due to be fixed:
https://answers.microsoft.com/en-us/msoffice/forum/all/office-365-excel-version-1901-build-1123120130/fbac40b4-8e32-4862-8d23-61939d4b20dc
When 1902 will be released though...
I have the same issue as well! it is working on excel 2016 on my work laptop, but not on office 365
Interesting. I just checked this on two builds.
Insider build 1902 b1132820008 - the button works. I never ever use it though as I always always bring data in via Power Query then load to the data model, even if I don't edit it. It allows me to edit/filter it in the future if I want.
Monthly Targeted build 1901 b11231.20130. The button is not grayed out, but when I click it it just flickers as if it is going to do something, but then nothing happens.
It honestly wouldn't surprise me if this feature is depreciated at some point. In Power BI, you must get data through Power Query. I think the only reason this button and any other import functions exist in Power Pivot is it came out for Excel before Power Query did. Had the release order been reversed, I doubt PP would have any import capability.
But it definitely seems to be glitchy and inconsistent in what is and isn't supported. The good news is using Power Query isn't really a work around, it is really the way it should be used going forward.
Ed Hansberry We can't use Power Query if we then want to convert the workbook data model into an Analysis Services cube. They have to be pure Power Pivot models in order for that solution pattern to work. This is actually critical functionality that we need restored ASAP.
- Gracias Ed, tu argumento es convincente para mí. Entonces, ya no estaré ansioso esperando una solución de Microsoft. Comenzaré a usar Power Query.
Saludos cordiales. Yeap, I would agree. Somehow I still would wish the button works like how the way it should, else just remove the button from the ribbon. Rather then leaving it there.
Hi,
I have faced the same problem with Excel 2016 Pro Plus. I have not updated Office neither Windows in these last days, except Microsoft Security Essentials.
I have got a "solution".
Import data using Power Query (Data > Get Data)
Load To Data Model and create only connection
Return to Power Pivot
- This isn't working for me, because as soon as you use PowerQuery, the data model can no longer be converted to a SSAS Tabular Model. The idea here is we are prototyping in PowerPivot and converting to SSAS. Microsoft PLEASE FIX THIS.
Hi there,
I am experiencing this exact same problem. All of the buttons in the ribbon work, except for From Other Sources.
- Just FYI, I have tried removing and adding the Power Pivot Add-In within Excel Options. And, nothing seems to work. Any ideas?
Yea, I tried that too. no response. I'm dying
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
- 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.
