To refresh queries generated from Text, CSV, XLSX, XML or JSON files, triggering the Refresh command is done the same way as previously, e.g. If you are running an earlier version, you will need to update. This new functionality is live for all Office 365 subscribers in Excel for Mac running version 16.29 (19090802) and later. This “Phase 1” release allows you to refresh your Power Query queries on Mac from Text, CSV, XLSX, XML and JSON files (yes, we’ve just said most of that has been around from June), but you can author queries with VBA. Get in control with new data source settings on Excel for Mac: Use the new Data Source Settings dialog box to manage Power Query data sources, clear login credentials, and change the file location. Well, today, Microsoft has announced the first step towards full support for Power Query in Excel for Mac. Version 16.52 (Build 21080801) Feature updates Excel.
But it’s been missing from Mac Excel.īack in June, there was a little teaser of what was to come with the ability to undertake limited Power Query query refreshes for CSV, JSON, Text, XLSX and XML files only. We have a Power Query blog each Wednesday that keeps you apprised of all the things you can do with the Extract, Transform and Load (ETL) tool.
For several years now, the Windows platform has introduced a powerful set of Get & Transform Data / Power Query tools, starting way back with Excel 2010.
