Jul 31 2021 12:58 PM
Please include the following info to help others answer your question:
Jul 31 2021 09:16 PM
@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.
Aug 01 2021 10:19 AM
Aug 01 2021 11:41 AM
@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.
Aug 11 2023 12:06 PM
@Frances2021 Hello Frances, were you able to get a solution to/for this? :loudly_crying_face: I am currently going through the same problem and need an urgent solution or alternative
Aug 11 2023 12:22 PM
@Viiktor-180 You will not find it yet. Since my latest post a lot has happened in PQ for the Mac, but there is no Get Date / from Table or Range yet.
A workaround you could use is to create a table or named range first. Then, in PQ select Blank Query and type/paste the command below into the Source step.
Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
Obviously, you need to replace Table1 with the real name of your table/range.