Jan 29 2019 07:26 PM
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?
Feb 15 2019 12:14 PM
I can confirm it works again in 1903 - I installed it today :)
Feb 15 2019 12:24 PM
Feb 15 2019 12:33 PM
If you are subscribed to Office 365 Home or Personal Editions you can sign up to the Office Insider Program. This gives you early access to the monthly releases,
If you are subscribed to one of the Office 365 Enterprise editions you can ask your SysAdmin (unless you are the sysadmin) to be put on the Monthly Channel (Targeted) program which gives you early access to the monthly releases
https://insider.office.com/en-us/
https://docs.microsoft.com/en-us/deployoffice/overview-of-update-channels-for-office-365-proplus
Mike
Feb 15 2019 12:37 PM
Thanks a lot, Mike!
Feb 15 2019 01:55 PM
FYI - I got this on another machine today that is on the Monthly Targeted build, 1902 b11328.20070 and the button works correctly again.
Feb 16 2019 04:03 AM
Yes, they returned the functionality back
Feb 23 2019 08:20 PM
Feb 23 2019 08:21 PM
Feb 24 2019 06:44 AM
There is no loading data in a query. It is either a:
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.
Apr 19 2019 01:09 PM
@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.
Apr 19 2019 01:10 PM
Apr 19 2019 01:12 PM
@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.
Apr 21 2019 07:02 AM
@Josh_McHenry this was fixed months ago, back in mid-Feb 2019. If your version isn't working, make sure you have the latest available from Office 365. AFAIK, it was never broken on the perpetual licensing versions.