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 nl en en en en en en en en en pt 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 it it ceb en eu it it it it id it it en en en en en en en en en en en en en en en en en es 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 uk en es en ru hbs_lat ms sco 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
16 New Updates to te Power BI Designer Preview | Microsoft Power BI-blog | Microsoft Power BI
Office 365 + Power BI
Group Program Manager - Data Integration
Try what’s coming next for Power BI!
Te following features are new or improved in this update:
Initial support for DAX Measures.
Data Types & Formatting options in Report view.
Rename & Delete fields in Report view.
Support for Custom ADFS Authentication Services.
Updated Facebook connector due to Facebook API changes.
Option to disable Native Database query prompts.
Support for “Fixed Decimal Number” type.
Median Operation available for “Group By” and “Aggregate Column”.
Convert DateTimeZone value to Local Time.
Faster load of medium & large datasets by about 20%.
Improved time to open an existing PBIX file by about 50%.
You can continue reading below for more details and videos about each feature.
Initial support for DAX Measures
In this update of te Power BI Designer you can now enrich your models by writing measures using DAX.
Formula bar: Using te new formula bar in te Report view you can create measures by writing formulas in te DAX language. Te formula bar helps you write these formulas by differentiating functions, fields and measures using syntaks coloring, it provides intelligent function and field suggestions and tells you if parts of your DAX expression are wrong using error ‘squiggles’. It also allows you to use multiple lines (Alt + Enter) and indentation (Tab).
Comments: Te formula bar also allows you to write comments as part of your measures, just type “//” and everything after these characters on te same line will be considered a comment.
You can also use /* to add your comment */ in te middle of a formula.
Saving incomplete measures: How often are you in te middle of writing a complex Measure and wanted to ask your colleague for help but do not have a way of saving this half-written measure? Te Power BI Designer now allows you to save measures that are invalid so you can just save your file and take it to your colleague, or continue to work on it another day.
You can watch these features in action in te following video.
For more information on Measures, check out these links:
Measures in Power BI Designer
Tutorial: Create your own measures in Power BI Designer
QuickStart: Learn DAX basics in Power BI Designer
We’re just getting started with DAX authoring in te Power BI Designer… Over te next few months we plan to enhance te formula bar even further and will update te Designer to add calculated columns to te model. So stay tuned!
Besides enabling you to add measures in te Power BI Designer, we have also added several new DAX functions that will allow you to solve more complex business problems, here are some of te most exciting new functions:
Te full list of DAX functions
Data Types & Formatting options in Report view
In this update we’re adding te ability to change Data Types and Format for Fields within te Report view. This will make it much easier for you to change column types, without having to go back into te Query view.
In addition to Data Types, we’re enabling Formatting options specific to each data type (i.e. Date, Number, etc.).
In order to access these options, select te field you’d like to change within te Fields pane and use te Data Tools – Modeling contextual ribbon tab.
This short video shows you te feature in action:
Learn more about Data Types in te Power BI Designer
Rename & Delete fields in Report view
Another new feature available within te Report view with this update is te ability to Rename and Delete fields within te Fields pane. This makes it much more convenient for you to customize fields, instead of having to go back to rename your columns in te Query view.
These two options can be accessed in te context menu when right-clicking on a specific field.
Watch te following short video to learn more about Rename & Delete fields in te Report view.
We’re adding support for OData V4 feeds. You can just use te existing OData Feed connector, which will now also accept feeds built using te latest OData version.
Support for Custom ADFS Authentication Services
With this update, we’re adding support for using custom ADFS authentication endpoints through our Organizational Account credential type. This allows access to data sources that require ADFS authentication such as some on premise instances of Dynamics CRM. After Power BI is registered by your admin, you will be able to approve a custom endpoint when prompted for access. You can also manage te list of already-approved endpoints within te Options dialog, under “Global -> Security”.
As of April 30th 2015, Facebook will expire v1.0 of its Graph API. Te Graph API is what Power BI uses behind te scenes for te Facebook connector, allowing you to connect to your data and analyze it. Unfortunately this expiration means some changes in te Facebook connector as it currently exists. Te most important difference is te set of permissions we’re able to leverage and te data those permissions return. For example, Friends Lists and News Feeds are commonly used permissions that are now changed or inaccessible.
Queries that were built before April 30th may no longer work or return less data. After April 30th, Power BI will leverage v2.2 in all calls to te Facebook API. You’ll likely need to authenticate again, to approve te new set of permissions that we’ll ask for. More details on te change in te Facebook API are available here.
Option to disable Native Database query prompts
One interesting capability when connecting to databases is te ability to provide a custom SQL statement. This is useful for customers who already had complex SQL queries to pull data for their reports and wanted to get started with te Power BI Designer.
However, there is a potential risk for these queries to contain malicious SQL code that could delete or modify content in a database when executed. Because of this risk, we have an existing security prompt whenever users try to run a native database query outside of te data source dialogs. It turns out that lots of customers are using this capability within Custom Columns or similar scenarios, so that they can dynamically build and execute native database queries. Te downside of this is that they would get prompted for approval of every distinct SQL statement, which would make te experience very inconvenient.
In order to enable these customers to achieve their scenarios, we’re introducing an option to disable Native Database Query security prompts. Please use this under your own responsibility and beware of te potential risks mentioned above… You can find this option within te Options dialog, under Global -> Security.
Learn more about Native Database Queries by watching te following video.
We have unified te File Settings dialog and te Options dialog into a single one. This dialog is now organized by scope (current file vs. global) and categories for easier navigation.
See more details about te new unified Options dialog in te following video:
Support for “Fixed Decimal Number” type
We have added support for “Fixed Decimal Number” type. This new type can be found in te Data Type dropdown menu, in both te Query view and te Report view.
You can find more information about Fixed Decimal Number and other data types in te Power BI Designer in this page.
Added an option to use Alternate Windows Credentials (rather than current user) to te Windows credentials option in te Credentials dialog.
We continue making incremental improvements to te set of transformations supported in te Query view. This month, we’re adding support for te following new transformations:
Median Operation available for “Group By” and “Aggregate Column”.
Convert DateTimeZone value to Local Time.
Want to see these transformations in action? Check out te following video.
In addition to all te functional improvements described above, we’re also making te Power BI Designer much faster this month, in a couple of different areas:
Faster load of medium & large datasets by about 20%.
Improved time to open an existing PBIX file by about 50%.
That’s all for this month. As mentioned previously, we’re making lots of incremental improvements to te Power BI Designer and we hope that you find it better with every new monthly update…
Please continue sending us feedback using our “Send a Smile/Frown” feature, or by voting for what you’d like to see next.
Here is also a full version of te video that combines all What’s New videos from this announcement.
What can I do next?
Preview what’s next for Power BI
Download te Power BI Designer
Follow @MSPowerBI on Twitter
Sign up for te Power BI Newsletter
Watch our Getting Started webinar on demand
Watch our Power BI Designer webinar on demand
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