Power Query 365 version

Question

Hi!I am a new Mac user and I don't know if the version is &nbsp;different from a Windows. So I am trying to locate the power query but I couldn't find it under Data.&nbsp;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?&nbsp;Hoping someone who can help me with this.It would mean a lot, thank you!

martin_weiss · Answer

Hi&nbsp;Lyca_123&nbsp;&nbsp;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&nbsp;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-4fdf-bf00-3dfbb1e5e9c5&nbsp;Maybe this helps&nbsp;

nannak · Answer

Lyca_123&nbsp;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.&nbsp;https://support.microsoft.com/en-us/office/import-data-in-excel-for-mac-power-query-7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5&nbsp;

lyca_123 · Answer

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

lyca_123 · Answer

Hi, thank you for the response.

jimgmac · Answer

Hi
Make an Automator workflow like this one
&nbsp;

Forum Discussion

Power Query 365 version

5 Replies

Resources