Power Query 365 version

%3CLINGO-SUB%20id%3D%22lingo-sub-3445441%22%20slang%3D%22en-US%22%3EPower%20Query%20365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445441%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3EI%20am%20a%20new%20Mac%20user%20and%20I%20don't%20know%20if%20the%20version%20is%20%26nbsp%3Bdifferent%20from%20a%20Windows.%20So%20I%20am%20trying%20to%20locate%20the%20power%20query%20but%20I%20couldn't%20find%20it%20under%20Data.%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20would%20like%20to%20ask%20if%20there's%20anyone%20here%20who%20can%20give%20me%20ideas%2Fsuggestions%20about%20how%20to%20import%20multiple%20rpt%20or%20txt%20files%20into%20an%20excel%3F%20Its%20for%20work%20purposes%20and%20I%20needed%20to%20import%20raw%20files%20from%20year%202015%20up%20to%20date%20into%201%20excel%20file%20(that%20is%20why%20I%20am%20exploring%20the%20use%20of%20Power%20Query).%20These%20data%20contains%20customer%20details%20and%20I%20needed%20it%20when%20locating%20a%20specific%20data%20from%20various%20rpt%2Ftxt%20files%20into%201%20excel%20if%20its%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHoping%20someone%20who%20can%20help%20me%20with%20this.%3C%2FP%3E%3CP%3EIt%20would%20mean%20a%20lot%2C%20thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3445441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3445518%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1407349%22%20target%3D%22_blank%22%3E%40Lyca_123%3C%2FA%3E%26nbsp%3BMicrosoft%20recently%20added%20Power%20Query%20to%20the%20Mac%20version.%20You%20need%20the%20newest%20version%20of%20Microsoft%20365%20for%20it.%20All%20older%20version%20won't%20support%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EImport%20Data%20in%20Excel%20for%20Mac%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3445517%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445517%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%2F1407349%22%20target%3D%22_blank%22%3E%40Lyca_123%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyes%2C%20there%20is%20a%20big%20difference%20between%20Windows%20and%20Mac%20as%20far%20as%20Power%20Query%20is%20concerned%3A%20On%20Mac%20computers%2C%20Power%20Query%20was%20not%20available%20at%20all%20and%26nbsp%3BMicrosoft%20has%20rolled-out%20some%20PQ%20functionality%20to%20Mac%20computers%20just%20recently.%3C%2FP%3E%3CP%3EHere%20you%20can%20find%20some%20additional%20information%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerquery.microsoft.com%2Fen-us%2Fblog%2Fpower-query-updates-in-excel-for-mac%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerquery.microsoft.com%2Fen-us%2Fblog%2Fpower-query-updates-in-excel-for-mac%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fimport-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20this%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3445565%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445565%22%20slang%3D%22en-US%22%3EHi%2C%20thank%20you.%20I%20found%20it%20but%20I%20just%20recently%20discovered%20that%20I%20am%20using%20the%202021%20version%20and%20not%20the%20365%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3445566%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3445566%22%20slang%3D%22en-US%22%3EHi%2C%20thank%20you%20for%20the%20response.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3469946%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20365%20version%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3469946%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%0A%3CP%3EMake%20an%20Automator%20workflow%20like%20this%20one%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202022-06-05%20at%2010.56.58%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Screen%20Shot%202022-06-05%20at%2010.56.58%20PM.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F377738iDACC3C7C43495AC9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202022-06-05%20at%2010.56.58%20PM.png%22%20alt%3D%22Screen%20Shot%202022-06-05%20at%2010.56.58%20PM.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi!

I am a new Mac user and I don't know if the version is  different from a Windows. So I am trying to locate the power query but I couldn't find it under Data. 

Also, would like to ask if there's anyone here who can give me ideas/suggestions about how to import multiple rpt or txt files into an excel? Its for work purposes and I needed to import raw files from year 2015 up to date into 1 excel file (that is why I am exploring the use of Power Query). These data contains customer details and I needed it when locating a specific data from various rpt/txt files into 1 excel if its possible?

 

Hoping someone who can help me with this.

It would mean a lot, thank you!

5 Replies

Hi @Lyca_123 

 

yes, there is a big difference between Windows and Mac as far as Power Query is concerned: On Mac computers, Power Query was not available at all and Microsoft has rolled-out some PQ functionality to Mac computers just recently.

Here you can find some additional information:

https://powerquery.microsoft.com/en-us/blog/power-query-updates-in-excel-for-mac/

https://support.microsoft.com/en-us/office/import-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4f...

 

Maybe this helps

 

@Lyca_123 Microsoft recently added Power Query to the Mac version. You need the newest version of Microsoft 365 for it. All older version won't support it. 

Import Data in Excel for Mac 

Hi, thank you. I found it but I just recently discovered that I am using the 2021 version and not the 365
Hi, thank you for the response.

Hi

Make an Automator workflow like this one

 

Screen Shot 2022-06-05 at 10.56.58 PM.png