excel 2016 query editor manage parameters

#Excel 2016 query editor manage parameters how to
#Excel 2016 query editor manage parameters update

Currently, only a static list of Accepted Values (or any value of the expected type) are accepted. Users will then be able to pick one of these values when specifying the parameter value to use. For instance, users could specify that the Data Type for a parameter is Text and restrict the acceptable values to a static list of Text values. Parameter Accepted Values: In addition to Data Type restrictions, users can apply further restrictions to the allowed values for a given parameter.Users can also specify Any type for more flexibility. For instance, users can define a parameter of type Text, or Date/Time. Parameter Type: This field applies a Data Type restriction on the input value for the parameter.Required: Users can specify whether a certain parameter is optional or a value for that parameter must be specified (required). Parameter Description: This will be displayed next to the parameter name in downstream experiences, and helps the user who is specifying the parameter value to better understand the purpose and semantics of this parameter.Users can define new parameters by using the “Manage Parameters” dialog in the Query Editor window.įrom this dialog, users can create new parameters and specify metadata and settings for each parameter: With the new Query Parameters feature, users can now easily define one or multiple parameters to be used in their queries, Data Model and report layers in Power BI Desktop. Let’s take a closer look at how this can be done… Users can easily instantiate a Template using Power BI Desktop, which will ask them for parameter values (if needed) and create a new Power BI Desktop Report (PBIX file) based upon the contents in the Template file (PBIT file). On top of this capability, Templates allow users to export the definition of a report (report + data model + queries definition + parameters, if any) without including the actual data. In this blog post, we will take a deeper look at the new capabilities and scenarios that these two features enable in Power BI.Īt a very high level, Query Parameters allow users to easily make parts of their reports and data models (such as a query filter, a data source reference, a measure definition, etc.) depend on one or more parameter values.

#Excel 2016 query editor manage parameters update

Thanks in advance for your help.Two of the new features in the Power BI Desktop April Update are Query Parameters and Power BI Template files. 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?

#Excel 2016 query editor manage parameters how to

How to ensure everyone is running the same version of Excel?ģ. If possible, how do I determine the version of Power Query in Excel 2016?Ģ. 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. I bought a stand-alone (non-365) version of Excel 2016 last year and love the Power Query feature.