Home

Power Pivot in Excel 2019 - From other Sources button wont work

%3CLINGO-SUB%20id%3D%22lingo-sub-327714%22%20slang%3D%22en-US%22%3EPower%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327714%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20recently%20upgrade%20my%20Microsoft%20Office%20to%20version%202019.%20I%20have%20no%20idea%20why%20the%20%22From%20other%20sources%22%20button%20in%20the%20Data%20Model%20window%20jus%20wont%20work.%20I%20tried%20repairing%20it%20locally%2C%20repair%20online.%20Nothing%2C%20I%20hit%20the%20button%20multiple%20times%2C%20it%20does%20not%20respond%20at%20all.%20But%20the%20rest%20of%20the%20button%20like%20%22Existing%20Connection%22%2C%20%22From%20Database%22%20all%20working%20fine.%20Please%20help%2C%20is%20anyone%20facing%20the%20same%20problem%20as%20well%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-327714%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355946%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355946%22%20slang%3D%22en-US%22%3E%3CP%3EThere%20is%20no%20loading%20data%20in%20a%20query.%20It%20is%20either%20a%3A%3C%2FP%3E%3CUL%3E%3CLI%3EConnection%20Only%20query.%20The%20data%20is%20loaded%20for%20processing%2C%20but%20isn't%20stored.%26nbsp%3B%3C%2FLI%3E%3CLI%3ELoad%20to%20Table.%20The%20data%20is%20loaded%20to%20a%20table%20in%20a%20worksheet.%3C%2FLI%3E%3CLI%3ELoad%20to%20Data%20Model.%20Data%20is%20loaded%20to%20the%20data%20model%20for%20Power%20Pivot%20to%20use.%3C%2FLI%3E%3C%2FUL%3E%3CP%3EYou%20can%20also%20load%20to%20both%20a%20table%20and%20data%20model%20at%20the%20same%20time.%20There%20are%20other%20options%20to%20load%20directly%20to%20a%20pivot%20table%20chart%20or%20pivot%20table%20and%20bypass%20the%20model.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20see%20this%20by%20creating%20an%20absurdly%20large%20spreadsheet%20of%201%20million%20rows.%20Add%20that%20to%20Power%20Query%20and%20do%20some%20transformations.%20Then%20save%20it%20but%20do%20not%20load%20it%20anywhere.%20Leave%20it%20as%20a%20connection.%20The%20file%20size%20only%20grows%20a%20few%20bytes%20for%20the%20M%20code%20of%20the%20power%20query%2C%20but%20the%20data%20isn't%20stored%2Floaded.%20It%20is%20just%20the%20steps%20to%20process%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355870%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355870%22%20slang%3D%22en-US%22%3EInteresting%20indeed%20but%20what%20if%20we%20don%20not%20want%20to%20load%20the%20data%20in%20a%20query%20...%20only%20in%20the%20data%20model!%20Hummmm.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-355869%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-355869%22%20slang%3D%22en-US%22%3EThis%20is%20ok%20but%20it%20will%20also%20load%20the%20data%20in%20a%20query.%20Same%20for%20me%20too.%20Does%20not%20open%20anymore%20and%20did%20an%20update%20recently.%20I%20wou%3Bld%20like%20to%20load%20in%20the%20data%20model%20...%20only!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-351696%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-351696%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20they%20returned%20the%20functionality%20back%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-346248%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-346248%22%20slang%3D%22en-US%22%3E%3CP%3EFYI%20-%20I%20got%20this%20on%20another%20machine%20today%20that%20is%20on%20the%20Monthly%20Targeted%20build%2C%201902%20b11328.20070%20and%20the%20button%20works%20correctly%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-345712%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-345712%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20a%20lot%2C%20Mike!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-345681%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-345681%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20are%20subscribed%20to%20Office%20365%20Home%20or%20Personal%20Editions%20you%20can%20sign%20up%20to%20the%20Office%20Insider%20Program.%20This%20gives%20you%20early%20access%20to%20the%20monthly%20releases%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20subscribed%20to%20one%20of%20the%20Office%20365%20Enterprise%20editions%20you%20can%20ask%20your%20SysAdmin%20(unless%20you%20are%20the%20sysadmin)%20to%20be%20put%20on%20the%26nbsp%3BMonthly%20Channel%20(Targeted)%20program%20which%20gives%20you%20early%20access%20to%20the%20monthly%20releases%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Finsider.office.com%2Fen-us%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Finsider.office.com%2Fen-us%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Foverview-of-update-channels-for-office-365-proplus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Foverview-of-update-channels-for-office-365-proplus%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMike%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftheexceltrainer.co.uk%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Ftheexceltrainer.co.uk%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-345616%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-345616%22%20slang%3D%22en-US%22%3EHi%20Mike%2C%20can%20you%20please%20tell%20me%20how%20to%20install%20it%3F%20Thank%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-345551%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-345551%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can%20confirm%20it%20works%20again%20in%201903%20-%20I%20installed%20it%20today%20%3A-)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-345470%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-345470%22%20slang%3D%22en-US%22%3EGracias%20Ed%2C%20tu%20argumento%20es%20convincente%20para%20m%C3%AD.%20Entonces%2C%20ya%20no%20estar%C3%A9%20ansioso%20esperando%20una%20soluci%C3%B3n%20de%20Microsoft.%20Comenzar%C3%A9%20a%20usar%20Power%20Query.%3CBR%20%2F%3E%3CBR%20%2F%3ESaludos%20cordiales.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-344301%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-344301%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20news.%20I%20am%20sure%201902%20will%20be%20in%20in%20the%20next%20few%20days.%201903%20was%20released%20yesterday%20for%20the%20Insider%20track.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-343891%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-343891%22%20slang%3D%22en-US%22%3E%3CP%3ELooks%20like%20it's%20acknowledged%20as%20a%20bug%2C%20and%20due%20to%20be%20fixed%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Foffice-365-excel-version-1901-build-1123120130%2Ffbac40b4-8e32-4862-8d23-61939d4b20dc%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Foffice-365-excel-version-1901-build-1123120130%2Ffbac40b4-8e32-4862-8d23-61939d4b20dc%3C%2FA%3E%3C%2FP%3E%3CP%3EWhen%201902%20will%20be%20released%20though...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334554%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334554%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280981%22%20target%3D%22_blank%22%3E%40Cfo-Bi_65%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20problem.%20However%2C%20and%20strangely%2C%20seems%20to%20work%20fine%20in%20Power%20BI%20Desktop.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EThat%20button%20always%20launches%20Power%20Query%20in%20Power%20BI.%20There%20isn't%20an%20equivalent%20button%20in%20Power%20BI%20that%20corresponds%20to%20the%20%22From%20Other%20Sources%22%20button%20in%20Power%20Pivot%20for%20Excel%20that%20launches%20the%20table%20import%20wizard.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20they%20will%20modify%20that%20button%20to%20just%20launch%20Power%20Query%20in%20Excel.%26nbsp%3B%3CSPAN%3E%C2%AF%5C_(%E3%83%84)_%2F%C2%AF%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-334055%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-334055%22%20slang%3D%22en-US%22%3E%3CP%3EYeap%2C%20I%20would%20agree.%20Somehow%20I%20still%20would%20wish%20the%20button%20works%20like%20how%20the%20way%20it%20should%2C%20else%20just%20remove%20the%20button%20from%20the%20ribbon.%20Rather%20then%20leaving%20it%20there.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333587%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333587%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESame%20problem.%20However%2C%20and%20strangely%2C%20seems%20to%20work%20fine%20in%20Power%20BI%20Desktop.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333475%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333475%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20issue%20as%20well!%20it%20is%20working%20on%20excel%202016%20on%20my%20work%20laptop%2C%20but%20not%20on%20office%20365%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332686%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332686%22%20slang%3D%22en-US%22%3E%3CP%3EInteresting.%20I%20just%20checked%20this%20on%20two%20builds.%3C%2FP%3E%3CP%3EInsider%20build%201902%20b1132820008%20-%20the%20button%20works.%20I%20never%20ever%20use%20it%20though%20as%20I%20always%26nbsp%3B%3CSTRONG%3E%3CEM%3Ealways%3C%2FEM%3E%3C%2FSTRONG%3E%20bring%20data%20in%20via%20Power%20Query%20then%20load%20to%20the%20data%20model%2C%20even%20if%20I%20don't%20edit%20it.%20It%20allows%20me%20to%20edit%2Ffilter%20it%20in%20the%20future%20if%20I%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMonthly%20Targeted%20build%201901%20b11231.20130.%20The%20button%20is%20not%20grayed%20out%2C%20but%20when%20I%20click%20it%20it%20just%20flickers%20as%20if%20it%20is%20going%20to%20do%20something%2C%20but%20then%20nothing%20happens.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20honestly%20wouldn't%20surprise%20me%20if%20this%20feature%20is%20depreciated%20at%20some%20point.%20In%20Power%20BI%2C%20you%20must%20get%20data%20through%20Power%20Query.%20I%20think%20the%20only%20reason%20this%20button%20and%20any%20other%20import%20functions%20exist%20in%20Power%20Pivot%20is%20it%20came%20out%20for%20Excel%20before%20Power%20Query%20did.%20Had%20the%20release%20order%20been%20reversed%2C%20I%20doubt%20PP%20would%20have%20any%20import%20capability.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20it%20definitely%20seems%20to%20be%20glitchy%20and%20inconsistent%20in%20what%20is%20and%20isn't%20supported.%20The%20good%20news%20is%20using%20Power%20Query%20isn't%20really%20a%20work%20around%2C%20it%20is%20really%20the%20way%20it%20should%20be%20used%20going%20forward.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332664%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332664%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20experiencing%20the%20same%20issue%20The%20%22From%20Other%20Sources%22%20button%20stops%20working%20just%20today%20(2%2F7)%2C%20but%20it%20still%20worked%20not%20two%20days%20ago%20(2%2F5).%20I%20can%20confirm%20that%20importing%20text%2Fcsv%20through%20PowerQuery%20is%20a%20valid%20workaround.%20I%20hope%20they%20will%20fix%20this%20soon.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332088%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332088%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20try%20using%20Power%20Query%20to%20Merge%20or%20Append%20all%20these%20data.%20Upon%20%22Close%20and%20Load%22%2C%20select%20%22Add%20to%20Data%20Model%22%3C%2FP%3E%3CP%3Echeck%20out%20this%20link%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FAdd-a-query-to-an-Excel-worksheet-Power-Query-ca69e0f0-3db1-4493-900c-6279bef08df4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EAdd%20a%20query%20to%20an%20Excel%20worksheet%20(Power%20Query)%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20combine%20data%20from%20multiple%20sheets%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excelguru.ca%2Fblog%2F2014%2F11%2F19%2Fcombine-multiple-worksheets-using-power-query%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Guru%20-%20Combine%20Multiple%20Worksheets%20Using%20Power%20Query%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332087%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332087%22%20slang%3D%22en-US%22%3E%3CP%3Ethat's%20what%20i'm%20thinking%20of%20doing%20as%20well.%20%22Add%2FLoad%20to%20Data%20Model%22.%26nbsp%3B%3CBR%20%2F%3EBut%20I%20am%20an%20instructor%2C%20there%20are%20some%20modules%20that%20I%20have%20to%20cover%20importing%20data%20into%20the%20data%20model.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332086%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332086%22%20slang%3D%22en-US%22%3E%3CP%3EYea%2C%20I%20tried%20that%20too.%20no%20response.%20I'm%20dying%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331679%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331679%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20a%20beginner%20to%20Power%20Pivot.%20I'm%20not%20really%20sure%20how%20your%20solution%20works.%20I%20have%20a%20few%20tabs%20of%20data%20in%20an%20Excel%20document.%20Without%20using%20the%26nbsp%3B%3CEM%3EFrom%20Other%20Sources%26nbsp%3B%3C%2FEM%3Ebutton%2C%20how%20would%20I%20get%20these%20into%20Power%20Pivot%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331444%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331444%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20was%20my%20suggested%20solution%20too%20as%20I%20posted%20earlier%20in%20this%20thread.%20Seems%20to%20be%20the%20only%20way%20round%20it%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331290%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331290%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20got%20a%20%22solution%22.%3C%2FP%3E%3CP%3EImport%20data%20using%20Power%20Query%20(Data%20%26gt%3B%20Get%20Data)%3C%2FP%3E%3CP%3ELoad%20To%20Data%20Model%20and%20create%20only%20connection%3C%2FP%3E%3CP%3EReturn%20to%20Power%20Pivot%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331276%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331276%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20faced%20the%20same%20problem%20with%20Excel%202016%20Pro%20Plus.%20I%20have%20not%20updated%20Office%20neither%20Windows%20in%20these%20last%20days%2C%20except%20Microsoft%20Security%20Essentials.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331109%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331109%22%20slang%3D%22en-US%22%3EJust%20FYI%2C%20I%20have%20tried%20removing%20and%20adding%20the%20Power%20Pivot%20Add-In%20within%20Excel%20Options.%20And%2C%20nothing%20seems%20to%20work.%20Any%20ideas%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-331102%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-331102%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20experiencing%20this%20exact%20same%20problem.%20All%20of%20the%20buttons%20in%20the%20ribbon%20work%2C%20except%20for%26nbsp%3B%3CEM%3EFrom%20Other%20Sources%3C%2FEM%3E.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-329587%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-329587%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20have%20exactly%20the%20same%20problem.%20I'm%20using%20Excel%202016.%20I'm%20on%20the%20Office%20365%20monthly%20update%20channel.%20I%20think%20it%20broke%20with%20the%20latest%20update%20that%20I%20installed%20last%20week.%20I%20installed%20it%20on%202%20computers%20and%20both%20are%20broken.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20sort%20of%20data%20are%20you%20trying%20to%20import%3F%20If%20it%20is%20a%20text%20or%20CSV%20file%2C%20try%20using%26nbsp%3BData%20%26gt%3B%20Text%2FCSV.%20Make%20sure%20you%20click%20the%20drop-down%20arrow%20next%20to%20Load%20and%20select%20Load%20To.%20Then%20choose%20Connection%20Only%20and%20make%20sure%20you%20tick%20the%20Add%20to%20Data%20Model%20checkbox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20seems%20to%20be%20Microsoft's%20preferred%20way%20of%20importing%20data%20(maybe%20they%20broke%20the%20button%20on%20purpose)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMike%20Thomas%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Ftheexceltrainer.co.uk%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Ftheexceltrainer.co.uk%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476105%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476105%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F274525%22%20target%3D%22_blank%22%3E%40annahui%3C%2FA%3E%26nbsp%3BSame%20problem%20here...would%20LOVE%20to%20see%20a%20quick%20resolution...it's%20been%20a%20couple%20of%20months%20now%20and%20is%20a%20real%20pain%20point.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476107%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476107%22%20slang%3D%22en-US%22%3EThis%20isn't%20working%20for%20me%2C%20because%20as%20soon%20as%20you%20use%20PowerQuery%2C%20the%20data%20model%20can%20no%20longer%20be%20converted%20to%20a%20SSAS%20Tabular%20Model.%20The%20idea%20here%20is%20we%20are%20prototyping%20in%20PowerPivot%20and%20converting%20to%20SSAS.%20Microsoft%20PLEASE%20FIX%20THIS.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-476122%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-476122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F236847%22%20target%3D%22_blank%22%3E%40Ed%20Hansberry%3C%2FA%3E%26nbsp%3BWe%20can't%20use%20Power%20Query%20if%20we%20then%20want%20to%20convert%20the%20workbook%20data%20model%20into%20an%20Analysis%20Services%20cube.%26nbsp%3B%20They%20have%20to%20be%20pure%20Power%20Pivot%20models%20in%20order%20for%20that%20solution%20pattern%20to%20work.%26nbsp%3B%20This%20is%20actually%20critical%20functionality%20that%20we%20need%20restored%20ASAP.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-478221%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Pivot%20in%20Excel%202019%20-%20From%20other%20Sources%20button%20wont%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-478221%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F247397%22%20target%3D%22_blank%22%3E%40Josh_McHenry%3C%2FA%3E%26nbsp%3B%20this%20was%20fixed%20months%20ago%2C%20back%20in%20mid-Feb%202019.%20If%20your%20version%20isn't%20working%2C%20make%20sure%20you%20have%20the%20latest%20available%20from%20Office%20365.%20AFAIK%2C%20it%20was%20never%20broken%20on%20the%20perpetual%20licensing%20versions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
annahui
Occasional Contributor

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

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

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?

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

 

 

That was my suggested solution too as I posted earlier in this thread. Seems to be the only way round it

I am a beginner to Power Pivot. I'm not really sure how your solution works. I have a few tabs of data in an Excel document. Without using the From Other Sources button, how would I get these into Power Pivot?

Yea, I tried that too. no response. I'm dying

that's what i'm thinking of doing as well. "Add/Load to Data Model". 
But I am an instructor, there are some modules that I have to cover importing data into the data model. 

You can try using Power Query to Merge or Append all these data. Upon "Close and Load", select "Add to Data Model"

check out this link:

Add a query to an Excel worksheet (Power Query)

 

To combine data from multiple sheets:

Excel Guru - Combine Multiple Worksheets Using Power Query

 

 

I am experiencing the same issue The "From Other Sources" button stops working just today (2/7), but it still worked not two days ago (2/5). I can confirm that importing text/csv through PowerQuery is a valid workaround. I hope they will fix this soon.

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.

I have the same issue as well! it is working on excel 2016 on my work laptop, but not on office 365 

Hi

 

Same problem. However, and strangely, seems to work fine in Power BI Desktop.

 

 

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.


@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-112312013...

When 1902 will be released though...

Good news. I am sure 1902 will be in in the next few days. 1903 was released yesterday for the Insider track.

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.

I can confirm it works again in 1903 - I installed it today :-)

Hi Mike, can you please tell me how to install it? Thank you

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

http://theexceltrainer.co.uk

FYI - I got this on another machine today that is on the Monthly Targeted build, 1902 b11328.20070 and the button works correctly again.

Yes, they returned the functionality back

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!!
Interesting indeed but what if we don not want to load the data in a query ... only in the data model! Hummmm.

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.

@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.

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.

@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.

@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.