none
Power Query for Excel 2016 for Mac

    Question

  • I had posted a question about how to transform data in my Excel sheet and had a great solution using Get and Transform data on Excel 2016 for Windows:

    https://social.technet.microsoft.com/Forums/office/en-US/b1fe131a-ac7d-4681-80e1-074408986947/pivot-table-with-actual-values-instead-of-aggregates?forum=excel

    I need this to work on Excel 2016 for Mac and just learned that power query is not supported on Macs.

    Excel for Macs does recognize the tables, but cannot refresh them with source data.  

    How do i get around this to work on Excel 2016 for Macs?

    Thank you

    Tuesday, May 29, 2018 2:27 PM

Answers

  • Hi,

    In my opinion, use code to generate the determine table will be the best way for you use in both Office for Windows and MAC.

    Please ask your requirement to Excel for Developer forum:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, May 30, 2018 8:25 AM
    Moderator

All replies

  • if you use Mac you could try PowerBI online - PowerQuery script will work there, but I'm not sure it will fit your purpose
    Tuesday, May 29, 2018 4:21 PM
  • I guess I am just looking for the simplest approach to solving the initial requirement from https://social.technet.microsoft.com/Forums/office/en-US/b1fe131a-ac7d-4681-80e1-074408986947/pivot-table-with-actual-values-instead-of-aggregates?forum=excel

    that will work on Excel 2016 for Mac.  The resulting dataset needs to be in the same excel workbook as the source data

    Tuesday, May 29, 2018 5:10 PM
  • I tried uplaoding the work book to power bi online, but it still said it couldnt refresh.  I uploaded the entire workbook for use online. Said data refresh not supported and when refresh happens, it says could not refresh query that is in workbook
    Tuesday, May 29, 2018 6:01 PM
  • Hi,

    In my opinion, use code to generate the determine table will be the best way for you use in both Office for Windows and MAC.

    Please ask your requirement to Excel for Developer forum:

    https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

    Regards,

    Emi


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    Wednesday, May 30, 2018 8:25 AM
    Moderator