What’s new in Power BI

We’re constantly adding new features, new capabilities, and updates to Power BI. This page provides information about monthly updates available for the various features of Power BI.

What's New in Power BI

You can learn more about Power BI from the Overview and Learning page.

Interested in getting Power BI for your organization? Check the Power BI for Office 365 page for information on how to register. You can also get information on the Power BI Service Description, known issues, and forums.

The following is a list of what’s new in Power BI, organized by month. Please note that these updates are cumulative; current releases include updates from previous months.

This Month’s Updates

This month, updates to the features and services for Power BI for Office 365, as well as updates to the self-service features of Excel, can be found in our Marketing blog. Here’s the link:

Power BI for Office 365 Marketing Blog

This is a temporary arrangement; all updates (including updates posted to that blog) will return to this page shortly, so you know exactly which updates were introduced, and when.

Updates for April, 2014

The following lists describe the updates to Power BI for Office 365.

Admin Center

  • Improved the description of how to get a connection string from an Excel workbook.

Data Management

Improvements to how you manage data sources:

  • In the Data Sources list, each data source displays a color-coded status of Complete, In Complete, or Missing. This makes it easier for you to manage data sources.
  • You can filter the Data Sources list by my queries data sources or all data sources.

Q&A

Did you find a great insight using Q&A?  Now you can share your discovery using the Share by Email and Share a Link buttons to the right of the question box.

Updates for March, 2014

The following lists describe the updates to Power BI for Office 365, and for the Power Query and Power View business intelligence features of Excel.

Power Query

  • There’s a new Selection Well for multi-table import
  • Improvements were made to the layout of the Query Editor Ribbon
  • You now get a warning when trying to insert an intermediate step in your query
  • Improvements were made to Insert Custom Column
  • There’s a more informative message regarding Privacy Levels
  • Improvements were made to From Table selections
  • During Query Load, there are now distinctions between cancellation and errors

To download the most recent version of Power Query, visit the Microsoft Power Query for Excel download page.

Power View in HTML5, and Power BI Windows app

  • You can now view tiles
  • You can view database images
  • You can drill down, and back up, in a matrix
  • Improvements with interacting with tables and matrixes on a touch device

Power BI for Windows app

  • Additional languages – you can now view the app in nine languages
  • You can now view maps with a single series of data
  • Take advantage of Windows 8.1 capabilities

Q&A

Improvements to the SharePoint online experience:

  • Made it easier to fine-tune your Q&A result by consolidating controls for visualization type, filters, and additional fields on the right-hand side of the screen.
  • Featured Questions now appear on their own page.

Added navigation for common tasks right beside the question box for easy access.  For example, you can now navigate back to the featured questions collage.

Updates for February, 2014

Microsoft Power BI for Office 365 moved from preview to general availability.

Updates for January, 2014

Most of the updates for January focused on product quality improvements – over 250 product issues and improvements were made in this release, primarily focused on Power Query.

Power Query

The following functionality is new for Power Query:

  • More than 250 improvements and fixes were included in this release
  • Significant improvements to the Text/CSV import experience, including automatic detection of column delimiters
  • The Advanced Query Editing feature in Query Editor is now available in the View tab of the ribbon

Updates for December, 2013

Many updates were introduced in December. The following sections describe the updates.

Power Query

The following functionality is new for Power Query:

  • Power Query can now connect to more data sources:
    • Sybase IQ
    • Exchange
    • Dynamics CRM Online
  • When selecting multiple tables in the Navigator pane, Power Query automatically detects database relationships.
  • The Replace Shared query has been removed.
  • You can now Share your query from the Query fly-out
  • New Query Editor ribbon buttons were added for Fill Down, Sort Ascending/Descending and Number Transformations.
  • A new Certified button was added to the Search ribbon, enabling Search result to only show Certified results.

Admin Center / Data Management Gateway

The following functionality is new for the Power BI Admin Center:

In addition, one aspect of functionality for the Admin Center has changed with the December 2013 update:

  • You cannot monitor system health information using the dashboard in Admin Center, or by using OData feed.

Other updates for December include the following:

Updates for November, 2013

Power Query

With this month’s updates, Power Query enables authorized business users to certify shared queries in the Power BI Data Catalogue as authorized or authoritative:

  • Only members of the Data Steward role can certify shared queries. Power BI administrators can use the Admin Center to add users to the Data Steward role.
  • Members of the Data Steward role can apply the Certified flag to when sharing queries, and can set (or clear) the Certified flag when editing a shared query’s metadata in Power Query.
  • In Power Query search results, and search preview fly-out, certified queries are decorated with a special icon – a ribbon: Certified Query icon. Users can filter search results so that only certified queries are returned.

For more information, see Certify Queries.

But wait, there’s more:

  • You can now easily view and manage (edit, duplicate, reference, merge, append, share, and delete) all your queries in an Excel workbook from a single place. For more information, see View and Manage Queries in a Workbook.
  • You can now import data from all the supported databases in Power Query, except Microsoft Access, by using native database queries. For more information, see Import Data from Database using Native Database Query.
  • You can now perform Merge and Append operations inline, that is, as a new step at the end of the current query, instead of as a new query, when you perform these operations inside the Query Editor.
  • You can now connect to Microsoft Azure Table Storage sources from within Power Query, see Connect to Microsoft Azure Table Storage.
  • In this release we have greatly improved the Import and Navigation experience for hierarchical data sources (such as Databases, Web pages, OData feeds, etc.). You can directly select a table and load it into your workbook. We’ve also added the ability to import multiple items from the same source in a single shot, and specify whether you want to land them in a new Excel sheet or in the Data Model.
  • You can now specify the Load Settings for each of your queries upfront, within the Query Editor experience, which will save you from having to modify them after the initial load and maintain different artifacts in your workbook. Also when you disable “Load to worksheet”, we no longer create a sheet placeholder for this query, since the query can now be accessed from within the Workbook Queries side pane.
  • You can now use the Query Editor ribbon to perform reshape operations. The ribbon has the same functionality as the query context menus.

Admin Center / Data Management Gateway

Updates for October, 2013

This month’s Power Query updates were provided in the Power BI Team blog. Feel free to check out the Power BI Team’s most recent blog, too.

 
 
Applies to:
Power BI for Office 365