This is my first post in this Power Query forum. Is there a list of Power Query functions/commands (M language) that also shows what Power Query versions support them? How to ensure everyone is running the same version of Excel?ģ. Double-click the data source that you want to use. In the Choose Data Source dialog box, make sure that the Use the Query Wizard to create/edit queries check box is clear. On the Data tab, in the Get External Data group, click From Other Sources, and then click From Microsoft Query. If possible, how do I determine the version of Power Query in Excel 2016?Ģ. To start Microsoft Query, perform the following steps. I have updated my version of Excel 2016, updated a colleague's version of Office 2016 and still get this behavior.ġ. Iįind no way in Excel 2016 to update just the Power Query component.
I suspect different versions of Power Query are in play (mine versus that of my colleagues) however, given this is not a 365 updated product versus a stand-alone version, I would have thought they had the same update channel and would therefore match. Meanwhile, no error is produced if I eliminate, leaving just = Table.PromoteHeaders(bld_Sheet) and the headers are promoted as desired. In the version of Excel 2016 that my colleagues run, the following error is produced when this step is run upon workbook Refresh All: 2 arguments were passed to a function which expects 1 This step to promote headers works in my version of Excel 2016: = Table.PromoteHeaders(bld_Sheet, ) I did some nifty things with it and management decided to buy stand-alone Office 2016 for my 7 colleagues, so they could run my Power Query Excel 2016 workbooks. Das Dialogfeld Erweiterter Editor wird angezeigt. Wählen Sie im Abfrage-Editor die Option Erweiterter Editor aus. Wählen Sie auf der Menüleisten-Registerkarte POWER QUERY die Optionen Aus anderen Quellen > Leere Abfrage aus. I bought a stand-alone (non-365) version of Excel 2016 last year and love the Power Query feature. Schritt 1: Öffnen des Erweiterten Editors.
0 kommentar(er)
