locked
How to obtain info on Power Query latest version RRS feed

  • Question

  • Hi! 

    Could someone direct me to a place where I can follow the release history (version numbers & release comments) of Get & Transform?

    Like (I guess) many others, I am bound by a rigid IT-policy and suboptimal update scripts. But I need to know what's out there, what to request and why I need it ;-)

    (Presently, I use version 2.24, and sharing with people using 2.32 has started to cause serious issues in my files)

    Many thanks!

    Thursday, August 11, 2016 9:51 AM

Answers

  • Sure - this query will always tell you the latest version once you refresh it:

    let
        Source = Web.Page(Web.Contents("https://www.microsoft.com/en-US/download/details.aspx?id=39379")),
        Data0 = Source{0}[Data],
        #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}})
    in
        #"Changed Type"

    enjoy :-)


    Imke Feldmann TheBIccountant.com

    Thursday, August 11, 2016 2:07 PM
  • For Office 365 updates, which may or may not include updates to Get & Transform, you can go to:

    https://technet.microsoft.com/en-us/office/mt465751

    Thursday, August 11, 2016 4:01 PM

All replies

  • Sure - this query will always tell you the latest version once you refresh it:

    let
        Source = Web.Page(Web.Contents("https://www.microsoft.com/en-US/download/details.aspx?id=39379")),
        Data0 = Source{0}[Data],
        #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}})
    in
        #"Changed Type"

    enjoy :-)


    Imke Feldmann TheBIccountant.com

    Thursday, August 11, 2016 2:07 PM
  • For Office 365 updates, which may or may not include updates to Get & Transform, you can go to:

    https://technet.microsoft.com/en-us/office/mt465751

    Thursday, August 11, 2016 4:01 PM
  • Hi Colin,

    Can you add some color to the statement re: Office 365, please?  I am trialing 365 with 2016 apps and I am definitely not running the latest version.  I can see current features in Power BI lacking in Excel G&T.  How do you confirm which version of G&T in Excel 2016 ?!  Many thanks.

    Thursday, August 11, 2016 7:10 PM
  • Hi Nin,

    You can check the version of Get & Transform (i.e. Power Query) in Excel 2016 under Data > New Query > Query Options > Diagnostics.



    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Tuesday, October 4, 2016 11:14 AM
  • Hi Colin,

    Can you add some color to the statement re: Office 365, please?  I am trialing 365 with 2016 apps and I am definitely not running the latest version.  I can see current features in Power BI lacking in Excel G&T.  How do you confirm which version of G&T in Excel 2016 ?!  Many thanks.

    It's worth mentioning that even the latest version of Power Query won't necessarily have feature parity with the Query Editor in Power BI Desktop. Generally speaking, the newer features can take several weeks to appear in Power Query, if at all.


    Regards,

    Michael Amadi

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful :)

    Website: http://www.nimblelearn.com, Twitter: @nimblelearn

    Tuesday, October 4, 2016 11:22 AM
  • That was a really nice and unexpected solution :-) Thanks!
    Tuesday, October 4, 2016 1:32 PM