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 en en en nl en en en en en en en en ru en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en ru en en en en en en en en en fr ca en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en ru en en en en en en en hbs_lat es en 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
Power BI Desktop June Feature Summary | Microsoft Power BI-blog | Microsoft Power BI
Office 365 + Power BI
This month our reporting features focus on accessibility and more flexibility when formatting your charts. With filtering and sorting options, our data view is now more powerful. Several connectors also get major updates this month, including a new driver for our SAP Business Warehouse connector that comes with numerous significant improvements.
Here’s te complete list of June updates:
High contrast support for reports
Pie and donut detail labels position control
Format data labels separately for each measure in a combo chart
Filtering and sorting in data view
New driver and improved performance
Improved support for hierarchy variables
Spark connector now supports Windows Authentication
Folding support for Top Rows
Ability to filter navigation by DSN catalog
For a summary of te major updates, you can watch te following video:
Join us at te Microsoft Business Applications Summit
Before jumping into te details, don’t forget to register for te Microsoft Business Applications Summit! Don’t miss te event to connect, collaborate, and pack in as much Power BI learning as possible, July 22-24 in Seattle.
There are going to be many great Power BI sessions and tons of chances to interact directly with te Power BI team.
High contrast support for reports
If you're using te high contrast mode Windows settings, your Power BI reports will now respect te color palette you're using. When using Power BI Desktop, we'll automatically detect which high contrast theme you're using and apply those colors across your report, similar to te experience you're used to with other Microsoft products, such as Excel.
In te Power BI service, we'll also try to detect which theme you're using and automatically apply it to your report, but depending on what browser you are using, we may not be able to. If you want to change te theme manually, you can select a high contrast theme under te View dropdown.
Note that if you're using high contrast themes on Power BI Desktop, you’ll still see some areas of te product that aren't using your theme’s colors. We’ll be adding more support for high contrast, along with other accessibility improvements, throughout te rest of this year.
Watch te following video to learn more about high contrast reports:
Our first formatting update for te month is te ability to control te inner radius of your donut chart. This lets you make te donut slimmer or thicker to get te style you want. You’ll find this option under te Shapes card in te formatting pane.
Pie & donut detail labels position
This month we're also updating our pie and donut charts to support moving your detail labels inside. You can pick between forcing te labels to always be outside or inside or to prefer one position over te other.
If you choose to move your labels inside te pie or donut chart, you can also choose whether te text can overflow past te edge of te shape and if te labels have a background or not.
Watch te following video to learn more about te pie and donut improvements:
Format data labels separately for each measure in a combo chart
Our last formatting improvement this month is an update to data labels in combo charts. Now you can customize individual series. In te Data labels card of te formatting pane, you can turn te Customize series option on to format an individual measure’s formatting options, such as color, display units, and te number of decimal point.
Watch te following video to learn more about te combo chart label update:
We've also extended te total length of phone reports this month. If you create custom layouts for your reports to be used in our mobile apps, you'll see that te grid is twice as long as before, jumping from 20 rows to 40.
Watch te following video to learn more about phone reports:
Te Organization Chart custom visual lets you create a tree view of your data. You can give each node a name, an image, and optionally a link to go to when clicked. Te tree is created by giving each node an id and its parent’s id, and te visual will use this to create te tree layout. There are several formatting options as well, such as node colors, orientation, and label formatting.
Download this custom visual on AppSource.
Watch te following video to see te Organization Chart custom visual in action:
Last month, we had te China Color Map custom visual, and this month we have te China Heat Map visual as a follow up. If you are using geographical data for China, you might want to try out te Chinese Heat map custom visual. This map has several features:
One-click switching between a national China map and provincial maps
Arbitrarily set te latitude and longitude of te area you want to display
Custom gradient range fill
Check out this custom visual on AppSource.
Watch te following video to see te China Heat Map custom visual in action:
Filtering and sorting in data view
We are very excited to announce te addition of filtering and sorting in te data view. For every column in your model, you can now see te sort direction if it is applied on that column and either filter individual values out or using advanced filtering options for that column type.
Watch te following video to see data view filtering and sorting in action:
We are vastly increasing te number of specific locales we support for formatting when viewing your reports in te Power BI service. With this update we are adding support for a total of 670 locales. For example, you’ll now see support for Mexico’s variant of Spanish along with many other Spanish variants. In Desktop, we detect and use te "date, time, and number formatting" format set for te operating system. IE and Edge will pass this same OS locale through, but other browsers often have their own, separate, language and region settings.
Make sure to use te default data format for your field if you want te te system locale settings to flow through. You can tell you are using system locale formatting by te * next to te format.
SAP BusinessWarehouse connector improvements
New driver and improved performance
Starting with this month’s release, te SAP BW connector supports a new implementation option labeled 2.0. Selecting implementation “2.0” in te SAP BW connector dialog while creating a new connection will switch from using te SapClient driver to a new SAP BW driver developed by Microsoft.
These are significant connector improvements that come with te new implementation:
Ability to retrieve several million rows of data, and fine tuning through te batch size parameter
Ability to switch execution modes
Support for compressed mode, which is especially beneficial for high-latency connections or large datasets
Improved detection of Date variables
[Experimental] Expose Date (ABAP type DATS) and Time (ABAP type TIMS) dimensions as dates and times respectively, instead of text values.
Better exception handling, so errors that occur in SAP BAPI calls are now surfaced.
Column folding in BasXml and BasXmlGzip modes. For example, if te generated MDX query retrieves 40 columns but te current selection only needs 10, this request will be passed onto te server to retrieve a smaller dataset.
Implementation 2.0 has a new pre-requisite, te SAP .NET Connector 3.0. Download of te connector is available from SAP’s website. Access to this download requires a valid SAP S-user. You are encouraged to contact your SAP Basis team to get this component.
Te connector comes in 32-bit and 64-bit versions, and you must choose te version that matches your Power BI installation. At te time of this writing, te website lists two versions (for .NET 4.0 framework):
SAP Connector for Microsoft .NET 3.0.20.0 for Windows 32bit (x86) as zip file (6.896 KB), January 16, 2018
SAP Connector for Microsoft .NET 3.0.20.0 for Windows 64bit (x64) as zip file (7.180 KB), January 16, 2018
While installing, in te “Optional setup steps” window, make sure to select te “Install assemblies to GAC” option:
After installing te required component, you must create a new connection to use te new implementation.
From te Get Data dialog, select either SAP Business Warehouse Application Server or SAP Business Warehouse Message Server.
You will be presented with te new connection dialog, that allows selection of te Implementation. Selecting Implementation 2.0 will enable te Execution mode, Batch size and Enable characteristic structures options.
Upon clicking OK, you will be taken to te Navigator dialog, from which te experience is te same as before.
You can learn more about this new implementation of te SAP BW connector by reading te following article: https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector
Improved support for hierarchy variables
We have made improvements to te hierarchy variables input UX in te Navigator dialog and Edit Variables screen, so that when modifying selection for a hierarchy node variable (i.e. US State), dependent variable values fields (i.e. City) are updated to only contain values defined within te selected hierarchy node.
Spark connector now supports Windows Authentication
We’re enhancing te Spark connector this month by adding support for Windows authentication. Upon specifying a server to connect to, you can now provide Windows authentication credentials in addition to te previous Basic (username/password) option.
Windows authentication support allows you to specify “current” or “alternate” user credentials. Additionally, you can specify te Realm, Host Fully-Qualified Domain Name and Service Name parameters, which are required in order to establish te connection to Spark clusters.
OData V4 connector enhancements
This month we’ve made significant improvements to our OData connector in order to provide richer support for OData V4.
Improved support for complex types: Te new experience for complex-typed properties is now much like that for navigation properties. Complex singleton properties can now themselves contain navigation properties, and complex collections are now imported as nested tables.
Open type navigation columns: While te existing OData connector has long supported importing extra data properties from an OData feed as open type columns, te enhanced connector extends this to also importing extra navigation properties, whether dynamic or from a derived type. In many cases we will still be able to fold even after following these navigation properties.
Improved support for custom URLs: Users who prefer to specify OData query options manually will find that te enhanced connector adjusts te type of te imported table according to te response.
Significant performance improvements: Loading feeds with many navigation properties has been massively sped up.
Greater resiliency: If for any reason a folded query fails, te enhanced connector will retry with less folding. This allows more queries to succeed without completely giving up on te improved performance from folding.
Te ODBC connector has been improved this month in a couple of ways:
Folding support for Top Rows
With this month’s release, “keep top rows” operations will be pushed down to te ODBC driver, which may improve performance of te connector if te driver and underlying data source support te “top” operator.
Ability to filter navigation by DSN catalog
If te DSN or connection string specified in te ODBC connector dialog includes a DSN catalog, Power Query will narrow down te list of tables exposed in te Navigator dialog accordingly.
Power BI is currently available in three separate national clouds, which offer te same levels of security, privacy, compliance and transparency as te global version of Power BI, combined with a unique model for local regulations on service delivery, data residency, access, and control. If your account happens to be provisioned in more than one cloud, you can now choose te cloud you want to use when signing into Power BI Desktop.
That’s all for this month! We hope that you enjoy these updates and continue sending us your feedback. Please don’t forget to vote for other features that you’d like to see in te Power BI Desktop. You can also download te .pbix file I used, and if you’re looking for a similar design for your reports, I was using te Sunset layout from PowerBI.Tips.
Join us at te Microsoft Business Applications Summit
Finally, remember to register for te Microsoft Business Applications Summit! Don’t miss te event to connect, collaborate, and pack in as much Power BI learning as possible, July 22-24 in Seattle.
I’m excited to meet many of you there!
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