Power Query for excel 2016 RRS feed

  • Question

  • I have recently using excel 2016 in newly installed windows. I just found out that power query does not work for excel 2016 yet,

    so is there any beta version of power query for excel 2016 or is power query will become part of the excel 2016?

    Monday, March 30, 2015 7:23 PM


  • Hi Liang,

    Power Query is part of Excel 2016 and can be found under the Data tab.


    Wednesday, April 1, 2015 2:07 AM

All replies

  • Hi Liang,

    Power Query is part of Excel 2016 and can be found under the Data tab.


    Wednesday, April 1, 2015 2:07 AM
  • Hi Miguel,

    PowerQuery is there but we lost Online Search (or I couldn't find it any more)(the leftmost button on "old" powerquery)


    Henn Sarv

    Wednesday, May 13, 2015 9:09 AM
  • Public data is not available through Excel 2016. Private data shared through a Power BI subscription is reachable by choosing "Data Catalog Search".
    Wednesday, May 13, 2015 11:59 AM
  • Strange - is that by intent or preview limitation?

    Henn Sarv

    Wednesday, May 13, 2015 1:08 PM
  • It's by intent. You may have noticed that public search only contains English language data. The Office team is not interested in shipping a feature which excludes the majority of the world's population.
    Wednesday, May 13, 2015 2:09 PM
  • Ahhhh.  That explains it.  I've been looking for that feature.

    Curt, feedback on Office2016 Preview:  After witnessing how MS leaders like Jen Underwood, Miguel Llopis and others are using twitter and other forms of communication to discuss the near daily changes in either the code or online features of PowerBI components; I'm somewhat frustrated with the lack of similar organization around the Office2016 Preview.

    I can't seem to figure out on Twitter or elsewhere who is in control of communication, where release notes are, etc.  Seems very disorganized compared to the PowerBI and Windows10 (Gabe) programs.


    Wednesday, May 13, 2015 4:10 PM
  • Thanks for the feedback, Eric and Henn.

    We're still working out the communications plan for announcing new Power Query features in Excel 2016. FWIW, the desire for both Excel & PQ teams is to keep the PQ add-in and Excel 2016 at parity (or very close) in terms of new features and also timing for updates, so you may expect that, after Office 2016 RTM, there will be a single communication for PQ updates that includes both versions. This will be posted to the usual channels (Excel Blog, Update notifications in PQ add-in or via Excel Click-To-Run updates, Twitter).

    Regarding Public Search, as Curt mentioned this was a trade-off. The overall feeling is that the feature isn't ready for Office prime-time yet, given that the support is limited to English-US data (Wikipedia &, primarily). There are also data freshness & quality issues, as well as search results relevance issues that our Search team needs to work through. We're looking at ways to improve the feature and bring it into Excel 2016 in the future.

    Out of curiosity, Eric & Henn - Would you mind elaborating a bit on why you were looking for this feature? Are you using it for "production" scenarios? If so, one workaround (someone would call it a hack) is to find the desired dataset using the PQ add-in and then manually copying the Query source into Excel 2016 (or just save the workbook in Excel 2013, then open it in Excel 2016). Public Search data is served via a publicly available OData feed which doesn't require any special type of authentication, so despite Public Search not showing up in Excel 2016, you can still import data from those feeds.


    Wednesday, May 13, 2015 5:52 PM
  • Thanks ML.  My feedback was for Office2106 overall - Excel, Word, Visio, Outlook,etc.  I'm not seeing the level of coordinated/organized approach to communications from that Program team as I see with the #PowerBI and #WindowsInsider groups (on Twitter or MS Blogs).

    But, specific to PowerQuery's Public Search: We don't have a production use per se and we're not using 2016 (just me), but we have used it to find data to import into PowerPivot models to enrich.  For example, our Land Management teams have looked for (or wanted) public Census Data on US County population, size and other land-mgmt related data.  Data from the Energy Information Administration ( is also a prime source of valuable data for us.

    We know that we can find the source and use web.contents or odata.feed to import, but I personally think that the Public Search feature leveraging a reasonably well curated repository is helpful.  English only?  Ok.

    Monetize it!  Make it apart of Azure Data Services and charge for the well-curated data sources & API's - free for the first 10 results, then $$ after.  Let other companies curate their own list and put it in Azure.  Just a thought.

    Keep up the great work Miguel.  -Eric.

    Wednesday, May 13, 2015 6:11 PM
  • Sorry - I didn't notice the Q :)

    Currently sometime (not always) I find this feature during catalog search

    Today I reach other "update" or "missing" there

    Privacy Levels dialog only appear onece and there is no option (or I didn't find it) to recall (and change) privacy options.

    I find a workaround but this is "limited"

    I have parameters on sheet and query using those parameters. When i change server name in query - the privacy window appear but only once. Next time I need this again I have to change server name (from "." to "localhost", from "localhost" to "::1", from "::1" to "" etc)


        Kood = Excel.CurrentWorkbook(){[Name="Parameter"]}[Content],
        Value = Kood{0}[Value],
        Prots = Excel.CurrentWorkbook(){[Name="Protseduur"]}[Content],
        ProtsNimi = Prots{0}[Value],
        Allikas = Sql.Database(".\CTP2016", "gedcom2", [Query="exec "&ProtsNimi&" '"&Value&"'"]),
        #"Tulemus" = Table.RemoveColumns(Allikas,{"v_kood", "p_kood", "stamp", "raja_nr", "eelm_nr"}),
        #"Ümberjärjestatud veerud" = Table.ReorderColumns(Tulemus,{"l_kood", "v_nimi", "sugulus", "lvl", "v_lvl", "main_nr"}),
        #"Eemaldatud veerud" = Table.RemoveColumns(#"Ümberjärjestatud veerud",{"v_lvl"})
        #"Eemaldatud veerud"

    Henn Sarv

    Tuesday, October 6, 2015 1:16 PM
  • Wow... so instead of expanding on existing functionality, they chose to throw it away? And remind me again what percentage of MS user base uses English?

    George W. (different George W.)

    • Proposed as answer by Chipster Maui Wednesday, May 25, 2016 1:41 PM
    Tuesday, December 29, 2015 7:52 PM
  • Hi Curt; could you tell me where to find the "Data Catalog Search" in Power BI?. Thanks.
    • Proposed as answer by Chipster Maui Wednesday, May 25, 2016 1:40 PM
    • Unproposed as answer by Chipster Maui Wednesday, May 25, 2016 1:41 PM
    • Proposed as answer by Chipster Maui Wednesday, May 25, 2016 1:41 PM
    Thursday, March 3, 2016 2:04 AM
  • Call me a conspiracy theorist but it seems that the current social environment has been very anti-west anti-anglo... causing a lot of politically-correct bs carried out by the powers-that-be at Microsoft. They don't want to look too pro-American, Pro-English speaking.... That would make the rest of the world's population feel bad and excluded. Kinda like when Christmas themes are banned in schools because it makes non-celebrators feel excluded... such crap. Many of the Microsoft employees that are running things are younger people who have been educated in this PeeCee kayrap and it just comes out in their approach here. Too bad!
    Wednesday, May 25, 2016 1:52 PM
  • OMG - Excel 2016 - Diversity Multicultural Edition - The SWJ's hard at work i see.
    Sunday, August 14, 2016 1:50 AM
  • Sound desperate by MS to me. Me thinks that they should not have released Office 2016 until they have full language versions in Chamicuro, Dumi, Ongota, Liki and Tanema. 
    Sunday, August 14, 2016 2:00 AM