Forum Discussion
Excel for Mac: Get Data --From Table/Range
Please include the following info to help others answer your question: Device and OS platform, Mac/macOS Big Sur 11.5.1 Excel product name and version number, 365 subscription/16.51 (20171101) I ...
Frances2021 Get Data / From Table/Range (or From Sheet in newer versions) is NOT available in Excel for Mac. It's part of the full PowerQuery functionality that comes with Excel for the Windows.
The Get Data (PowerQuery) button in Excel for Mac lets you connect to data in a workbook or a Txt/Csv file, but you can not (yet) create or edit queries. For the moment, all you can do is refresh certain queries that were created on the PC version.
- Is creating or editing queries on Microsoft's roadmap?
Frances2021 Don't really know. Am just user like you. But, I'm hopeful. Right-click inside the table and choose "Table". Then you will see this:
This tells me that, at some point of time, queries and DAX measures can be edited and parameters defined/used. Wait and see.
