SOLVED

Power Query tab on Mac ?

%3CLINGO-SUB%20id%3D%22lingo-sub-788479%22%20slang%3D%22en-US%22%3EPower%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788479%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ERecently%20switched%20to%20Macbook%2C%20I%20notice%20that%20the%20Excel%20environment%20is%20slightly%20modified%20compared%20to%20the%20Windows%20interface.%3CBR%20%2F%3EI%20have%20a%20problem%20with%20this%20upheaval.%20Indeed%2C%20I%20was%20using%20requests%20from%20web%20sources.%20But%20on%20the%20mac%20I%20can't%20find%20any%20tab%20to%20check%20the%20sources%20already%20present%20in%20the%20document%2C%20or%20even%20to%20modify%20them....%3CBR%20%2F%3EI%20looked%20in%20the%20preferences%2C%20but%20I%20didn't%20find%20anything.%3CBR%20%2F%3EDo%20you%20have%20any%20idea%20how%20to%20reach%20it%3F%3CBR%20%2F%3EThank%20you%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENb%20%3A%20I%20have%20the%20latest%20Excel's%20version%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-788479%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-788635%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-788635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387547%22%20target%3D%22_blank%22%3E%40Quentin85%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Query%20is%20still%20not%20supported%20on%20Mac%2C%20but%20the%20good%20news%20is%20that%20the%20Excel%20team%20is%20planned%20to%20support%20it%20soon%20according%20to%20this%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%20noreferrer%22%3Eidea%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2366681%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2366681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20when%20exactly%20Power%20Query%20will%20be%20available%20for%20Mac%3F%20It%20looks%20like%20it%20is%20in%20the%20works%20according%20to%20your%20post%2C%20but%20eager%20to%20know%20some%20times!%20Must%20learn%20this%20tool.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2369246%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2369246%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057371%22%20target%3D%22_blank%22%3E%40CEdward0764%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20goes%20forward%20by%20small%20steps%2C%20the%20latest%20one%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fimport-data-from-local-files-using-power-query-in-excel-for-mac%2Fba-p%2F2365521%22%20target%3D%22_blank%22%3EImport%20data%20from%20local%20files%20using%20Power%20Query%20in%20Excel%20for%20Mac%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EI%20don't%20think%20that%20PQ%20for%20Mac%20will%20ever%20have%20same%20functionality%20as%20other%20versions%20(PQ%20for%20Excel%2C%20PQ%20Online%2C%20etc%2C%20they%20are%20all%20some%20different)%2C%20but%20hope%20at%20least%20basic%20functionality%20will%20be%20in%20nearest%20future.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2381032%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2381032%22%20slang%3D%22en-US%22%3EThanks%20Sergei.%20Another%20related%20question.%20How%20can%20I%20import%20data%20from%20financial%20statements%20from%20the%20web%20(e.g.%20Yahoo%20Finance)%20for%20analysis%20in%20Excel.%20This%20link%20here%20suggests%20go%20to%20Data%20tab%20%26gt%3B%20From%20Web%20%26gt%3B%20Copy%20and%20paste%20link%20of%20financial%20statement%2C%20etc.%20I%20have%20MS%20Office%202019%20and%20don't%20seem%20to%20have%20this%20'From%20Web'%20option%2C%20but%20I%20do%20have%20'Get%20external%20data'%20(including%20from%20HTML%2C%20text%2C%20and%20new%20database%20query)%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Du-uICE9akmA%26amp%3Bab_channel%3DMyE-Lesson%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Du-uICE9akmA%26amp%3Bab_channel%3DMyE-Lesson%3C%2FA%3E.%20What%20should%20I%20do%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2381955%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2381955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057371%22%20target%3D%22_blank%22%3E%40CEdward0764%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fhowtoexcel.net%2F2021%2F03%2Fhow-to-get-stock-quotes-from-yahoo-finance-using-power-query.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EHow%20to%20Get%20Stock%20Quotes%20From%20Yahoo%20Finance%20Using%20Power%20Query%20-%20HowtoExcel.net%3C%2FA%3E%26nbsp%3B%2C%20web%20query%20in%20your%20demo%20is%20outdated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2412428%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412428%22%20slang%3D%22en-US%22%3EHow%20come%20this%20is%20not%20available%20on%20MS%20Office%202019%20for%20Mac%3F%20%22Queries%20and%20Connections%22%3F%20If%20I%20were%20to%20download%20excel%20on%20a%20windows%20PC%20would%20I%20get%20access%20to%20Power%20Query%3F%20This%20is%20terribly%20frustrating%20that%20such%20an%20essential%20add-in%20is%20not%20available%20for%20mac.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2412868%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%20tab%20on%20Mac%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2412868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1057371%22%20target%3D%22_blank%22%3E%40CEdward0764%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20general%2C%20Office%202019%20is%20not%20feature%20updated%20version%2C%20that's%20only%20Office%20365%20has%20feature%20updates%20on%20regular%20basis.%20Next%20feature%20update%20for%20Office%202019%20will%20be%20with%20Office%202021.%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20platform%2C%20only%20Office%20on%20Windows%20has%20full%20functionality.%20Power%20Query%20on%20Mac%20has%20very%20very%20limited%20functionality%2C%20but%20it's%20slowly%20improved.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

Recently switched to Macbook, I notice that the Excel environment is slightly modified compared to the Windows interface.
I have a problem with this upheaval. Indeed, I was using requests from web sources. But on the mac I can't find any tab to check the sources already present in the document, or even to modify them....
I looked in the preferences, but I didn't find anything.
Do you have any idea how to reach it?
Thank you in advance!

 

Nb : I have the latest Excel's version

7 Replies
best response confirmed by Quentin85 (Occasional Visitor)
Solution

@Quentin85

 

Hi,

 

Power Query is still not supported on Mac, but the good news is that the Excel team is planned to support it soon according to this idea.

 

Regards

@Haytham Amairah 

 

Do you know when exactly Power Query will be available for Mac? It looks like it is in the works according to your post, but eager to know some times! Must learn this tool.

@CEdward0764 

It goes forward by small steps, the latest one Import data from local files using Power Query in Excel for Mac - Microsoft Tech Community

I don't think that PQ for Mac will ever have same functionality as other versions (PQ for Excel, PQ Online, etc, they are all some different), but hope at least basic functionality will be in nearest future.

Thanks Sergei. Another related question. How can I import data from financial statements from the web (e.g. Yahoo Finance) for analysis in Excel. This link here suggests go to Data tab > From Web > Copy and paste link of financial statement, etc. I have MS Office 2019 and don't seem to have this 'From Web' option, but I do have 'Get external data' (including from HTML, text, and new database query): https://www.youtube.com/watch?v=u-uICE9akmA&ab_channel=MyE-Lesson. What should I do?
How come this is not available on MS Office 2019 for Mac? "Queries and Connections"? If I were to download excel on a windows PC would I get access to Power Query? This is terribly frustrating that such an essential add-in is not available for mac.

@CEdward0764 

In general, Office 2019 is not feature updated version, that's only Office 365 has feature updates on regular basis. Next feature update for Office 2019 will be with Office 2021.

As for the platform, only Office on Windows has full functionality. Power Query on Mac has very very limited functionality, but it's slowly improved.