Power BI Desktop September update

4CThwllOThe team behind Power Bi Desktop just had to top the number 42, so in this update there is 44 new features for us to play with.

Features is spread around the product on areas such as Report Authoring, Data Modeling, Data Sources and Data Transformation capabilities. The team have been very active and as they say, it is almost 2 features a day since the last update. So it is fair to say that this is a product that Microsoft invest heavily in, and the features will just keep on coming.

One of the features, I personally hope to see in the near future is to allow me to publish a report to the public. Share the report with people outside my organization and not just within.

That would be really cool, and even make the  POWER BI BEST VISUAL CONTEST easier to participate in, and showcase the reports instead of flat boring screenshots. But hopefully they will take this into consideration in the next update.


Here is the list, taken from their blogpost, for a full walkthrough of each new feature, please go to the Power BI Team Blog

Here is a summary of the new features included in this update (it will not be a short one, though):

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 textboxes.
      • 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-Prem 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:
  1. Choose Columns dialog: Faster user experience for dealing with wide tables.
  2. Auto-filter & Expand/Aggregate popups: Faster for large number of values/fields.

Leave a Reply