Download Power Query Update
What's New in Power Query
Support for “Whole Number” column type
Additional transformations in Query Editor ribbon
Aggregate Column dialog
Additional Date/Time filters
Improved Navigator experience: Refresh Tree & Function Invocation
Cache Management options
We are very happy to announce the availability of a new Power Query update. You can download the update from this page.
There are quite a few new or improved features in this release, as well as several quality fixes. You can watch the following video or read the rest of this blog post for more details.
Data Type menus in the Home & Transform tabs in the ribbon and in the Change Type context menu on preview columns now let users set a column type to Whole Number. Previously supported type (Number) has now been renamed to Decimal Number in the UX. This provides better alignment with Data Model numeric types, which was a recurrent piece of feedback from our customers.
A few new transformations have been added to the Query Editor ribbon under the Transform & Insert tabs. The motivation for this is to increase discoverability of existing capabilities that customers were having trouble to find without UX support.
- Home tab:
- Transform tab:
Similarly to how we added a dialog for “Expand Column” in the previous release, this month we have added a dialog for “Aggregate Column”. The goal of this change is to improve discoverability of this operation by exposing it via the Editor ribbon, as well as enable editing Aggregate steps later (via the Edit Settings button next to the step).
Previously, Power Query only supported filtering by Last or Next Day/Week/etc. instead of letting users customize “N”. In this release, additional filters have been added to the Filter dropdown menu. Users can now specify the value of “N” as well as the unit of time that they want to use for their filter.
The Navigator task pane now exposes “Invoke” for functions. This lets users directly invoke a function instead of having to load the function into the workbook and invoke it from there. This is available for functions in Azure Marketplace, Databases and OData feeds.
Also the Navigator Task pane now has a Refresh button to refresh the contents of the tree as needed by the user.
The Power Query Options dialog now includes a new section about Cache Management. This section lets users check the amount of memory used by the PQ Cache, delete all cache items and configure the max size allowed for this cache.
That’s all for this update! We hope that you enjoy these new Power Query features. Please don't hesitate to contact us via the Power Query Forum or send us a smile/frown with any questions or feedback that you may have.
Follow this links to access more resources about Power Query and Power BI:
"Additional filters for Previous/Next “N” days/weeks/months/quarters/years" Nice! :+1
Thank you, "Data Cache Management Options"
I do like the date filter including previous and next n periods, but what I really miss is the option to define a start date other than today. Are there any plans to add this in the next release?
^5, +1, (thumbs up), "Like"
Keep up the great work.
Thanks, is the team planning to add ODBC as a data source, so that I can automatically retrieve data from pervasive, or is there a way to do that already
Is it possible to remove some header rows from a csv file? Note the header is above the tabular data and it does not align with the column header (i.e, date ran and name of report ran)
Is it possible to use Power Query to connect to Azure Table Dev storage with developer connection string (UseDevelopmentStorage=true) , if not can we get this in the next update?
Any plans soon to expand Power Query "Get External Data" tabs to include "From Analysis Services" to connect to SQL Server Analysis Services cubes?