+ Reply to Thread
Results 1 to 3 of 3

Power Query (Get & Transform) on Mac

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    40

    Power Query (Get & Transform) on Mac

    Hi all,

    Does anyone know a good alternative add in or method for Power Query on Mac? To achieve the same?

    Thanks!

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,726

    Re: Power Query (Get & Transform) on Mac

    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

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Power Query (Get & Transform) on Mac

    or
    build virtual machine on Mac, install Windows/Office 2016Pro or higher and .... happy querying
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Power Query / Get & Transform - filter text contains based on list
    By SHI.NL in forum Excel General
    Replies: 8
    Last Post: 05-14-2018, 04:53 PM
  2. [SOLVED] Power Query / Get & Transform filtering on text
    By SHI.NL in forum Excel General
    Replies: 5
    Last Post: 04-28-2018, 11:50 AM
  3. Replies: 3
    Last Post: 04-20-2018, 08:30 AM
  4. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  5. error in power query & power pivot
    By Baldev Kumar in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 01-03-2018, 01:34 AM
  6. [SOLVED] Change data structure using Formula or Power Query ( Get & Transform)
    By chullan88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2017, 02:58 AM
  7. Get & Transform (Power Query) not showing certain tables
    By BamBamMoneyBags in forum Excel General
    Replies: 0
    Last Post: 03-22-2017, 12:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1