Hi all,
Does anyone know a good alternative add in or method for Power Query on Mac? To achieve the same?
Thanks!
Hi all,
Does anyone know a good alternative add in or method for Power Query on Mac? To achieve the same?
Thanks!
First, you may want ODBC driver, that supports more than just SQL Server etc.
http://www.actualtech.com
Is an inexpensive option, and works well.
Then you could leverage MS Query, and using native query language to do much of data transformation (when needed).
Other than that...
I'd recommend leveraging Python to do much of what PowerQuery is able to do. Granted, you'll need to know/learn Python.
But it is a good language to know as far as data analysis/science goes, and not difficult to learn. And it also has many library/modules that handles various aspect of PQ and more.
To integrate it with Excel. Try xlwings.
https://www.xlwings.org/
You may find articles found below to be of interest as well.
https://newtonexcelbach.com/tag/python/
Edit: Another alternative is to use PowerBI Desktop, but then you won't be able to bring back data to Excel. As well, EXCEL for MAC has no good alternative for data model/DAX.
Last edited by CK76; 05-18-2018 at 08:46 AM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
or
build virtual machine on Mac, install Windows/Office 2016Pro or higher and .... happy querying
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks