Home
%3CLINGO-SUB%20id%3D%22lingo-sub-876840%22%20slang%3D%22en-US%22%3EGet%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876840%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%202016%20for%20Windows%26nbsp%3Bintroduced%20a%20powerful%20set%20of%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2FGet-Transform-in-Excel-2016-881c63c6-37c5-4ca2-b616-59e18d75b4de%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGet%20%26amp%3B%20Transform%20Data%3C%2FA%3E%20tools.%20These%20tools%2C%20based%20on%20Power%20Query%20technology%2C%20enable%20you%20to%20easily%20connect%2C%20combine%2C%20and%20shape%20data%20coming%20from%20a%20variety%20of%20sources.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EToday%2C%20we%20are%20excited%20to%20announce%20the%20first%20step%20in%20a%20journey%20to%20support%20Power%20Query%20in%20Excel%20for%20Mac.%20This%20is%20by%20far%20%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F8995483-add-support-for-get-transform-formerly-power-qu%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ethe%20most%20popular%20idea%3C%2FA%3E%26nbsp%3Bon%20Excel%20UserVoice%20under%20Excel%20for%20Mac%20category.%20In%20this%20release%2C%20you%20can%20refresh%20your%20Power%20Query%20queries%20on%20Mac%20from%20Text%2C%20CSV%2C%20XLSX%2C%20XML%20and%20JSON%20files%2C%20and%20you%20can%20author%20queries%20with%20VBA.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%20id%3D%22toc-hId-1824014490%22%3EGetting%20started%3C%2FH2%3E%0A%3CP%3EThe%20new%20functionality%20is%20live%20for%20all%20Office%20365%20subscribers%20in%20Excel%20for%20Mac%20running%20version%26nbsp%3B16.29%20(19090802)%20and%20later.%20If%20you%20are%20running%20an%20earlier%20version%2C%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Farticle%2Fupdate-office-for-mac-automatically-bfd1e497-c24d-4754-92ab-910a4074d7c1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Efind%20out%20how%20to%20update%20your%20Office%20for%20Mac%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%20id%3D%22toc-hId--728142471%22%3ERefreshing%20Power%20Query%20queries%3C%2FH2%3E%0A%3CP%3EYou%20can%20now%20refresh%20the%20Power%20Query%20queries%20in%20your%20workbook%20that%20pull%20data%20from%20Text%2C%20CSV%2C%20XLSX%2C%20XML%20or%20JSON%20files.%20Triggering%20the%20refresh%20command%20is%20done%20the%20same%20way%20that%20you've%20been%20doing%20it%20so%20far.%20For%20example%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EClick%20on%20the%20Data%20tab%20of%20the%20ribbon%20%26gt%3B%20then%20choose%20Refresh%20All%3C%2FLI%3E%0A%3CLI%3ERight-click%20on%20your%20query%20table%20%26gt%3B%20then%20click%20Refresh%3C%2FLI%3E%0A%3CLI%3ERight%20click%20on%20your%20PivotTable%20%26gt%3B%20then%20click%20Refresh%20Data%3C%2FLI%3E%0A%3CLI%3EUse%20a%20VBA%20script%3C%2FLI%3E%0A%3CLI%3EAnd%20more...%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135172i01B9C0EBB63FB92F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Mac%20-%20Refresh%20All.png%22%20title%3D%22Mac%20-%20Refresh%20All.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20note%20that%20upon%20the%20first%20time%20you%20try%20to%20refresh%20your%20workbook%20queries%2C%20you%20may%20need%20to%20update%20the%20location%20of%20the%20data%20source%20so%20that%20it%20works%20on%20your%20Mac.%20Click%20the%20Data%20tab%20on%20the%20ribbon%20%26gt%3B%20Connections%20%26gt%3B%26nbsp%3Bselect%20the%20desired%20connection%20%26gt%3B%20and%20click%20Change%20File%20Path%20button%20to%20update%20it.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135188i5B1FC268EA302055%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Mac%20-%20Change%20File%20Path.png%22%20title%3D%22Mac%20-%20Change%20File%20Path.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%20id%3D%22toc-hId-1014667864%22%3EAuthoring%20Power%20Query%20queries%3C%2FH2%3E%0A%3CP%3EWith%20this%20update%2C%20you%20can%20also%20create%20and%20manage%20Power%20Query%20queries%20in%20your%20workbook%20using%20VBA.%20Any%20existing%20macros%20and%20VBA%20scripts%20that%20reference%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.workbook.queries%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWorkbook.Queries%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.workbookquery%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EWorkbookQuery%3C%2FA%3E%20entities%20in%20the%20Excel's%20object%20model%20will%20work%20in%20Excel%20for%20Mac%20as%20expected.%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%223%22%3E%3CU%3ENote%3A%3C%2FU%3E%26nbsp%3BYou%20may%20still%20need%20to%20adjust%20your%20scripts%20to%20reflect%20the%20notion%20of%20a%20file%20path%20on%20Mac%20(e.g.%2C%26nbsp%3B%26nbsp%3B%2FUsers%2FUSERNAME%2FDesktop%2Fdata.csv)%20that%20is%20different%20than%20a%20file%20path%20on%20Windows%20(e.g.%2C%20C%3A%5CUsers%5CUSERNAME%5CDesktop%5Cdata.csv).%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%20id%3D%22toc-hId--1537489097%22%3ESharing%20your%20feedback%3C%2FH2%3E%0A%3CP%3ELet%20us%20know%20what%20you%20think%20and%20submit%20your%20feedback%20using%20Send%20a%20Smile%2FFrown%20(Send%20us%20a%20Smile%20%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2Femoticons%2F1f642.png%22%20border%3D%220%22%20alt%3D%22%3Aslightly_smiling_face%3A%22%20title%3D%22%3Aslightly_smiling_face%3A%22%20%2F%3E%20or%20Frown%20%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2Femoticons%2F1f641.png%22%20border%3D%220%22%20alt%3D%22%3Aslightly_frowning_face%3A%22%20title%3D%22%3Aslightly_frowning_face%3A%22%20%2F%3E%20button%20at%20the%20top%20right)!%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F135136i79BFEB8E456C2B3E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Screen%20Shot%202019-10-02%20at%2010.21.31.png%22%20title%3D%22Screen%20Shot%202019-10-02%20at%2010.21.31.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStay%20tuned%20for%20more%20updates!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%20Hunkin%3C%2FP%3E%0A%3CP%3EProgram%20Manager%2C%20Excel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-876840%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20now%20refresh%20Power%20Query%20queries%20on%20Mac%20from%20Text%2C%20CSV%2C%20XLSX%2C%20XML%20and%20JSON%20files%2C%20and%20author%20queries%20with%20VBA.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-876840%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EGet%20%26amp%3B%20Transform%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-890186%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890186%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20plan%20to%20actually%20be%20able%20to%20author%20queries%20using%20an%20editor%20similar%20to%20the%20one%20in%20Excel%20on%20Windows%20and%20Power%20BI%20Desktop%20on%20Windows%3F%20That%20is%20when%20it%20gets%20really%20useful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20is%20the%20end%20goal%20to%20support%20most%2Fall%20data%20refreshes%2C%20but%20the%20assumption%20is%20the%20authoring%20happens%20on%20Windows%20clients%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-890215%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-890215%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20give%20us%20an%20update%20or%20time%20frame%20when%20the%20Power%20Query%20feature%20will%20be%20included%20in%20the%20Excel%20365%20for%20Mac%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20one%20at%20Microsoft%20has%20given%20any%20Office%20365%20for%20Mac%20user%20a%20time%20frame%20on%20when%20this%20feature%20will%20be%20available%20for%20all%20Mac%20users.%20%26nbsp%3BWe%20pay%20a%20yearly%20subscription%20to%20use%20Office%20365%20and%20we%20expect%20Office%20365%20for%20Windows%20to%20have%20the%20exact%20features%20as%20Office%20365%20for%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKINDEST%20REGARDS%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPAUL%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-891076%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891076%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%2C%26nbsp%3Bthe%20goal%20is%20to%20support%20full%20query%20authoring%20on%20Mac.%20As%20you%20can%20understand%2C%20this%20is%20an%20expensive%20project%20and%20we%20adopted%20a%20staged%20delivery%20plan%20-%20we%20aim%20to%20release%20valuable%20functionality%20to%20the%20users%20as%20soon%20as%20we%20are%20done%20with%20coding%20and%20testing.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20it%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-891085%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891085%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419149%22%20target%3D%22_blank%22%3E%40The_Gov%3C%2FA%3E%26nbsp%3B%2C%20this%20update%20is%20available%20for%20Excel%20365%20for%20Mac.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893061%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893061%22%20slang%3D%22en-US%22%3E%3CP%3EDue%20to%20the%20difference%20in%20file%20path%20names%2C%20does%20this%20mean%20a%20Power%20Query%20in%20a%20shared%20workbook%20cannot%20be%20used%20by%20both%20Mac%20and%20Windows%20users%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893743%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893743%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420054%22%20target%3D%22_blank%22%3E%40Gareth890%3C%2FA%3E%2C%26nbsp%3Byes.%20This%20is%20the%20current%20experience%20when%20linking%20to%20local%20files%20from%20shared%20workbooks%20on%20both%20Mac%20and%20Windows.%20Unfortunately%2C%20Mac%20(Unix)%20and%20Windows%20use%20completely%20different%20file%20paths.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-895652%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-895652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420054%22%20target%3D%22_blank%22%3E%40Gareth890%3C%2FA%3E%26nbsp%3B%2C%20when%20the%20data%20source%20file%20is%20located%20on%20a%20local%20drive%20you%20will%20need%20to%20update%20the%20location%20based%20on%20the%20user's%20operating%20system.%20As%20ODHANSON%20mentioned%2C%20this%20is%20by%20design%20since%20Mac%20and%20Windows%20have%20a%20different%20file%20path%20notion.%20Same%20goes%20for%20files%20stored%20on%20a%20network%20share.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20solution%20will%20be%20to%20host%20the%20data%20source%20file%20on%20a%20cloud%20(e.g.%2C%20SharePoint%20folder).%20We%20are%20working%20on%20supporting%20refresh%20from%20HTTP%20sources%20but%20it%20will%20take%20us%20some%20time%20to%20get%20there.%20This%20is%20definitely%20ranked%20high%20on%20our%20list.%20I'll%20keep%20you%20posted.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-944778%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-944778%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20trying%20PowerQuery%20on%20Mac%20....%20some%20queries%20that%20were%20authored%20in%20Windows%20fail%20on%20refresh%20on%20Mac.%20Is%20there%20any%20way%20to%20debug%20what's%20happening%20on%20the%20Mac%20side%3F%20First%20thing%20I'm%20running%20into%20is%20this%20error%3A%3C%2FP%3E%3CP%20class%3D%22p1%22%3E%5BExpression.Error%5D%20The%20module%20named%20'ExcelInterop'%20has%20been%20disabled%20in%20this%20context.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-944827%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-944827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F432732%22%20target%3D%22_blank%22%3E%40midior%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20error%20is%20appearing%20because%20you%20are%20trying%20to%20refresh%20from%20the%20Excel%20Table%2FRange%20data%20source%20and%20not%20from%20a%20file%20data%20source%20(such%20as%20txt%2C%20csv%20or%20xlsx%2C%20etc.).%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECurrently%2C%20we%20do%20not%20support%20this%20data%20source%2C%20but%20we%20are%20actively%20working%20on%20adding%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-944963%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-944963%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20....%20just%20for%20planning%20purposes%20-%20do%20you%20think%20Table%2FRange%20sources%20will%20be%20available%20in%20the%20next%20couple%20months%3F%20or%20is%20it%20a%20much%20longer%20timeframe%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-957521%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-957521%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F432732%22%20target%3D%22_blank%22%3E%40midior%3C%2FA%3E%26nbsp%3B%2C%20I%20am%20sorry%2C%20I%20cannot%20comment%20about%20time%20frames.%20I%20can%20share%20that%20we%20are%20actively%20working%20on%20this%20and%20will%20definitely%20let%20you%20know%20when%20its%20ready%20to%20be%20shipped.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-959998%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-959998%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20this%20forum%20and%20a%20very%20average%20Excel%20for%20Mac%20user.%20%26nbsp%3BMy%20goal%20is%20to%20learn%20how%20to%20automate%20what%20is%20now%20a%20manual%20copy%20and%20paste%20job%20that%20slows%20my%20productivity.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20build%20a%20lead%20list%20wherein%20I%20pull%20data%20from%20a%20table%20on%20a%20website%20into%20an%20existing%20table%20in%20Excel%20(%22Master%20List%22)%2C%20then%20from%20that%20Master%20List%20auto%20populate%20a%20field%20on%20the%20same%20website%20with%20address%20data%20that%20will%20yield%20information%20on%20that%20address.%20%26nbsp%3BThe%20resulting%20information%20would%20then%20be%20%22scraped%22%20or%20extracted%20and%20input%20back%20into%20the%20appropriate%20columns%20on%20my%20Master%20List%20automatically.%20Below%20are%20the%20webpages%20containing%20the%20table%20I%20need%20data%20pulled%20from%20and%20populated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20any%20feedback%2Fsolutions%2Fideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdekalbtax.org%2Ftax-sale-listing%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdekalbtax.org%2Ftax-sale-listing%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdekalbtax.org%2Fproperty-information%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdekalbtax.org%2Fproperty-information%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-962945%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-962945%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F434978%22%20target%3D%22_blank%22%3E%40kmalston%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20suggest%20you%20post%20your%20question%20under%20Excel%20discussions%20space%20here%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-970156%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-970156%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20have%20an%20external%20source%20in%20an%20Excel%20File%20on%20OneDrive%20or%20in%20a%20Google%20Sheet%2C%20which%20I%20can%20publish%20as%20a%20.csv%2C%20will%20the%20above%20mentioned%20functionality%20allow%20me%20to%20get%20data%20from%20either%20of%20them%3F%26nbsp%3B%20I%20have%20a%20need%20to%20have%20a%20spreadsheet%20which%20is%20distributed%20to%20many%20people%20to%20pull%20from%20a%20central%20data%20source.%26nbsp%3B%20I%20am%20looking%20for%20a%20simple%20manner%20to%20do%20this%20and%20Excel%20or%20Google%20Sheet%20were%20the%20two%20that%20came%20to%20mind%20for%20me.%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-973578%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-973578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437830%22%20target%3D%22_blank%22%3E%40BlueCougsnHam%3C%2FA%3E%2C%20not%20at%20the%20moment.%20We%20are%20actively%20working%20on%20adding%20support%20for%20OAuth%20which%20is%20needed%20to%20authenticate%20the%20data%20sources%20you%20mentioned.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20will%20be%20sure%20to%20update%20you%20once%20this%20is%20released.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOded%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1029227%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1029227%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20update%20as%20to%20when%20power%20query%20will%20be%20available%20for%20mac%20Excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20going%20to%20be%20a%20real%20game%20changer%20-%20the%20sooner%20the%20better!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EJamie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033596%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033596%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F467593%22%20target%3D%22_blank%22%3E%40jamiewashere%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20announced%20on%20the%20first%20first%20of%20Power%20Query%20on%20Mac%20in%20this%20blog%20post.%20At%20this%20stage%20you%20can%20refresh%20your%20quires%20from%20text%2C%20CSV%2C%20XLSX%2C%20JSON%20and%20XML%20files%2C%20and%20author%20queries%20with%20VBA.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWe%20are%20working%20to%20introduce%20refresh%20from%20additional%20sources%2C%20import%20and%20transform%20data%20with%20Query%20Editor%20however%20there%20is%20no%20concrete%20timeline%20for%20this%20yet.%20I%20encourage%20you%20to%20follow%20the%20announcements%20on%20this%20portal%20for%20upcoming%20updates.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGuy%3C%2FP%3E%0A%3CP%3E-%20Excel%20Team%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1033659%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033659%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F25060%22%20target%3D%22_blank%22%3E%40Guy%20Hunkin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAppreciate%20your%20response.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EJust%20to%20clarify%20one%20thing%2C%20when%20you%20say%20we%20can%20author%20queries%20with%20VBA%2C%20does%20that%20include%20getting%20data%20from%20web%3F%20%26nbsp%3BOr%20is%20it%20still%20only%20text%2C%20CSV%20etc%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that%20does%20include%20web%2C%20would%20you%20be%20able%20to%20recommend%20any%20content%20that%20can%20help%20guide%20us%20in%20how%20to%20author%20via%20VBA%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3EJamie%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1038905%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1038905%22%20slang%3D%22en-US%22%3E%3CP%3EStill%20very%20disappointed%20with%20this%20first%20version.%20I%20created%20a%20Query%20in%20Excel%20on%20Windows%20that%20creates%20a%20pivot%20table%20from%204%20CSV%20files.%20%26nbsp%3BTrying%20to%20refresh%20them%20and%20change%20the%20pivot%20table%20does%20nothing.%20%26nbsp%3BThe%20Pivot%20table%20just%20says%20the%20external%20data%20source%20is%20not%20supported.%20%26nbsp%3BSorry%2C%20and%20I%20know%20a%20lot%20of%20effort%20is%20going%20into%20this%2C%20but%20it%20should%20really%20be%20finished%20before%20release%2C%2010%25%20of%20the%20Windows%20user%20experience%20is%20far%20from%20ideal.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1044523%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1044523%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F170333%22%20target%3D%22_blank%22%3E%40Alex%20Woodrow%3C%2FA%3E%26nbsp%3Bare%20you%20trying%20to%20use%20Data%20Model%20%3F%3C%2FP%3E%0A%3CP%3EIn%20any%20case%2C%26nbsp%3B%20can%20you%20please%20open%20a%20feedback%20item%20from%20within%20Excel%20so%20we%20are%20able%20to%20support%20you%20%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20make%20sure%20to%20add%20your%20email%20address%20and%20if%20possible%20the%20XLS%20file%20and%20any%20other%20information%20that%20you%20can%20in%20order%20for%20us%20to%20reproduce%20the%20issue%20you%20are%20facing%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOded%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1044606%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1044606%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420251%22%20target%3D%22_blank%22%3E%40odhanson%3C%2FA%3E%20thanks%20for%20the%20response.%26nbsp%3B%20Sorry%20it%20was%20only%20after%20researching%20it%20I%20realised%20that%20the%20Data%20Model%20isn't%20in%20the%20Mac%20version.%26nbsp%3B%20Yes%20my%20model%20imports%204%20CSV%20files%20into%20a%20single%2080m%20line%20Data%20Model....%20Data%20Model%20is%20pretty%20critical%20and%20I%20understand%20the%20lack%20of%20SQL%20services%20on%20Mac%20is%20probably%20a%20time%20consuming%20and%20expensive%20fix....%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1044666%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%20(Power%20Query)%20in%20Excel%20for%20Mac%20-%20Phase%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1044666%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F170333%22%20target%3D%22_blank%22%3E%40Alex%20Woodrow%3C%2FA%3E%26nbsp%3BI%20suggest%20you%20vote%20on%20this%20feature%20request%20on%20the%20office%20user%20voice%3A%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F19568977-add-powerpivot-to-mac-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcel.uservoice.com%2Fforums%2F304933-excel-for-mac%2Fsuggestions%2F19568977-add-powerpivot-to-mac-excel%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOded%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Excel 2016 for Windows introduced a powerful set of Get & Transform Data tools. These tools, based on Power Query technology, enable you to easily connect, combine, and shape data coming from a variety of sources.

 

Today, we are excited to announce the first step in a journey to support Power Query in Excel for Mac. This is by far the most popular idea on Excel UserVoice under Excel for Mac category. In this release, you can refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files, and you can author queries with VBA.

 

Getting started

The new functionality is live for all Office 365 subscribers in Excel for Mac running version 16.29 (19090802) and later. If you are running an earlier version, find out how to update your Office for Mac.

 

Refreshing Power Query queries

You can now refresh the Power Query queries in your workbook that pull data from Text, CSV, XLSX, XML or JSON files. Triggering the refresh command is done the same way that you've been doing it so far. For example:

  • Click on the Data tab of the ribbon > then choose Refresh All
  • Right-click on your query table > then click Refresh
  • Right click on your PivotTable > then click Refresh Data
  • Use a VBA script
  • And more...

Mac - Refresh All.png

 

Please note that upon the first time you try to refresh your workbook queries, you may need to update the location of the data source so that it works on your Mac. Click the Data tab on the ribbon > Connections > select the desired connection > and click Change File Path button to update it.

Mac - Change File Path.png

 

Authoring Power Query queries

With this update, you can also create and manage Power Query queries in your workbook using VBA. Any existing macros and VBA scripts that reference Workbook.Queries and WorkbookQuery entities in the Excel's object model will work in Excel for Mac as expected.

Note: You may still need to adjust your scripts to reflect the notion of a file path on Mac (e.g.,  /Users/USERNAME/Desktop/data.csv) that is different than a file path on Windows (e.g., C:\Users\USERNAME\Desktop\data.csv).

 

Sharing your feedback

Let us know what you think and submit your feedback using Send a Smile/Frown (Send us a Smile :slightly_smiling_face: or Frown :slightly_frowning_face: button at the top right)!

Screen Shot 2019-10-02 at 10.21.31.png

 

Stay tuned for more updates!

 

Guy Hunkin

Program Manager, Excel

22 Comments
Contributor

Is there a plan to actually be able to author queries using an editor similar to the one in Excel on Windows and Power BI Desktop on Windows? That is when it gets really useful.

 

Or is the end goal to support most/all data refreshes, but the assumption is the authoring happens on Windows clients?

Occasional Visitor

Hi there,

 

Can you please give us an update or time frame when the Power Query feature will be included in the Excel 365 for Mac?

 

No one at Microsoft has given any Office 365 for Mac user a time frame on when this feature will be available for all Mac users.  We pay a yearly subscription to use Office 365 and we expect Office 365 for Windows to have the exact features as Office 365 for Mac.

 

KINDEST REGARDS

 

 

PAUL

Microsoft

@Ed Hansberry, the goal is to support full query authoring on Mac. As you can understand, this is an expensive project and we adopted a staged delivery plan - we aim to release valuable functionality to the users as soon as we are done with coding and testing.

 

Hope it helps.

 

Guy.

Microsoft

@The_Gov , this update is available for Excel 365 for Mac.

Occasional Visitor

Due to the difference in file path names, does this mean a Power Query in a shared workbook cannot be used by both Mac and Windows users?

Microsoft

@Gareth890, yes. This is the current experience when linking to local files from shared workbooks on both Mac and Windows. Unfortunately, Mac (Unix) and Windows use completely different file paths.

Microsoft

@Gareth890 , when the data source file is located on a local drive you will need to update the location based on the user's operating system. As ODHANSON mentioned, this is by design since Mac and Windows have a different file path notion. Same goes for files stored on a network share.

 

The solution will be to host the data source file on a cloud (e.g., SharePoint folder). We are working on supporting refresh from HTTP sources but it will take us some time to get there. This is definitely ranked high on our list. I'll keep you posted.

 

Guy

- Excel Team

Occasional Visitor

Just trying PowerQuery on Mac .... some queries that were authored in Windows fail on refresh on Mac. Is there any way to debug what's happening on the Mac side? First thing I'm running into is this error:

[Expression.Error] The module named 'ExcelInterop' has been disabled in this context.

Microsoft

@midior 

This error is appearing because you are trying to refresh from the Excel Table/Range data source and not from a file data source (such as txt, csv or xlsx, etc.). 

Currently, we do not support this data source, but we are actively working on adding it.

Occasional Visitor

Thanks .... just for planning purposes - do you think Table/Range sources will be available in the next couple months? or is it a much longer timeframe?

Microsoft

@midior , I am sorry, I cannot comment about time frames. I can share that we are actively working on this and will definitely let you know when its ready to be shipped.

Frequent Visitor

Hi All,

 

I am new to this forum and a very average Excel for Mac user.  My goal is to learn how to automate what is now a manual copy and paste job that slows my productivity.

 

I am trying to build a lead list wherein I pull data from a table on a website into an existing table in Excel ("Master List"), then from that Master List auto populate a field on the same website with address data that will yield information on that address.  The resulting information would then be "scraped" or extracted and input back into the appropriate columns on my Master List automatically. Below are the webpages containing the table I need data pulled from and populated.

 

I appreciate any feedback/solutions/ideas.

 

https://dekalbtax.org/tax-sale-listing

https://dekalbtax.org/property-information

Microsoft

Hi @kmalston ,

 

I suggest you post your question under Excel discussions space here:

https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral

 

Guy

- Excel Team

Occasional Visitor

If I have an external source in an Excel File on OneDrive or in a Google Sheet, which I can publish as a .csv, will the above mentioned functionality allow me to get data from either of them?  I have a need to have a spreadsheet which is distributed to many people to pull from a central data source.  I am looking for a simple manner to do this and Excel or Google Sheet were the two that came to mind for me.

 

 

Microsoft

@BlueCougsnHam, not at the moment. We are actively working on adding support for OAuth which is needed to authenticate the data sources you mentioned. 

We will be sure to update you once this is released.

 

Oded

Occasional Visitor

Hi @Guy Hunkin 

 

Is there any update as to when power query will be available for mac Excel?

 

This is going to be a real game changer - the sooner the better!

 

Thanks

Jamie

Microsoft

Hi @jamiewashere ,

 

We announced on the first first of Power Query on Mac in this blog post. At this stage you can refresh your quires from text, CSV, XLSX, JSON and XML files, and author queries with VBA.

 

We are working to introduce refresh from additional sources, import and transform data with Query Editor however there is no concrete timeline for this yet. I encourage you to follow the announcements on this portal for upcoming updates.

 

Guy

- Excel Team 

Occasional Visitor

Hi @Guy Hunkin 

 

Appreciate your response. 

Just to clarify one thing, when you say we can author queries with VBA, does that include getting data from web?  Or is it still only text, CSV etc?

 

If that does include web, would you be able to recommend any content that can help guide us in how to author via VBA?

 

thanks

Jamie

Regular Visitor

Still very disappointed with this first version. I created a Query in Excel on Windows that creates a pivot table from 4 CSV files.  Trying to refresh them and change the pivot table does nothing.  The Pivot table just says the external data source is not supported.  Sorry, and I know a lot of effort is going into this, but it should really be finished before release, 10% of the Windows user experience is far from ideal.

Microsoft

@Alex Woodrow are you trying to use Data Model ?

In any case,  can you please open a feedback item from within Excel so we are able to support you ?

 

Please make sure to add your email address and if possible the XLS file and any other information that you can in order for us to reproduce the issue you are facing

 

Oded

Regular Visitor

HI @odhanson thanks for the response.  Sorry it was only after researching it I realised that the Data Model isn't in the Mac version.  Yes my model imports 4 CSV files into a single 80m line Data Model.... Data Model is pretty critical and I understand the lack of SQL services on Mac is probably a time consuming and expensive fix.... 

Microsoft

@Alex Woodrow I suggest you vote on this feature request on the office user voice: 

 

https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/19568977-add-powerpivot-to-mac-e...

 

Oded