This article describes previous updates to Power BI Desktop. For the most current month's release, check out Power BI Desktop latest updates.

The following sections describe previous months' updates to Power BI Desktop.

You can always download the latest version of Power BI Desktop.

May 2017 Update (2.46.4732.461)

The following updates are new to Power BI Desktop in May:

Report View:

Analytics:

  • Report level measures for live connections to Analysis Services tabular models and Power BI service datasets [video] [blog]
  • Two new quick measures (Preview) [video] [blog]
  • Bin by count [video] [blog]

Data Connectivity:

  • Combine files - ability to reference First File as example [video] [blog]
  • New data connectors:

Query Editing:

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

April 2017 Update (2.45.4704.442)

The following updates were new to Power BI Desktop in April 2017:

Report View:

Analytics:

Data Connectivity:

  • Connect to datasets in the Power BI service (Preview) [video] [article] [blog]
  • New or enhanced data connectors:
    • Redshift Connector: beta support, and Publish to Power BI service [video] [blog]
    • SAP HANA and BW: enhancements to parameter input experience [video] [blog]

Query Editing:

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

March 2017 Update (2.44.4675.422)

The following updates were new to Power BI Desktop in March 2017:

Report View:

Analytics:

Data Connectivity:

  • New or enhanced data connectors [video]:
    • Azure Analysis Services database (Beta) [blog]
    • Azure Data Lake Store - now generally available [blog]
    • DB2 connector - option to specify package collection [video] [blog]
    • Combine binaries - specify a sample file to use [video] [blog]

Query Editing improvements

  • Split column by delimiter - automatic detection of delimiter character [video] [blog]

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

February 2017 Update (2.43.4647.541)

The following updates were new to Power BI Desktop in February:

Report View:

Analytics:

  • Two new Quick Calcs: Percent of row total, and percent of column total [video] [blog]

Data Connectivity:

  • New or enhanced data connectors [video]:
    • ODBC and OLE DB connectors - support for Select related tables [blog]
    • Enhanced Folder connector - support for combining binaries from the Preview dialog [video] [blog]
    • Unified Text and CSV connectors [video] [blog]
    • New - PowerApps Common Data Service connector [blog]

Query Editing improvements

  • Quickly change a column's data type and locale with the new Using locale option in the Column headers type menu [video] [blog]
  • Easily insert steps into existing queries, using the new Insert Step After option [video] [blog]

Other improvements

  • Solutions Templates and Partner Showcase quick access [video] [blog]

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

January 2017 Update (2.42.4611.482)

The following updates are new to Power BI Desktop in January:

Report View:

Data Connectors:

  • New or enhanced data connectors [video]:
    • Visual Studio Team Services connector (Beta) [video] [blog]
    • Enhanced SQL Server connector - support for SQL Failover option [video] [blog]

Query Editing improvements

  • New transform: extract values from a nested list [video] [blog]

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

November 2016 Update (2.41.4581.301)

The following updates were new to Power BI Desktop in November:

Report View:

Analytics

Data Connectors:

Query Editing improvements

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

October 2016 Update (2.40.4554.361)

The following updates were new to Power BI Desktop in October:

Report View:

Analytics

Data Connectors:

Query Editing improvements

  • Support for table parameters in the Invoke Function dialog [blog] [video]

Other improvements

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

September 2016 Update (2.39.4526.362)

The following updates were new to Power BI Desktop in September:

Report View:

Analytics

Data Connectors:

  • New data connectors:
  • Improvements to existing connectors:
    • Oracle connector - improved Navigator previews performance [blog]
    • OData connector - support for Select Related Tables option [blog]
    • SAP Business Warehouse and SAP HANA connectors - enhancements to parameter input interface [article] [blog]
    • Web connector - support for specifying HTTP request headers within the dialog [blog] [video]

Query Editor improvements:

  • Query Dependencies view [blog] [video]
  • Show Errors experience [blog]
  • Query Editor ribbon support for scalar values [blog]
  • Add function invocation column [blog]
  • Expand & Aggregate columns - support for Load More values [blog]
  • New transform - convert Table Column to a list [blog]
  • Keyboarding - support for smart typing in drop-down menus [blog]

Other improvements

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

August 2016 Update (2.37.4464.321)

August introduced a full harvest of new features for Power BI Desktop:

  • [video] excerpts play in a new browser tab, when the feature is being discussed.
  • Some features have an [article] that provides more detail.
  • Most features are explained in the monthly update [blog] post.
  • Lastly, some features are self-explanatory and don't need and article or video.

You can also watch the Latest Updates video from the beginning, right inside this article, by clicking on the play icon on the video image found below the list of updates.

The following updates are new to Power BI Desktop this month:

Report View:

Analytics (New!)

Data Connectors:

  • New data connectors:
    • Snowflake connector (Preview) [blog]
  • Improvements to existing connectors:

Query Editor improvements:

Other improvements

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

July 2016 Update (2.37.4464.321)

You can always download the latest version of Power BI Desktop.

July brought another great collection of new features and highly anticipated data connectors to Power BI Desktop. The following enhancements were new to Power BI Desktop in July:

Report View:

Data Connectors:

  • New data connectors:
  • Improvements to existing connectors:
    • Web connector - support for specifying a connection timeout [blog]
    • CSV and Text - support for fixed-width delimited files [blog]
    • Improvements and changes to the SAP Business Warehouse connector [article] [blog]

Query Editor improvements:

  • Use R script in Query Editor [article] [blog]
  • Query parameter enhancements:
    • List query output as allowed values for a parameter [blog]
  • Overwrite existing user-defined functions [blog]

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these features (this is the same blog post references in the list above).

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

June 2016 Update (2.36.4434.362)

You can always download the latest version of Power BI Desktop.

June provided a shining collection of interesting updates for Power BI Desktop.

Report View:

Data Access:

Data Connectors:

  • New data connector: [blog]
    • Azure Enterprise
  • Enhanced SAP BW and HANA connectors: [blog]
    • Allow multi-select of values for Variables/Parameters
    • Support for Hierarchies in SAP BW
  • Enhanced OData connector - imports Open Type columns [blog]
  • Enhanced Access DB connector - button to Select Related Tables in Navigator dialog [blog]

Data Connectors:

  • Templates - option to Load or Edit [blog]
  • Query parameter enhancements: [blog]
    • Option to always allow Parameter specification
    • Create new parameter directly in context
  • Option to generate Step Names in English [blog]
  • Descriptions for Query Steps [video] [blog]
  • New Data Transformations: [blog]
    • Extract Week Day and Month Name from a DateTime column
    • Merging dates and Times into a DateTime column
    • Extract Time.Start/End of Hour/Minute/Second

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

May 2016 Update (2.35.4399.381)

You can always download the latest version of Power BI Desktop.

May brought another large collection of compelling updates for Power BI Desktop:

Report View:

Analytics

  • Quick Calcs - % of grand total [blog]

Data Connectivity:

  • New data connectors: [blog]
    • Informix
    • comScore Digital Analytix
    • Troux
    • Planview Enterprise
  • Improved DB2 connector [blog]
  • Text/CSV connector exposes editable settings in preview dialog [blog]
  • Improved relational database connectors with Display Schema information
  • Data Source Settings enhancements [blog]
  • Advanced Filter Rows dialog mode [blog]
  • Inline Input controls for Function invocation within Query Editor [blog]
  • Query Parameters: [blog]
    • Ability to convert queries to parameters (and vice versa)
    • Support for URL parameterization and multi-part URLs in Web connector
    • Support for parameterization in Conditional Columns dialog
  • Ability to Save As a Power BI Template [blog]
  • Support for reordering Query Steps using drag-and-drop [blog]
  • Date picker support in Conditional Columns dialog input Date fields [blog]
  • New context menu entry to create new queries from the Queries pane [blog]

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

April 2016 Update (2.34.4372.322)

You can always download the latest version of Power BI Desktop.

In April, we showered our great Power BI customers with another collection of compelling updates for Power BI Desktop. The following enhancements are new to Power BI Desktop this month:

Report View:

  • Additional styles on a table, matrix, and multi-row card
  • Trend lines on single visuals
  • New drill action – See Records
  • Map auto-zoom during drill/filter
  • In-line hierarchy labels for expanded view (Preview - see the article)

Data Modeling:

  • Modelling operations are no longer blocked while visuals are refreshing
  • Time Intelligence with built-in date hierarchy fields (Preview)
  • Data model synonyms

Data Connectivity:

  • Query Parameters
  • Power BI Template files
  • New Online Services category in Get Data dialog
  • New Connectors:
    • SharePoint Folder
    • Webtrends
    • SparkPost
    • tyGraph
  • Conditional Columns
  • DirectQuery – Specify DirectQuery vs. Import mode in data source dialogs
  • Column type indicator in Query Editor preview column headers
  • Reorder Queries and Query Groups using Drag & Drop gestures
  • Query Management menu in the ribbon

NOTE: You can also check out all the data sources available to Power BI Desktop; our list is always growing, so check back often.

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

March 2016 Update (2.33.4337.281)

You can now download the latest version of Power BI Desktop.

March brings all sorts of renewal and freshness, including another round of Power BI Desktop additions. The following enhancements are new to Power BI Desktop this month:

Report View:

  • Publish reports to a Group Space in the Power BI service
  • Reports with KPI trends now respect Do Not Summarize model settings from SSAS MD
  • Data Point warnings are now non-intrusive

Data Modeling:

  • You can now change the data type of a column when using DirectQuery mode
  • Ability to assume Referential Integrity on relationships (for those imported, and created) in DirectQuery
  • DirectQuery for Oracle and Teradata is now part of Power BI Desktop (no long a preview feature)

Data Connectivity:

  • A new SAP BW Connector (preview feature)
  • Support for Command Timeout in the user interface (UI)
  • There's a setting available to disable Privacy Level prompts at the machine level (including a registry key)
  • Query Group Management enhancements:
    • Expand/Collapse All
    • Retain Query Group expansion state
  • New Transformations:
    • Remove Blanks using the Column Filter menu
    • Convert Duration values to Years
    • Keep Duplicates
  • Support for whitespace and line feeds in Query Editor preview
  • Include hints for sample input values in the Change Type with Locale dialog
  • Enhancements to the Navigator window:
    • Add schema information to navigation hierarchy for ODBC sources
    • Ability to disable preview from Navigator
    • Technical name support
  • Load: Auto-step to disambiguate conflicting column names (case-insensitive comparison)
  • You can now rename queries directly from the Queries pane

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

February 2016 Update (2.32.4307.362)

You can now download the latest version of Power BI Desktop.

We're leaping ahead with more updates this month! February brings 29 days to the month (it's a leap year), and with it, 29 improvements to this monthly update of Power BI Desktop. The following enhancements are new to Power BI Desktop this month:

Report View:

  • See Data Behind a Visual (including Export Data to CSV)
  • Map improvements – plot map with latitude/longitude only
  • KPI consumption release support (including navigation hierarchy support and KPI trend for SSAS MD)
  • SSAS Exploration Mode: Support for Display folders in the Fields pane
  • Ribbon layout improvements: Contextual ribbon tab for Report Tools
  • New KPI visual
  • Get reports opened to the same page that was visible when they were saved
  • Edit Query option in table context menu in the Fields pane (Report & Data views)
  • Duplicate Page from the ribbon

Data Modeling:

  • Ability to define hierarchies
  • Performance Improvement: Table & Column rename optimizations

Data Connectivity:

  • DirectQuery support for Oracle and Teradata databases
  • DirectQuery – support for creating Calculated Columns
  • Support for publishing Analysis Services Live reports
  • JSON File connector
  • SQL Sentry connector
  • Support for jagged CSV files
  • Exchange Connector – OAuth support
  • SharePoint List Connector – URL validation
  • Database Connectors – ability to disable Navigation Columns in Query previews (Performance optimization)
  • Web Connector – fine-grained scoping of Credentials
  • Enter Data dialog UX enhancements
  • SAP HANA – Support for single sign-on with Windows Authentication (Power BI Desktop only)
  • SAP HANA – Support for Field labels
  • Alphabetical sort of columns in Choose Columns builder
  • Improved performance of renaming/removing/reordering columns
  • Virtualized Preview in Query Editor
  • Visual indicator for unloaded queries in Query Editor
  • 1-click Percentage transform

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

NOTE: You might also be interested in learning what's new in the Power BI service, and also check out what's new in the mobile apps for Power BI.

January 2016 Update (2.31.4280.361)

You can now download the latest version of Power BI Desktop.

Ring in the new year with another collection of improvements and enhancements to Power BI Desktop. The following enhancements are new to Power BI Desktop this month:

Report View:

  • Add borders to a visual
  • Add an image background to a visual

Data Connectivity:

  • DirectQuery: you can now create measures when using DirectQuery mode
  • You can now refresh data for individual tables from the Field List (in Report view and Data view), rather than (and in addition to) just being able to refresh all from the ribbon
  • General Availability (GA) for SQL Server Analysis Services Multidimensional models Exploration mode (no longer a preview feature)
  • Enhancements to hierarchy support
  • General Availability (GA) for the SAP HANA connector (no longer a preview feature)
  • Ability to append multiple tables within a single Append operation
  • Option to disable data previews to download in the background (performance optimization)

Other Improvements:

  • Support for Internet Explorer 9 (IE9) browser
  • Performance improvements for report rendering, cross-highlighting, and otherwise
  • Improvements to R integration in Power BI Desktop

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

December 2015 Update (2.30.4246.181)

December is a month for giving, and the Power BI team is following suit with more updates, features, and more functionality in this month's Power BI Desktop update. The following enhancements are new to Power BI Desktop this month:

Report Authoring:

  • Formatting Pane and Ribbon:

    • Format data labels per category services
    • Change the number of decimal places shown in visuals
    • Change text size in visuals
    • Ability to layout visuals accurately: alignment, distribute, size, position
    • Set styles across multiple visuals through Format Painter
    • Optimized Home ribbon layout
  • Enhancements to Visualizations:

    • Visual cue for sort state in Table visual
    • New visual: Stacked Area chart
    • Smart tooltips for Area and Line charts on hover
    • Ability to create reference line/region for a Cartesian visual
    • Improved data labels for Pie and Scatter charts
  • R Visuals integration in Power BI Desktop (Preview feature)

  • Suggested table-to-table relationships when trying to create visuals involving two tables which are not related

Data Modeling:

  • Relationships View
    • Zooming slider
    • Fit Zoom to screen
    • Reset layout
    • Ability to zoom in CTRL+(mouse selection range)

Data Connectivity:

  • SSAS Multidimensional support - hierarchies support
  • Stripe Connector
  • Smartsheet Connector
  • Enter Data: paste or enter data to create a table
  • DirectQuery improvements: support for all data types of T-SQL and SAP HANA, resulting in performance improvements
  • ODBC Connector: support for selecting User/System DSNs
  • CSV Connector: ability to specify Column Delimiter in the Source dialog

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

November 2015 Update (2.29.4217.221)

You can now download the latest version of Power BI Desktop.

Another month, another big collection of new features and improvements for Power BI Desktop. Improvements range from new data connectors to new modeling capabilities. Here are 26 new features and improvements:

Report Authoring:

  • Play Axis for Scatter Chart
  • Horizontal Slicers
  • Slicer Selection Behaviors (single vs. multi-select)
  • Control Z-order
  • Background Colors for Slides
  • Interactions between Visuals – Subview (tile by)
  • Duplicate Pages
  • Support for KPIs and Images in Tables, Matrices and Cards
  • Better Tooltips on Area Charts & Line Charts
  • Ability to change Text size in Cards & Tables/Matrix
  • Improved tooltips and labels in Field Well and Formatting panes
  • Ability to see Categories with no data
  • Improved Default Sort behaviors for visuals
  • Ability to control Axis Scale display units
  • Visuals Refresh Optimizations when applying basic modeling operations

Data Modeling:

  • Basic Automatic Date Features

Data Connectivity:

Data Transformations:

  • Improved Function Invocation experience
  • Option to set Credentials at Server vs. Database level
  • Add Prefix/Suffix to a Text column

Other Improvements:

  • New Documentation Website, now also including localized content

Want more information about these updates? Take a look at the blog post, where you can get more detailed information about each of these new features.

The following video describes and shows each of these updates. You can also see the video from the blog post.

October 2015 Update (2.28.4190.122)

October brings another large collection of updates to Power BI Desktop:

Report Authoring:

  • Custom Visualizations
  • Insert Visual from the Ribbon
  • Improved Default Sorting
  • Tooltips & Data Labels on Funnel Charts
  • Slicer Improvements:
    • Ability to Sort items
    • Ability to change Font Size
  • Additional Formatting Options for Gauges
  • Data Point Label layout improvements
  • KPI Consumption (Preview Feature)

Data Modeling:

  • Semi-Select support for DAX formulas in Data view

Data Connectivity:

  • Azure Document DB connector
  • Mailchimp connector
  • DirectQuery for SQL Server and Azure SQL Database (Preview Feature)

Data Transformations:

  • Filter by “not earliest/latest date”
  • Filter by “is in previous N minutes/hours/seconds”
  • Copy/Paste Queries between Power BI Desktop and Excel
  • Support for Special Characters in Split Column
  • Refresh Previews in Merge Queries dialog
  • Monospaced font for Query Editor Preview

Other Improvements:

  • Refresh Single Table (vs. All) from Report & Data Views
  • Option to enable Preview features
  • In-Product Ratings experience

You can view a video of all these updates, too.

For more information, check out the blog announcement that describes more details about each update.

September 2015 Update (2.27.4163.351)

The following massive collection of 44 features has been added to this update:

Report Authoring

  • Report-level filters
  • Drill Up/Down for column and scatter charts
  • New Page Size and Page View options
  • Support for inserting Shapes in the Report canvas
  • Fields pane improvements
    • Search Box to make it easier to find fields by name
    • “Expand/Collapse All” to improve navigation when there are multiple tables in the Fields pane
    • Field well cardinality support, drag-replace for buckets with 1 item
    • Additional Data Labels formatting options
    • Chart Cartesian Axis Improvements:
      • X-Axis label direction (horizontal / diagonal)
      • Support for Logarithmic & Linear scales for values in Y-axis
      • Display Text for hyperlinks in text boxes
      • Improvements to existing visualizations: Table, Matrix, Slicer, Scatter Chart, Single Cards, Combo Charts and Gauges
      • Support for displaying Color Saturation values in tooltips
      • Ability to resize images and apply additional formatting options

Data Modeling

  • Calculated Tables.
  • Relationships view:
    • Create relationships via drag/drop between two tables in the diagram.
    • Delete relationships in relationship view by selecting and hitting the Delete key.
    • Rename/delete tables and columns
  • Data view:
    • Copy Table contents to clipboard.
  • Field Summarization:
    • Support for additional operations in the Fields pane: median, standard deviation, and variance
    • Default summarization: Users can now customize the default summarization operation for any given field in their model

Data Connectivity

  • Support for on-premises Spark distributions
  • Support for SharePoint lists from non-English sites
  • Exchange connector - Enhanced support, now allowing connections to multiple mailboxes
  • Excel Workbook Connector – Automatic Column Type detection when importing .XLS files
  • “Select Related Tables” option when connecting to database sources
  • Enhanced Active Directory connector credentials, allowing alternate Windows Credentials
  • Improved Function Invocation experience when loading functions from a data source (such as a database)
  • “Import Excel Workbook Contents” feature released last month now also supports external connections to Analysis Services tabular models
  • New option to “Delete All” entries in the Data Source Settings dialog
  • Option to “Enable Relationship Import during Refresh operations”

Data Transformations and Query Editor Improvements

  • Copy to clipboard (available for cells/columns/tables)
  • Filter date columns by earliest/latest date (dynamic filter)
  • Extract min/max date/time value from a column
  • Replace Values - Provision for specifying special characters
  • “Detect Column Types” option to trigger type detection on demand
  • “Refresh All Previews” to refresh all Query Editor previews with a single click
  • Performance Improvements:
    • Choose Columns dialog: Faster user experience for dealing with wide tables
    • Auto-filter & Expand/Aggregate popups: Faster for large number of values/fields

The following video covers these features in more detail.

For more information about this update, check out the blog announcement that describes more details about each update.

August 2015 Update (2.26.4128.403)

The following features have been added to this update:

Overall Improvements:

  • Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop file

  • HDInsight Spark connector

  • Azure SQL Data Warehouse connector

  • Support for custom MDX/DAQ queries when importing data from SSAS

  • Live Analysis Services Connections: ability to change the database from Edit Queries dialog

Navigator dialog improvements:

  • Resizable Navigator dialog

  • Ability to multi-select items in Navigator (CTRL+click, SHIFT+click, etc)

Query Editor improvements:

  • Query Group creation/deletion improvements (multi-select, etc.)

  • Ability to Split Query (i.e. refactor common base steps into a new query)

  • Query Icons to reflect type of query in Queries navigator pane

Data Modeling improvements:

  • Resizing of columns in Data View

  • Moving Measures from one table to another

Take a look at the following video for more details about this update:

July 2015 Update (2.25.4095.554)

The following features have been added in this update:

  • New Data Connectors: appFigures, Quickbooks Online, Zendesk, Github, Twilio and SweetIQ.

  • New Transformations: Extract First/Last/Range of characters from a Text Column; Option to specify Join Type in the Merge Queries dialog; Ability to customize Quote Style in Split Column by Delimiter dialog.

  • Report Authoring Improvements: New visualizations (Area Chart, Waterfall, Donut & Matrix); New visual formatting and customization options (labels, titles, background, legend, colors, etc.); Insert Textbox and Picture in your report; Support for hyperlinks in reports and report tables; Undo/Redo actions.

  • Direct Report Exploration over Analysis Services Tabular Models.

  • Data Modeling: New Data View & Relationships views.

  • Publish reports to PowerBI.com, directly from Power BI Desktop.

  • Support for opening Recent Files in Start Page and "File -> Open" menu.

  • Support for Exchange UPN Credentials in the Exchange connector.

In addition to all these new features, we’re also making Power BI Desktop available in 42 different languages. Get the full list of languages and install the one you want from our official download page.

Take a look at the following video for more details:

May 2015 Update (2.23.4036.161)

The following features have been added in this update:

Modeling Features

  • Calculated Columns

  • Data Categorization

  • Sort By Another Column

  • Improved DAX Formula Editor: Function Help and Prototype

Get Data & Query

  • New ODBC Tables connector (Beta)

  • Improved to the Excel Workbook connector: better column type inference and faster load for data previews

  • New Text Column Filters - Does Not Begin With and Does Not End With

  • Enhanced Privacy Levels dialog

Take a look at the following video for details:

April 2015 Update (2.22.4009.122)

You can now download the latest version of Power BI Desktop.

The following features have been added in this update:

Modeling Features

  • Initial support for DAX Measures

  • New DAX functions

  • Data Types & Formatting options in Report view

  • Rename & Delete fields in Report view

Get Data & Query

  • OData V4 support

  • Support for Custom ADFS Authentication Services

  • Updated Facebook connector due to Facebook API changes

  • Unified Options dialog

  • Option to disable Native Database query prompts

  • Support for Fixed Decimal Number type

  • Alternate Windows Credentials

  • Remove Blank Rows

  • Median Operation available for Group By and Aggregate Column

  • Convert DateTimeZone value to Local Time

Performance Improvements

  • Faster load of medium & large datasets by about 20%

  • Improved time to open an existing PBIX file by about 50%

You can watch the following video for details: 

March 2015 Update (2.21.3975.261)

The following features have been added in this update:

  • Google Analytics connector

  • Additional operators for date filtering in Query view

  • Automatic Model Relationship Detection

  • Enhanced Add Relationship dialog

  • Report Pages Re-ordering (drag & drop)

  • ~40-50% Performance Improvement filling database tables without filters/transforms

  • Lots of bug fixes

You can watch the following video for more details:

February 2015 Update (2.20.3945.102)

The following features have been added or improved in this update:

  • Performance improvements
  • Dynamics CRM Online connector > Note: Currently, only URLs within the crm.microsoft.com domain are accepted by this dialog. This does not include non-production tenants. We’ll fix this issue in our March update. The temporary workaround is to connect to this feed using “From OData”.
  • Navigator Dialog improvements
    • Better preview experience for multi-dimensional sources (Analysis Services and SAP BusinessObjects)
    • Show Selected Items option
    • Improved Search capabilities in the Navigator tree
  • New Transformations
    • Age and Subtract operations for Date/Time columns
    • Aggregate Columns: Option to disable new columns’ prefix
  • Field List improvements
    • Expand/Collapse tables
    • Hide/Unhide fields
    • Optimized layout (spacing, margins, and fonts)
  • Report Pages Navigation - Keyboarding support
  • Lots of bug fixes

January 2015 Update (2.19.3923.101)

This month we've made a number of improvements and bug fixes under the covers. Please try out the new version and continue to send us feedback if you find any issues!