en en ms fi da da da da ca da da da ms hbs_lat ms ms ms en da da ms ms da es da de ro en da da da da de da da de en it da da da es da da en da da da en da sv de da en da en en en en en da pt fr fr en de en sv da da da da sv da da en en en es en en en en en en en en fa en en en en en en en en en en en en en en en en en en en la en en en en en en en en en fr en en en en en en en en en en en en sco en en en fa en en oc fa en en en en de en da da da da da en da da da da da en tr da ca en en id en en en en en en en en ms ms ms en en ml da nl en en nl nl da en da de de en en nl en en nl nl sv en da de de en en nl en en nl nl sv en da de de en en nl en en sv nl da en da de da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da de de en en nl en en nl nl da en da de de en en nl en en nl nl da en da de de en en nl en en nl en da ms en en en sv da fr da it de en ms ms en it da da de en en en sv da en da en da da en da da da hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko da nl nl pl pt pt ru sv th tr zh zh ar he
6 new updates in Power Query – July 2014 | Microsoft Power BI-blog | Microsoft Power BI
Office 365 + Power BI
Group Program Manager - Data Integration
Additional Query Editor transformations
Te July 2014 Update for Power Query is now available. You can download it from this page.
This update is packed with lots of new features, so please take a look at te following video and te rest of this blog post. We hope that you like them!
Here is a summary of te new features included in this release:
More flexible Load Options for your queries.
Improved Error Debugging Experience.
Additional Query Editor transformations:
Replace Errors within a column.
UX for defining Math operations based on a single column.
Options dialog: Restore Defaults & Tips for Cache Management
Update notifications: 3 notifications per update (max.), once per day at most.
More flexible Load Options
One of te most common areas of feedback about Power Query in te past has been te desire of having additional options to control how and where to load queries within your workbook. In this update, we’re introducing a new Load Options dialog to customize how to load your queries. In addition to controlling whether a query should be loaded to te worksheet or Data Model, we now offer you te option to load to an existing worksheet instead of always loading to a new worksheet. It is also more clear now how to disable te load of a query (or to “only create connection” instead of downloading te results), which until now was only possible by disabling load to worksheet and load to Data Model.
In addition to new options for how to load your queries, another area of feedback has been te need to have access to these options in all places from which users can load queries to their workbook. To address that, te following entry point have been added in this update…
•From te Navigator pane:
•From te Query Editor:
•From te Workbook Queries pane and te contextual Query ribbon tab (to reconfigure te Load Options of an existing query without having to go back to te Query Editor):
Query Groups is a new concept introduced in this update that will help users better organize their queries within a given workbook, as well as perform bulk operations on all queries within a group (such as Refresh). Up until now, Power Query offered only a few capabilities in order to organize queries in te Workbook Queries pane, primarily moving queries up and down in te list.
With this update, users can now select multiple queries using (CTRL + Click) and move them into their custom groups. Users can define as many groups as they want in te workbook, as well as groups within groups to create more advanced organization layers. This enables them to organize and classify te queries better within their workbook. In addition, users can leverage te context menu for each group entry to apply bulk operations to all queries within that group.
Improved Error Debugging Experience
In previous Power Query updates, we introduced some transformation capabilities within te Query Editor to “Remove Rows With Errors” and to “Keep Rows With Errors” within your queries. These features were helpful in order to discard all error rows or to narrow down to just te rows with errors in te final result, but didn’t quite help users to see these errors in context, understanding te row from te result where these errors were introduced. In addition, after loading queries into te workbook, users would get in te Workbook Queries pane an indication of te total number of rows and te number of errors but weren’t able to easily preview those errors from this pane.
With this update, we’ve turned te “Number of rows with Errors” indicator into a hyperlink which brings up a preview of te rows with errors that users can explore and interact with. This preview also includes te row index to better understand where these errors appear.
There are cases in which te way to resolve errors within your data is not to ignore te rows with errors but rather to replace te error values with a default value for te column. We’re introducing te ability to do this: a new “Replace Errors” operation is available in te Transform tab inside te Query Editor. This option brings up a dialog asking users for te value to replace errors with for te selected columns.
UX for defining Math operations based on a single column
Very frequently, users find te need to add new columns to their queries that reference a different column and apply a Math operation. In previous updates, we introduced te “Add Column” tab which provides several operations that will create new columns based on one or multiple existing columns. One limitation until now was that, for Math Standard operations (Add, Multiply, Subtract, Divide, etc.), users were only allowed to select two columns, representing te first and second operators.
In this update, we’ve added te ability to select just one column and use these Math operations. Users will be asked to provide te second operator in a dialog, and te result will be a new column added to te query with te selected Math calculation. This is available for all operations under te Standard dropdown menu in te “From Number” group, part of te “Add Column” tab.
Options Dialog: Restore Defaults & Tips for Cache Management options
If you followed our last two updates, you may be already aware that we have introduced new options for Custom Default Load Settings and Cache Management. This made te amount of choices in te Options dialog grow significantly, but there wasn’t an easy way to “reset” Power Query to its default behaviors. Well, now there is such way…  : )
In addition to te new “Restore Defaults” button, we have added a few tooltips to help users better understand te Cache Management options introduced in our previous update.
As you may be already aware, Power Query has an Update notification mechanism that tells users about our updates every month. This notification was displayed to te user in te system tray every time that they launched Excel and there was an update available. While this works out great for many users, we also heard from some of them that installing these updates wasn’t directly possible for them and they needed to notify their system administrator to perform this update and wait for a few days or weeks. At that point, seeing te Update notification continuously displayed in te system tray every time they launched Excel would become annoying…
With this update, we’ve limited te number of times that a user will see te Update notification to three times per update (i.e. three times each month). In addition, we have also limited these updates to only be displayed once per day. We believe that this will establish a good balance between making users aware of our updates while also not reminding them too many times. : )
That’s it for this update… We hope that you enjoy these new Power Query features. Please don’t hesitate to send us a smile/frown or post something in our forums with any questions or feedback about Power Query that you may have.
Follow this links to access more resources about Power Query and Power BI:
See Power BI in action
Follow @MSPowerBI on Twitter to learn more about how you can #ExpressUrCells!
Tilmeld dig Power BI-nyhedsbrevet
Tilmeld dig nedenfor for at modtage de seneste nyheder fra Power BI direkte i din indbakke.
Land Afghanistan Albanien Algeriet Amerikansk Samoa Andorra Angola Anguilla Antarktis Antigua og Barbuda Argentina Armenien Aruba Aserbajdsjan Australien Bahamas Bahrain Bailiwick of Jersey Bangladesh Barbados Belgien Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnien-Hercegovina Botswana Bouvetøen Brasilien Brunei Darussalam Bulgarien Burkina Faso Burundi Cabo Verde Cambodja Cameroun Canada Caymanøerne Chile Cocosøerne (Keelingøerne) Colombia Comorerne Congo Cookøerne Costa Rica Côte d'Ivoire Curaçao Cypern Danmark De Amerikanske Jomfruøer De Amerikanske oversøiske øer De Britiske Jomfruøer De Forenede Arabiske Emirater Den Centralafrikanske Republik Den Demokratiske Republik Congo Den Dominikanske Republik Det Britiske Territorium i Det Indiske Ocean Det palæstinensiske selvstyre Djibouti Dominica Ecuador Egypten El Salvador Eritrea Estland Etiopien Falklandsøerne Fiji Filippinerne Finland Frankrig Fransk Guyana Fransk Polynesien Franske Oversøiske Områder Færøerne Gabon Gambia Georgien Ghana Gibraltar Grenada Grækenland Grønland Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard- og McDonaldøerne Honduras Indien Indonesien Iran Irland Island Isle of Man Israel Italien Jamaica Jan Mayen Japan Jordan Juleøen Kasakhstan Kenya Kina Kirgisistan Kiribati Korea Kosovo Kroatien Kuwait Laos Lesotho Letland Libanon Liberia Liechtenstein Litauen Luxembourg Madagaskar Malawi Malaysia Maldiverne Mali Malta Marokko Marshalløerne Martinique Mauretanien Mauritius Mayotte Mexico Mikronesien Moldova Monaco Mongoliet Montenegro Montserrat Mozambique Namibia Nauru Nederlandene Nepal New Zealand Nicaragua Niger Nigeria Niue Nordmakedonien Nordmarianerne Norfolk Island Norge Ny Kaledonien Oman Pakistan Palau Panama Papua Ny Guinea Paraguay Peru Pitcairn Polen Portugal Puerto Rico Qatar Reunion Rumænien Rwanda Saba Saint Barthélemy Saint Kitts og Nevis Saint Lucia Saint Martin Saint Pierre og Miquelon Saint Vincent og Grenadinerne Salomonøerne Samoa San Marino São Tomé og Príncipe SAR Hongkong SAR Macao Saudi-Arabien Schweiz Senegal Serbien Seychellerne Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakiet Slovenien Somalia South Georgia og De Sydlige Sandwichøer Spanien Sri Lanka St. Helena, Ascension, Tristan da Cunha Storbritannien Sudan Surinam Svalbard Sverige Swaziland Sydafrika Sydsudan Syrien Tadsjikistan Taiwan Tanzania Tchad Thailand Timor-Leste Tjekkiet Togo Tokelau Tonga Trinidad og Tobago Tunesien Turkmenistan Turks- og Caicosøerne Tuvalu Tyrkiet Tyskland Uganda Ukraine Ungarn Uruguay USA Usbekistan Vanuatu Vatikanstaten Venezuela Vietnam Wallis og Futunaøerne Yemen Zambia Zimbabwe Ækvatorialguinea Østrig Ålandsøerne
Jeg vil gerne modtage Power BI-nyhedsbrevet. Erklæring om beskyttelse af personlige oplysninger.
Deltagelse kræver, at dine personlige oplysninger overføres til andre lande, som Microsoft driver forretning i, herunder USA. Når du sender denne formular, accepterer du overførslen af dine data uden for Kina. Erklæring om beskyttelse af personlige oplysninger.
Hvad er Power BI?
Power BI er en pakke med virksomhedsanalyseværktøjer til dataanalyse og vidensdeling. Overvåg din virksomhed, og få hurtigt svar med omfattende dashboards, der er tilgængelige på alle enheder.
Få de seneste nyheder fra Power BI-blog
Abonner via mail Du skal angive en gyldig mailadresse Du har angivet en personlig mailadresse. Angiv din arbejds- eller skolemailadresse. Noget gik galt. Prøv igen senere.
Beskyttelse af personlige oplysninger og cookies