Previous monthly updates to Power BI Desktop and the Power BI service

Article
04/09/2024

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

The monthly blog and video updates for Power BI Desktop now also include "what's new" updates for Power BI mobile and the Power BI service. In each section, choose the tab for Power BI Desktop or for the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each update mean the following:

[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 an 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 sections describe previous months' updates to Power BI Desktop and the Power BI service.

March 2024 Update (2.127.1080.0)

We felt lucky as a four-leaf clover about March's month's collection of updates, capabilities, and features for the Power BI service and Power BI Desktop.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Get the latest version of Power BI Desktop from the Download Center. If you're running Windows 10, you can also get Power BI Desktop from the Microsoft Store. Regardless of how you install Power BI Desktop, the monthly versions are the same, although the version numbering might differ. For more information about downloading and installing Power BI Desktop, see Get Power BI Desktop.

Important

Power BI Desktop is updated and released on a monthly basis, incorporating customer feedback and new features. Only the most recent version of Power BI Desktop is supported; customers who contact support for Power BI Desktop will be asked to upgrade to the most recent version. You can get the most recent version of Power BI Desktop from the Windows Store, or as a single executable containing all supported languages that you download and install on your computer.

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Visual calculations update (preview) [blog] [video] [article]
On-object interaction updates [blog] [video]
Mobile layout auto-create (preview) [blog] [video] [article]
Expanding spatial data integration: Shapeful support in Azure Maps visual [blog]
Data bars in matrix subtotal/total conditional formatting [blog]
Data labels alignment [blog]

Modeling

Write DAX queries in DAX query view with Copilot (preview) [blog] [video] [article]
Enhanced row-level security editor is enabled by default (preview) [blog] [article]
Selection expressions for calculation groups (preview) [blog] [article]
DAX query view improvements (preview) [blog] [article]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog] [video]

Other

Connect to new data sources from Power BI Report Builder [blog] [video] [article]
Localized parameter prompts in Power BI Report Builder [blog] [video] [article]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes many of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

You can also download previous versions of Power BI Desktop if your organization requires it. We always recommend that you use the most recent version of Power BI Desktop, rather than a previous version. All previous versions have the following limitations:

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

Select the following links to download this earlier version:

February 2024 Update (2.126.927.0)

Our hearts were full of love for this month's collection of updates, capabilities, and features for the Power BI service and Power BI Desktop.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Visual calculations (preview) [blog] [video] [article]
Dynamic subscriptions for Power BI reports (preview) [blog] [video] [article]
On-object interaction updates [blog]
Power BI Home in Power BI Desktop is enabled by default (preview) [blog] [video] [article]
Enhanced reference layer in Power BI Azure Maps visual [blog]

Modeling

Measure descriptions with Copilot (preview) [blog] [video] [article]
DAX query view improvements (preview) [blog] [article]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog] [video]

Other

Protected PBIX in Power BI Desktop [blog] [video]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes many of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

Select the following links to download this earlier version:

December 2023 Update (2.124.581.0)

Like a collection of holiday gifts, this month's Power BI updates were full of analytics tools, toys, and capabilities for the Power BI service and Power BI Desktop.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

On-object interaction updates (preview) [blog] [video]
More styling options for column and bar charts [blog] [video]
Extended customization for data labels [blog] [video]
Azure Maps clustering aggregation support for bubble layer [blog]
Alerting on your Power BI reports with Data Activator [video] [blog] [article]

Data connectivity

OneLake data hub in Power BI Desktop [video] [blog] [article]
Power BI connector updates [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

Select the following links to download this earlier version:

November 2023 Update (2.123.326.0)

We were all thankful for the platefuls of updates to Power BI this November, with all sorts of update helpings for BI Desktop and the Power BI service.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Button slicer (preview) [blog]
Reference labels (preview) [blog]
Enhance your Q&A visual with suggested synonyms from Copilot [blog] [article]
On-object interaction updates [video] [blog]
Azure Maps visual now aggregates multiple data points at the same location [blog]
Narrative visual with Copilot [video] [blog]

Modeling

Datasets renamed to semantic models [blog]
Power BI semantic models support for Direct Lake on Synapse Data Warehouse [blog] [article]
DAX query view to write and run DAX queries on your model [video] [blog] [article]
Edit your data model in the Power BI service (updates) [blog]

Data connectivity

Azure Resource Graph (new connector) [blog]
Many connector updates [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog]

Other

Enhanced accessibility in paginated reports authored in Report Builder [blog] [article]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

Select the following links to download this earlier version:

October 2023 Update (2.122.442.0)

October was full of scary-good features and a pumpkin-patch of updates. Navigate through this section of this article for a corn-maze like expedition through October's offerings for Power BI Desktop and the Power BI service.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Power BI Desktop OneDrive and SharePoint integration [video] [blog]
On-object interaction updates (preview) [video] [blog]
Power BI home in Power BI Desktop [video] [blog]
Deduplication rules for composite models on Power BI semantic models and Analysis Services [video] [blog] [article]

Modeling

Edit your data model in the Power BI service (updates) [video] [blog]
Model explorer public preview with calculation group authoring and creating relationships in the properties pane [video] [blog] [article]

Data connectivity

Many connector updates [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

Select the following links to download this earlier version:

September 2023 Update (2.121.644.0)

September brought us a new classroom full of Power BI updates, its curriculum chock full of features and new insights for your data, your visuals, and the models you couldn't wait to share with new-found friends.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Mobile layout interactive canvas [blog]
Smart narrative improvements [blog] [article]

Modeling

Edit your data model in the Power BI service - updates [blog]
Edit linguistic relationships in Q&A setup [blog]
Updates to MINX and MAXX DAX functions [blog] [article - MINX] [article - MAXX]
Edit relationships in the Properties pane (general availability) [blog] [article]

Data connectivity

SAP HANA (updates) [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog]

Other

Upgrade Power BI Desktop .NET Framework to 4.7.2 or newer [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

August 2023 Update (2.120.731.0)

August was full of sunshine, dry grass, bored summer students and a fine collection of updates for Power BI Desktop and the Power BI service.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New switcher layout [video] [blog]
New bubble range scaling setting [video] [blog]
On-object interactions (updates) (Preview) [video] [blog]

Modeling

Updates to ORDERBY function [video] [blog]

Data connectivity

New modern data connectivity and discovery experience in dataflows [video] [blog]
Lakehouses (connector update) [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

July 2023 Update (2.119.323.0)

July brought us celebrations that look like fireworks for the Power BI Desktop and the Power BI service, enabling you to create stunning visuals and revolutionary data models in your march toward business intelligence independence.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Smoothed and leader lines (updates) [blog]
On-Object interaction (updates) [video] [blog]

Modeling

Edit your data model in the Power BI service (updates) [blog] [article]
Relationship validation [blog]

Data connectivity

Many connector updates [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [video] [blog]

Others

WebView2 - generally available [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

June 2023 Update (2.118.286.0)

This June we had a sunny collection of features and enhancement for Power BI Desktop and the Power BI service, designed to warm up your visuals and your data models.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New card visual [video] [blog]
OneLake data hub in Power BI Desktop [video] [blog]
On-Object interaction (updates) [video] [blog]

Data connectivity

Visual Cue for new tenant settings [video] [blog]
Tenant admin settings API [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

May 2023 Update (2.117.286.0)

This May we had all sorts of new features growing, blooming, and blossoming to create a fabric of amazing visuals, insights, and intelligence for Power BI Desktop and the Power BI service.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Microsoft Fabric

Power BI Direct Lake mode (preview) [video] [blog]
Azure Analysis Services to Fabric and Power BI Premium Migration Experience now generally available [video] [blog]
Optimize ribbon in Power BI Desktop now generally available [video] [blog] [article]
Hybrid tables now generally available [video] [blog] [article]
Azure Log Analytics for Power BI semantic models now generally available [video] [blog] [article]
Power BI data hub updated and rebranded as OneLake data hub [video] [blog]

Reporting

Azure maps now generally available [video] [blog]
Measure driven data labels [video] [blog]
Use OneDrive and SharePoint files in Power BI Desktop [video] [blog]
Matrix accessibility improvements [video] [blog]
On-object interaction - updates (preview) [video] [blog]
Set query limits in Power BI Desktop [video] [blog]

Modeling

New DAX function: MATCHBY [video] [blog]

Data connectivity

On-premises data gateway, May 2023 release [video] [blog]
New Get Data category: Fabric [video] [blog]
New connectors:
- Lakehouse in Microsoft Fabric [video] [blog]
- Warehouse in Microsoft Fabric [video] [blog]
- KQL database in Microsoft Fabric [video] [blog]
- MongoDB Atlas SQL [video] [blog]
- Celonis EMS [video] [blog]
- CloudBlue PSA [video] [blog]
- SolarWinds Service Desk [video] [blog]
Many updated data connectors [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

April 2023 Update (2.116.404.0)

This April we had new features and capabilities raining down on our Power BI offering, filling us with the hope of bright colors and new growth across our veritable garden of analytics.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Dynamic format strings for measures [video] [blog]
On-object interaction - updates (preview) [video] [blog]
New tooltip auto-scale (preview) [blog] [article]

Analytics

Update to Quick measures suggestions [blog] [article]

Modeling

Composite models on Power BI semantic models and Analysis Services (generally available) [blog] [release announcement] [article]
Updates to ORDERBY function [blog] [article]
New DAX functions: RANK and ROWNUMBER [blog] [article] [article]

Data connectivity

Many updated data connectors [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

Many new and updated visuals [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

March 2023 Update (2.115.663.0)

We felt lucky as a four-leaf clover to have shared our March updates to Power BI with all of you. We hope they were like a pot of gold at the end of a data-driven rainbow, full of compelling visuals and business intelligence capabilities.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Apply all slicers button, clear all slicers button, optimization presets update [video] [blog] [article]
Format pane - new styling [blog]
On-object interaction (preview) [video] [blog] [article]
Visual container improvements [blog] [article]

Data connectivity

Many updated data connectors [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

February 2023 Update (2.114.664.0)

We loved February's updates. We were happy to share them with all of you, all wrapped up in a virtual heart-shaped box of sweet features.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/#post-22137-_Toc126917169

Reporting

Conditional formatting based on string fields [video] [blog]
Smart Narrative visual summary icon [blog]
Formatting image width in table and matrix [blog]
Update your base theme in Power BI [blog]
Report theme validation on custom theme import [blog]
Text box visual indentation [blog]
New accessible report themes [blog]
Customize visible pages in the Page navigator visual [blog]
Sensitivity labels now supported in PDF export from Power BI Desktop (preview) [blog]
Enhanced row-level security editor (preview) [video] [blog]

Analytics

Quick create SDK [blog]

Modeling

New DAX functions: LINEST and LINESTX [blog]

Data connectivity

Many updated data connectors [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

December 2022 Update (2.112.283.0)

December's updates were a sleigh ride of fun, making us want to go door-to-door and sing about our new and updated features. May your data analytics always be cheery and bright.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Slicer type formatting moved to Format Pane [video] [blog]

Modeling

Making it easier to do comparison calculations [video] [blog] [article]

Data connectivity

Many updated data connectors [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

November 2022 Update (2.111.265.0)

November's updates felt like a family reunion, and we were thankful and grateful for the heaping-tall servings of updates, features, and new capabilities. Please pass the data to this end of the table.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Unshared and unsynchronized axes for small multiples charts [video] [blog]
Controlling and customizing labels on Azure Maps [video] [blog]
Create dynamic slicers using field parameters (Preview) [video] [blog]
Composite models over Power BI semantic models and Analysis Services (Preview) [video] [blog]

Modeling

Streamline your report authoring experience with Optimize ribbon (Preview) [video] [blog] [article]
New DAX function: EVALUTATEANDLOG [video] [blog] [article]
New DAX functions: TOCSV and TOJSON [video] [blog] [article 1] [article 2]

Data connectivity

Many updated data connectors [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]

Others

Power BI Desktop infrastructure update (WebView2) [video] [blog]
New Power BI color accent [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

October 2022 Update (2.110.341.0)

October's updates were scary fun, full of screaming great new features and monstrous improvements.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Reverse stack order for stacked column charts [video] [blog]
Query performance improvements [video] [blog]
Power BI Metrics [video] [blog]

Analytics

Quick measure suggestions - experimental feature (Preview) [video] [blog] [article]

Modeling

Relationship editing in the properties pane (Preview) [video] [blog] [article]
DAX formula bar support for Power BI Desktop model view [video] [blog]

Data connectivity

Introducing tenant setting for Power BI datamarts (preview) [video] [blog] [article]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]

Others

Power BI Ideas website enhancements [blog]
Update to release notes [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

September 2022 Update (2.109.642.0)

September's updates were crisp and clean, like an autumn walk down a colorful treed pathway where new discoveries are just around each corner. We were all ready to meet friendly new features, joining Power BI classmates for an exciting next round of learning.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Hierarchical axis by default [video] [blog]
Improved display name for summarized fields [video] [blog]
Conditional formatting for data labels [video] [blog]
Translations support for composite models on Power BI semantic models and Analysis Services (preview) [video] [blog] [article]
Mobile formatting options (general availability) [video] [blog] [article]
Information protection update [video] [blog] [article]

Data connectivity

Dremio (connector update) [video] [blog]
Profisee (new connector) [video] [blog]
Starburst Enterprise (connector update) [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]

Others

Paginated reports data preview [video] [blog] [article]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

August 2022 Update (2.108.564.0)

August's updates were like a summertime trip, full of interesting sights and new things to discover that brought a sense of adventure and imaginings of exciting things to come.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Conditional formatting for data labels [video] [blog]
New Select sensitivity label dialog [video] [blog] [article]
Data loss prevention policy update [video] [blog] [article]
Metric visual (preview) [video] [blog] [article]
Mobile formatting now supports text box visuals [video] [blog] [article]

Modeling

DAX Editor improvements [video] [blog]

Data connectivity

MariaDB (connector update) [video] [blog]
Google Sheets (connector update) [video] [blog]
Certified connectors availability in Power BI dataflows and datamarts [video] [blog] [article]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]

Others

Visualizing views in Dynamics 365 with Power BI (general availability) [video] [blog]
More ways to optimize Power BI performance [video] [blog] [article]
Release notes and ideas update [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

July 2022 Update (2.107.683.0)

July's updates were a sunny collection of bright spots for Power BI, warming ourselves with all the good things they brought.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Error bars (generally available) [video] [blog]
Filled Map for Azure Maps visual [video] [blog]
Composite models on Power BI semantic models and Analysis Services (preview) [video] [blog]
Bold, italics and underline for text in the header tooltip [video] [blog] [article]
Metric visuals updates [video] [blog]

Modeling

New DAX function: NETWORKDAYS [video] [blog]
Support for multi-role RLS in composite model [video] [blog]
Query performance improvement [video] [blog]

Data connectivity

Connect to datamarts (preview) [video] [blog]
Display name support in the Dataverse connector [video] [blog]
Many connector updates (update) [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New Power BI visuals' category list in AppSource [video] [blog]
New visuals in AppSource [video] [blog]
New visuals available [video] [blog]

Others

Release notes and ideas update [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

June 2022 Update (2.106.582.0)

This month's updates were raining down features, sprinkling us with all sorts of capabilities and functionality that were sure to bring sunny reports sometime soon.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New format pane (generally available) [video] [blog] [article]
Updates to error bars [video] [blog]
Information protection updates [video] [blog]
Table navigation improvements [video] [blog]
Canvas Zoom in Teams and quick create [video] [blog]

Modeling

Composite models on SQL Server Analysis Services [video] [blog]

Data connectivity

Connect to datamarts (preview) [video] [blog]
Many new data connectors [video] [blog]
Many connector updates (update) [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]
Many new visuals and updates [video] [blog]

Others

Power BI Desktop infrastructure update (WebView2) [video] [blog]
Improved support for single sign-on (SSO) for all users [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

May 2022 Update (2.105.664.0)

This month had a spring in its step, with blossoming updates and sunshine-filled features that were sure to warm up your reports and models.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New Format pane updates (preview) [video] [blog] [article]
Canvas zoom now generally available [video] [blog]
Field parameters [video] [blog] [article]
Managing composite models on Power BI semantic models [video] [blog]
Data point rectangle select now generally available [video] [blog]
Error bars for column and line combination charts (preview) [video] [blog]
ArcGIS for Power BI visual updates [video] [blog]

Data connectivity

Many new data connectors [video] [blog]
Azure Databricks (update) [video] [blog]
Denodo (update) [video] [blog]
Google Sheets (update) [video] [blog]
Autodesk Construction Cloud (update) [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Visuals

New visuals in AppSource [video] [blog]
Many new visuals and updates [video] [blog]
Charticulator now generally available [video] [blog]

Others

Power BI Desktop infrastructure update (WebView2) [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

April 2022 Update (2.104.702.0)

The Power BI team showered us with features, updates, and a collection of growing capabilities this month that customers and users were sure to enjoy.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

https://powerbi.microsoft.com/en-us/blog/19024/preview/#post-19024-_Toc100064173

Reporting

New Format pane updates (preview) [video] [blog] [article]
Tooltips now support drill actions for matrix, line and area charts (preview) [video] [blog] [article]
Updates to required permissions when using composite models on Power BI semantic models [video] [blog] [article]
Error bars for clustered column and bar charts (preview) [video] [blog]
Bookmark navigator now shows last selected bookmark per group [video] [blog] [article]

Data preparation

Dynamic M query parameters now generally available [video] [blog] [article]

Data connectivity

Autodesk Construction Cloud (new connector) [video] [blog]
Digital Construction Works Insights (update) [video] [blog]
Dremio, Dremio Cloud (update) [video] [blog]

Visuals

New visuals in AppSource [video] [blog]
Many new visuals and updates [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Others

Windows 11 support [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post.

Note

The video might use earlier versions of Power BI Desktop or the Power BI service.

March 2022 Update (2.103.661.0)

Lucky us, we had more compelling updates to Power BI in March than we could have wished for using a four-leaf clover.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New Format pane to be Generally Available in May (preview) [video] [blog] [article]
Error bars (preview) [video] [blog]
Dynamic format strings now supported for all chart elements [video] [blog]
Updates to the Azure Maps visual (preview) [video] [blog] [Geocoding article] [Pie chart article]
Sensitivity labels update [video] [blog] [article]
Multi-row card selection [video] [blog]

Data connectivity and preparation

BitSight Security Ratings (new connector) [video] [blog]
Bloomberg Enterprise Data and Analytics (update) [video] [blog]
Anaplan (update) [video] [blog]
FactSet Analytics (update) [video] [blog]
AssembleViews (update) [video] [blog]

Visuals

New visuals in AppSource [video] [blog]
Charticulator visual now certified [video] [blog]
Many new visuals and updates [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Developers

A new improved method for deploying Power BI Embedded multi-tenancy solutions in scale [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Note

This video might use earlier versions of Power BI Desktop or the Power BI service.

February 2022 Update (2.102.683.0)

We loved the features we released in February. Some were flowery, some were chocolatey, others were downright sweet in their own unique way.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New mobile formatting options (preview) [video] [blog]
Sensitivity labels downstream inheritance (generally available) [video] [blog] [article]
Default label policies in Power BI (generally available) [video] [blog] [article]
Mandatory label policy (generally available) [video] [blog] [article]
New Format Pane (preview) - on by default [video] [blog] [article]
Multi-row card selection [video] [blog]

Data preparation

Dynamic M Query Parameters now supports SQL Server and more data sources (preview) [video] [blog] [article]

Data connectivity

Amazon OpenSearch Server (new connector) [video] [blog]
OpenSearch Project (new connector) [video] [blog]
Digital Construction Works Insights (new connector) [video] [blog]
Azure Databricks (update) [video] [blog]
BQE Core (update) [video] [blog]
Microstrategy (update) [video] [blog]
Starburst Enterprise (update) [video] [blog]

Visuals

New visuals in AppSource [video] [blog]
Many new visuals and updates [video] [blog]

Other

WebView2 now required [video] [blog]
Power BI Release Plan app [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Developers

New Power BI visuals category in AppSource [video] [blog]
Expand entire level in Matrix [video] [blog]
Dynamic format string support [video] [blog]

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Note

This video might use earlier versions of Power BI Desktop or the Power BI service.

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

December 2021 Update (2.100.261.0)

This month's features were like a sleigh ride through your favorite snowy location, lighting up the season with all sorts of new things we had been wanting and asking for throughout the year.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Sparklines (preview) [video] [blog]
New Format Pane updates (preview) [video] [blog] [article]

Data connectivity

Azure Data Explorer (update) [video] [blog]
TIBCO Data Virtualization now Generally Available [video] [blog]
Many more updated connectors [video] [blog]

Visuals

New visuals in AppSource [video] [blog]
Many new visuals and updates [video] [blog]

Other

Visualize your data quickly from Power Apps and Dynamics 365 apps (Preview) [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Note

This video might use earlier versions of Power BI Desktop or the Power BI service.

November 2021 Update (2.99.563.0)

We were all thankful for the great things that Power BI served for our extended business intelligence family in November this year. Even better, there were enough features to feast on the next day, so invite your friends and even folks you don't know, sit down around this article, and share what you like best about what's on the menu.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New Format pane (preview) [video] [blog] [article]
Page and bookmark navigators [video] [blog]
Sort legend [video] [blog]
Bold, italic, underline for text formatting [video] [blog]
Text box superscript, subscript, and bulleted lists [video] [blog]
Pie and donut chart rotation [video] [blog]
Scorecard visual [video] [blog]
Update on tenant-level Bing Maps feature switch [video] [blog]

Data connectivity

Azure Synapse Analytics (new connector) (preview) [video] [blog]
Google Sheets (new connector) (preview) [video] [blog]
Azure Cosmos DB V2 (new connector) (preview) [video] [blog]
Delta Sharing (new connector) (preview) [video] [blog]
Many more updated connectors [video] [blog]

Visuals

New visuals in AppSource [video] [blog]
Find report sample files easily in AppSource [video] [blog]
Many new visuals [video] [blog]

Other

Automatic page refresh now supports DirectQuery for Power BI semantic models and Azure Analysis Services [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Note

This video might use earlier versions of Power BI Desktop or the Power BI service.

October 2021 Update (2.98.683.0)

There was a scary-good collection of features in this month's release, sure to make you want to dress up as your favorite character and go door-to-door telling your neighbors all about it - it's quite a bag of goodies.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Heat map layer - Azure Maps Visual (preview) [video] [blog] [article]
DirectQuery for Power BI semantic models and Azure Analysis Services [video] [blog] [article]
Tenant-level features switch for Bing Maps [video] [blog] [article]

Modeling

SWITCH performance optimization [video] [blog] [article]
Bitwise functions in DAX [video] [blog]

Data connectivity

Azure Cosmos DB V2 (preview) [video] [blog]
SIS-CC-SDMX (preview) [video] [blog]
Usercube (preview) [video] [blog]
Updates to many connectors [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Other

ODBC support for paginated reports (generally available) [blog] [article]
New instructor led training available for DAX in a day (Beta) [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Note

This video might use earlier versions of Power BI Desktop or the Power BI service.

September 2021 Update (2.97.725.0)

We were falling into this month's release, with crisp morning updates and new season of interesting and compelling features.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New formatting options for buttons [video] [blog] [article]
Toggle total columns in waterfall charts [video] [blog]
Padding around visual title and border [video] [blog]
Line chart series labels [video] [blog]
Sensitivity label support for Power BI template files [video] [blog] [article]

Analytics

Insights (preview) [video] [blog] [article]

Modeling

Shortcut expression for CALCULATE now supports aggregation functions [video] [blog] [article]
New parameter for XIRR function [video] [blog] [article]
Making it easier to format based on a user’s locale [video] [blog] [article]

Data connectivity

The Power BI Connector in Power Automate [video] [blog]
Updates to many connectors [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Other

New version of Power BI Report Builder [video] [blog] [article]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Note

This video might use earlier versions of Power BI Desktop or the Power BI service.

August 2021 Update (2.96.701.0)

August's release was like a warm summer day, with rays of new updates shining down on all of our Power BI enthusiasts and customers.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Customize shape formatting [video] [blog] [article]
X-axis constant line improvements [video] [blog]
Default sensitivity label policy in Power BI Desktop (preview) [video] [blog] [article]

Analytics

Sharing Q&A synonyms [video] [blog]

Modeling

New way of expressing Date and DateTime values [video] [blog]
Evaluation configuration settings [video] [blog] [article]

Data connectivity

New connector - Automy Data Analytics (Beta) [video] [blog]
Updates to many connectors [video] [blog]

Visuals

New store experience for Power BI visuals [video] [blog] [site]
New visuals from various providers [video] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

July 2021 Update (2.95.804.0)

We celebrated this month's release with fireworks, parades and a whole host of independent data connectors and visualizations.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Small multiples now generally available [video] [blog] [article]
Conditional formatting for more properties [video] [blog]
Power Automate visual now available (preview) [video] [blog]
Sensitivity labels in Power BI Desktop [video] [blog]
Republish PBIX with option to not override label in destination [video] [blog]
Inherit sensitivity label set to Excel files when importing data into Power BI [video] [blog]

Analytics

Sharing Q&A synonyms [video] [blog]

Modeling

New Model View now generally available [video] [blog]
DirectQuery for Azure Analysis Services and Power BI semantic models (preview) [video] [blog]

Data connectivity

New connectors - Amazon Athena [video] [blog]
Updates to many connectors [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Template apps

Analyze email marketing performance using Mailchimp and ActiveCampaign [blog]

Other

Power BI Desktop installer changes [article] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

June 2021 Update (2.94.781.0)

With June's release, warm and sunny updates were in the forecast for your reports.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Paginated reports visual (preview) [video] [blog] [article]
Area chart transparency sliders [video] [blog]
Inner padding for continuous axes [video] [blog]
Small multiples: responsiveness and conditional formatting (preview) [video] [blog] [article]

Analytics

Q&A improvements for inferred results [video] [blog]

Modeling

Format strings now persisted when using DirectQuery for Power BI semantic models and Azure Analysis Services (preview) [video] [article] [blog]

Data preparation

DirectQuery support for dataflows now generally available [video] [Article] [blog]
Select all operation is now supported for Dynamic M Query Parameters (preview) [video] [Article] [blog]

Data connectivity

New connectors - Assemble Views, BQE Core, SumTotal [video] [blog]
Updates to many connectors [video] [blog]
Connector deprecation - Azure Consumption Insights [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Template apps

Template app one-click update and republish [video] [blog]
Salesforce Analytics for Sales Managers [video] [blog]

Other

Power BI Desktop installer changes [article] [blog]
June update of Power BI Report Builder [article] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

May 2021 Update (2.93.384.0)

May brought an entire bouquet of blooming updates for Power BI.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Modern visual tooltips (preview) [video] [blog] [article]
Small multiples: now on by default, and updated roadmap (preview) [video] [blog] [article] [article 2]
New field list now generally available [video] [blog] [article]
Support for removing the sensitivity label in Power BI Desktop [video] [blog] [article]

Analytics

Smart Narratives and anomaly detection (preview) [video] [blog] [article]
Q&A now supports DirectQuery for Power BI semantic models and Azure Analysis Services [video] [blog]

Modeling

DirectQuery for Power BI semantic models and Azure Analysis Services (preview) [video] [article] [blog]
Model view updates [video] [blog] [article]

Data connectivity

New connector - EQuIS [video] [blog]
Updates to many connectors [video] [blog]
Connector deprecation - Microsoft Graph Security [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Template apps

Dataflows Snapshot Analysis [video] [blog]

Developers

Dialog boxes support for Power BI custom visuals [video] [blog]
Displaying a warning icon for a custom visual [video] [blog]

Other

Share and collaborate in Excel for the web connected to Power BI [video] [article] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

April 2021 Update (2.92.706.0)

Spring was in the air, and so was a great collection of updates for Power BI.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Power Automate for Power BI (preview) [video] [blog]
Small multiples: padding controls and combo chart support (preview) [video] [blog]
New and improved shapes [video] [blog]
Invert axis and continuous axis sorting [video] [blog]

Modeling

DirectQuery for Power BI semantic models and Azure Analysis Services (preview) [video] [article]) [blog]
CROSSFILTER supports many-to-many relationships [video] [blog]
Performance improvements to IF and SWITCH functions [video] [blog]

Data connectivity

New connector - Bloomberg Data and Analytics [video] [blog]
New connector - SoftOne BI [video] [blog]
Text/CSV by example now generally available [video] [blog]
Automatic table detection from Excel files now generally available [video] [blog]
Automatic table detection from JSON files now generally available [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Developers

API v3.6.0 now available [video] [blog]

Other

Simplifying collection of diagnostic information [video] [article] [blog]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

Previous releases of Power BI Desktop are not being serviced - you should always use the most recent release for the latest features and updates.
It might not be possible to open files created or saved in newer releases of Power BI Desktop with previous versions of Power BI Desktop.
If you receive a warning when loading a report saved in a newer release of Power BI Desktop, then save that report in the previous version, you lose any information related to new features.
We only archive the English versions of Power BI Desktop.

March 2021 Update (2.91.701.0)

We felt lucky like a four-leaf clover to deliver these March Power BI updates to our community.

This article describes updates to Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

The links beside each feature in the list are follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Power BI Desktop
Power BI service

Important

Power BI Desktop is no longer be supported on Windows 7. Power BI Desktop is supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

DirectQuery for Power BI semantic models and Azure Analysis Services (preview) [video] [blog] [article]
Advanced data selection in Azure Maps visual [video] [blog]
Color picker updates [blog]
Updates to the new Field List (preview) [blog]
Word wrap in Small Multiples titles (preview) [video] [blog]
Updates to background settings on Small Multiples (preview) [blog]

Analytics

X-axis constant line for line charts [video] [blog]

Modeling

Model view user interface (preview) [video] [blog]
IF.EAGER [video] [blog]
CALCULATE filters now easier to use [video] [blog]

Data connectivity

Kerberos-based SSO for Denodo [video] [blog]
Certified connectors [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Template Apps

Download PBIX files for installed template apps [video] [blog]
Analyze popular stocks with Power BI [video] [blog]
Additional template apps [video] [blog]

Other

Windows 7 deprecation [video] [blog]
Certificate revocation check controls now available in Desktop interface [video] [blog]
External Tools integration with Power BI Desktop generally available [blog] [article]
Instructor-led training for Power BI [blog]
Power BI Desktop change log [blog] [article]

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

For detailed information about each new feature, see Power BI feature summary blog post.

Power BI monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

February 2021 Update (2.90.702.0)

Our February Power BI updates were better than a heart-shaped box of chocolates.

If you're running Windows 10, you can also get Power BI Desktop from the Microsoft Store. Regardless of how you install Power BI Desktop, the monthly versions are the same, although the version numbering might differ. For more information about downloading and installing Power BI Desktop, see Get Power BI Desktop.

Important

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop will be supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

DirectQuery for Power BI semantic models and Azure Analysis Services (preview) [video] [blog] [article]
Search Bar [video] [blog] [article]
Model View Updates (preview) [video] [blog] [article]
New Field List (preview) [video] [blog]
Small Multiples (preview) - gridlines and background colors [video] [blog]
Color picker [video] [blog]
Smart guides for aligning objects - mobile layout view [video] [blog]
New filter operations - is empty, is not empty [video] [blog]
Certificate revocation check for web connections - granular control [video] [blog]

Analytics

Anomaly detection now in the ribbon [video] [blog]

Modeling

Enhanced semantic model metadata format [video] [blog]

Data connectivity

New Teams Analytics connector [video] [blog]
Snowflake - support for custom roles [video] [blog] [article]
Parquet Files - connector available in Power BI Desktop [video] [blog] [article]
Hive LLAP - support for Windows authentication [video] [blog]
Salesforce - API update [video] [blog]
SAP HANA and BW - new documentation [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Other

New icon update [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

December 2020 Update (2.88.321.0)

Our December Power BI updates dazzled us all like a snowy lane filled with lights and sleigh rides.

Power BI Desktop
Power BI service

If you're running Windows 10, you can get the most recent version of Power BI Desktop from the Windows Store. You can also get the latest version from the Download Center, as a single executable containing all supported languages that you install on your computer.

Regardless of how you install Power BI Desktop, the monthly versions are the same, although the version numbering might differ. For more information about downloading and installing Power BI Desktop, see Get Power BI Desktop.

Important

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

Reporting

DirectQuery for Power BI semantic models and Azure Analysis Services (preview) [video] [blog] [article]
Small multiples (preview) [video] [blog]
Data protection sensitivity labels in Power BI Desktop (preview) [video] [blog]
Increased rectangle select data point limit [video] [blog]
Selection pane now available in mobile layout view [video] [blog]
Automatic page refresh for Analysis Services sources [video] [blog]

Data preparation

Changes to Power Query and dataflows [video] [blog]

Data connectivity

Microsoft Dataverse connector [video] [blog]
Azure Time Series Insights update [video] [blog]
SurveyMonkey update [video] [blog]
Cognite update [video] [blog]

Visuals

New visuals from various providers [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

November 2020 Update (2.87.261.0)

Our November Power BI updates included an entire family gathering of new and improved features; they were a feast of goodness.

The monthly blog and video updates for Power BI Desktop now also includes what's new updates for Power BI mobile and the Power BI service. In this section choose the tab for Power BI Desktop or the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

Power BI Desktop
Power BI service

Important

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop will be supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

New Field List (preview) [video] [blog]
New Model View (preview) [video] [blog] [article]
Apply all filters now generally available [video] [blog] [article]
Visual zoom slider [video] [blog] [article]
Data point rectangle select extended to Map visual [video] [blog] [article]
Certificate revocation check for web connections [video] [blog] [article]
Paginated reports updates [video] [blog] [article]

Analytics

Anomaly detection (preview) [video] [blog]
Q&A now supports partial matching data values [video] [blog] [article]

Data connectivity

Hive LLAP connector now generally available [video] [blog]
New data connectors - Actian, Anaplan, Starburst Presto [video] [blog]

Visuals

New visuals from various providers [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

October 2020 Update (2.86.321.0)

Our October Power BI updates are a bucket full of spooky-good treats that you can sort and enjoy for weeks to come.

The monthly blog and video updates for Power BI Desktop now also includes what's new updates for Power BI mobile and the Power BI service. This article discusses the updates for Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

Important

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop will be supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Canvas watermarks [video] [blog]
Personalize visuals is now generally available [video] [blog] [article]
Data point rectangle select for Treemap (preview) [video] [blog] [article]

Analytics

Export data from Q&A visual [video] [blog]

Modeling

Performance improvements to IF and SWITCH functions [blog]

Data preparation

Dynamic M Query Parameters (preview) [video] [blog] [article]
Automatic Table Detection from Excel files [video] [blog]
Automatic Table Detection from JSON files [video] [blog]

Data connectivity

Broader geographical support for Power Platform Dataflows connector [video] [blog]
MariaDB now supports DirectQuery [video] [blog]
Updated SharePoint Online List connector [video] [blog]
New data connectors - Spigit and eWay-CRM [video] [blog]

Visuals

Extended administrator capability features now generally available [video] [blog]
New visuals from various providers [video] [blog]

Template Apps

Simplified installation for template apps [video] [blog]
Find template apps from Power BI Desktop [video] [blog]

Other

Export data source to PBIDS in Power BI Desktop [video] [blog] [article]
Icon update for Power BI [video] [blog]
Power BI Desktop splash screen dismiss [video] [blog]

For detailed information about each of these features, see Power BI Desktop feature summary blog post.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

September 2020 Update (2.85.284.0)

Our September Power BI Desktop updates are cool and crisp, like the coming of fall and the turning of leaves.

Also new this month, the monthly blog and video updates for Power BI Desktop now also includes what's new updates for Power BI mobile and the Power BI service. This article discusses the updates for Power BI Desktop and the Power BI service. To learn about updates for mobile, check out What's new in the mobile apps for Power BI.

Important

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI monthly update video.

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop will be supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Analytics

Smart narratives (preview) [video] [blog]
Q&A now supports arithmetic operations [video] [blog]

Reporting

Data point rectangle select for additional charts [video] [blog]
Added general visual option to maintain layer order [video] [blog]
Search for a workspace during publish [video] [blog]
Total labels for stacked visuals [video] [blog]
Mobile authoring enhancements [video] [blog]

Modeling

Enhanced semantic model Metadata is now generally available [video] [blog]
Performance improvements to aggregation expressions involving columns of currency data type [video] [blog]

Data connectivity

Azure Databricks [video] [blog]
MariaDB [video] [blog]
Hexagon PPM Smart API [video] [blog]
Other data connectivity updates [video] [blog]

Visuals

New visuals from various providers [video] [blog]

Template apps

Multichannel attribution dashboard [video] [blog]
Workspace analytics dashboard [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

August 2020 Update (2.84.461.0)

Our August Power BI Desktop updates were full of compelling new features and capabilities.

Important

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI Desktop monthly update video.

Important

Power BI Desktop is no longer supported on Windows 7. Power BI Desktop will be supported on Windows 8 or newer versions of Windows, for the most recent release of Power BI Desktop only.

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

Reporting

Perspectives support for Personalize visuals (preview) [video] [blog]
Rectangular lasso select for data points (preview) [video] [blog]
Added dynamic formatting support to more visuals [video] [blog]

Analytics

DirectQuery support for Q&A [video] [blog]

Visuals

Multiple new visuals from various companies [video] [blog]
ArcGIS Maps updates [video] [blog]
Extending admin capabilities for AppSource visuals [video] [blog]

Template apps

Agile CRM Analytics for Dynamics 365 [video] [blog]

Data preparation

Text/CSF by Example (preview) [video] [blog]

Data connectivity

Cherwell connector [video] [blog]
Automation Anywhere connector [video] [blog]
Acterys connector [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

July 2020 Update (2.83.5894.661)

Our July Power BI Desktop updates were a celebration of new features and capabilities worthy of fireworks, sunny picnics and community barbecues.

Important

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI Desktop monthly update video.

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

Reporting

Gradient layout [video] [blog]
Ability to further customize slicer header text [video] [blog]
Relative time filter is now generally available [video] [blog]

Analytics

Enhancements to Q&A [video] [blog]

Visuals

Azure Maps visual (preview) [video] [blog]
Updates to Multi-Axis chart by XViz [video] [blog]

Modeling

Support for Excel financial functions [video] [blog]
Model view enabled for live connect is now generally available [video] [blog]

Data preparation

Global option to disable automatic type detection [video] [blog]

Template apps

YouTube Analytics by MAQ Software [video] [blog]

Other features

Launch external tools from Power BI Desktop (preview) [video] [article] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

June 2020 Update (2.82.5858.301)

Our June Power BI Desktop felt like a fresh new beginning filled with new capabilities, generally available features, and many opportunities to get out into your world of data and interact.

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI Desktop monthly update video.

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

Reporting

Enhancements to mobile layout authoring [video] [blog]
Automatic page refresh now generally available [video] [article] [blog]
Hierarchical slicer now generally available [video] [article] [blog]
Modern ribbon now generally available [video] [article] [blog]
RLS now supported for Featured Tables in Excel's Data Types gallery [video] [article] [blog]

Analytics

AI insights now generally available [video] [article] [blog]

Visuals

Line chart dot formatting options [video] [blog]
Many new visuals from multiple vendors [video] [blog]

Template apps

Agile HR Analytics [video] [blog]
Uber User Data Report [video] [blog]

Modeling

Model view enabled for live connect (preview) [video] [blog]
Updates to Model view [video] [blog]

Data connectivity

Palantir Foundry connector [video] [article] [blog]

Other features

New Power BI trainings [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

May 2020 Update (2.81.5831.621)

We hope our May Power BI Desktop brought you new insights, new capabilities, and a healthy dose of positive outlook for our global community.

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI Desktop monthly update video.

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

Reporting

Curate featured tables for Excel (preview) [video] [blog]
Apply all filters (preview) [video] [blog]
Enhancements to change detection (preview) [video] [blog]
Drillthrough button action is now generally available [video] [article] [blog]
Enhancements to page navigation action [video] [blog]
Buttons now support fill images [video] [blog]
Drop shadow support for visuals [video] [blog]
Filter pane migration [video] [blog]

Analytics

Decomposition tree now generally available [video] [blog]

Visuals

New Power BI visuals [video] [blog]
Power Apps visual now compatible with all supported languages [video] [blog]

Modeling

List separator and decimal symbol now default to standard DAX separators [video] [blog]

Data preparation

DirectQuery on Dataflows [video] [article] [blog]
Web by example now automatically suggests tables by default [video] [blog]
Enhancements to Query Diagnostics: Privacy Level partitions [video] [blog]

Data connectivity

Many new data connectors [video] [article] [blog]

Other features

Semantic model impact analysis [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

April 2020 Update (2.80.5803.282)

We were grateful to be able to share our April Power BI update with you, our global community.

Power BI Desktop
Power BI service

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI Desktop monthly update video.

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

Reporting

Personalize visuals (preview) [video] [blog]
Change detection for page refresh (preview) [video] [blog]
Relative time filter (preview) [video] [blog]
Rectangular lasso select across visuals [video] [blog]
Conditional formatting for totals and subtotals in table and matrix [video] [article] [blog]
Customize theme dialog is now generally available [video] [article] [blog]
Improved discoverability for conditional formatting [video] [blog]

Analytics

DirectQuery support for AI visuals [video] [blog]
Decomposition tree now supports tooltips [video] [blog]
Q&A updates [video] [blog]

Visuals

New visualization icons [video] [blog]
New Power BI visuals [video] [blog]

Template apps

Power Platform Center of Excellence StartKit [video] [blog]
Azure Cognitive Search: analyze logs and metrics [video] [blog]
COVID-19 apps [video] [blog]

Data preparation

Enhancements to Query diagnostics [video] [blog]

Data connectivity

CDM Folder view for Azure Data Lake Storage Gen2 [video] [blog]

Other features

New instructor-led training [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

March 2020 Update (2.79.5768.562)

We felt lucky as a four-leaf clover to share our March Power BI update with you.

Power BI Desktop
Power BI service

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

You can also watch the entire Power BI Desktop monthly update video.

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

Reporting

New action types for buttons [video] [blog]
Multi-column sort for tables [video] [blog]
Dual axis for line chart [video] [blog]
Filter pane search [video] [blog]
Updates to decomposition tree visual [video] [article] [blog]
New ribbon is now on by default [video] [article] [blog]

Modeling

New DAX function: COALESCE [video] [article] [blog]

Visuals

Updates to ArcGIS Maps [video] [blog]
New Power BI visuals [video] [blog]

Template apps

Azure DevOps dashboard by Data Maru [video] [blog]
TeamsPower by Encamina [video] [blog]

Data preparation

Query diagnostics now generally available [video] [blog]

Data connectivity

Hive LLAP connector (preview) [video] [blog]
Cognite connector (preview) [video] [blog]

Other features

Enhanced semantic model metadata (preview) [video] [article] [blog]
Using default system credentials for web proxy [video] [blog]
New instructor-led administrator in a day training [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

February 2020 Update (2.78.5740.642)

We loved our February updates, and felt our new features were better than a heart-shaped box of chocolates.

Power BI Desktop
Power BI service

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

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

Data management

Incremental refresh is now generally available [video] [article] [blog]

Reporting

Hierarchical slicer (preview) [video] [blog]
Updates to the new ribbon (preview) [video] [article] [blog]

Modeling

New DAX functions: FirstNonBlankValue, LastNonBlankValue [video] [article] [blog]

Visuals

New custom visuals [video] [blog]

Template apps

Microsoft 365 usage analytics [video] [blog]
NFL analytics by P3 [video] [blog]
Acterys for Quickbooks, Zero and WorkflowMax [video] [blog]

Data preparation

Query diagnostics - support for users who aren't administrators [video] [blog]

Data connectivity

MicroStrategy connector (generally availability) [video] [blog]
FHIR connector (generally availability) [video] [blog]
Additional connectors: Factset, TIBCO, Jamf Pro, Asana [video] [blog]

For detailed information about each of these new features, see Power BI Desktop feature summary blog post.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

December 2019 Update (2.76.5678.661)

Our December updates were as fun as a bobsled ride down a snow-covered hill.

Power BI Desktop
Power BI service

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

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

Reporting

Theming updates (preview) [video] [article] [blog]
Export the current theme (preview) [video] [article] [blog]
Setting table column or matrix value as a custom URL [video] [blog]
KPI visual formatting settings [video] [blog]
New decomposition tree formatting [video] [blog]
Filter pane toggle button in the new ribbon [video] [blog]
Automatic page refresh query details [video] [blog]

Analytics

Load more for Analyze insights [video] [blog]
New DAX function: Quarter [video] [blog]

Visuals

Personalizing the Visuals pane (generally availability) [video] [blog]
New Power BI visuals [video] [blog]

Data connectivity

Azure Data Lake Storage Gen2 connector (generally availability) [video] [blog]
Power Platform Dataflows connector (generally availability) [video] [article] [blog]
PostgreSQL connector now includes the Npgsql provider [video] [blog]
AtScale connector (general availability) [video] [blog]
Azure Time Series Insights connector [video] [blog]
Data Virtuality connector [video] [blog]
Zucchetti HR Infinity connector [video] [blog]

Data preparation

Updates to AI Insights functions (preview) [video] [article] [blog]

Template apps

Omnichannel insights for Dynamics 365 [video] [blog]
Customer service analytics for Dynamics 365 [video] [blog]
Microsoft Forms Pro for Customer Services [video] [blog]

For detailed information about each of these new features, see Power BI Desktop December 2019 feature summary.

Check out what's new in the mobile apps for Power BI.

Note

See the data sources available to Power BI Desktop. Our list is always growing, so check back often.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

November 2019 Update (2.75.5649.341)

Our November updates were as welcome as a happy family gathering.

Power BI Desktop
Power BI service

Important

Power BI Desktop is released only as a single .exe file, which contains all supported languages. The .msi version is no longer being released.

The links beside each feature in the Power BI Desktop update list are interpreted as follows:

[blog]: Most features are explained in a section in the monthly update blog post.
[video]: Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
[article]: Some features have an article that provides more detail.
The remaining features are self-explanatory and don't need an article or video.

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

User experience

Updated ribbon (preview) [video] [article] [blog]

Reporting

Decomposition tree visual (preview) [video] [blog]

Analytics

Conditionally format button formatting [video] [blog]

Visuals

ArcGIS Maps for Power BI update [video] [blog]
New xViz visuals [video] [blog]
ZoomCharts Drill-Down Waterfall visual [video] [blog]
Financial Reporting Matrix by Profitbase [video] [blog]
Distribution [video] [blog]
Tree [video] [blog]

Data connectivity

LinkedIn Sales Navigator connector [video] [article] [blog]
Edit SAP variables experience (general availability) [video] [article] [blog]
Product Insights connector [video] [blog]

Data transformation

AI functions in Power Query (preview) [video] [article] [blog]
Web by Example connector - support for extracting links [video] [blog]

Template apps

LinkedIn Sales Navigator for Sales Operations [video] [article] [blog]

For detailed information about each of these new features, see Power BI Desktop November 2019 feature summary.

Check out what's new in the mobile apps for Power BI.

Power BI Desktop monthly update video

The following video describes each of these updates. You can also watch this video from the blog post:

October 2019 Update (2.74.5619.621)

Our October updates were as fun as a pumpkin patch run, and more exciting than a midnight tour through a haunted mansion.

Power BI Desktop
Power BI service

You can now download the latest version of Power BI Desktop, now delivered as a single .exe file that contains all supported languages. If you're running Windows 10, you can also get Power BI Desktop from the Windows Store. The monthly versions are the same even though the version numbering might differ between the two, regardless of which way you install Power BI Desktop. See this article for more information.

Important

Power BI Desktop is only released as a single .exe file that contains all supported languages. The .msi version is no longer being released.

The links beside each update mean the following:

[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:

Reporting

Automatic page refresh for DirectQuery [video] [article] [blog]

Analytics

The new Q&A visual [video] [blog]
Improved user experience for Q&A [video] [blog]
- Improved drop-down control
- Red and blue underlines
- Improved visual results
Natural language improvements for Q&A [video] [blog]
- Integration with Office / Bing thesaurus
- Support for measure tables, and better handling of table names and ambiguity
Q&A tooling (preview) [video] [blog]
- Review questions
- Teach Q&A
- Review all changes made
Support for SSAS and Azure AS, including RLS [video] [blog]

Visuals

PowerApps visual now included by default [video] [blog]
New xViz visuals [video] [blog]

Data connectivity

Sagra Emigo connector generally available [video] [blog]
Azure cost Management connector updated [video] [article] [blog]
New Workplace Analytics connector [video] [blog]

Data preparation

Query diagnostics [video] [blog]
Data profiling enhancements [video] [blog]

Template apps

Project Web App [video] [blog]

Other

New file format: .PBIDS [video] [article] [blog]
Performance improvements for modeling operations [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.

September 2019 Update (2.73.5586.561)

Our September updates were like an exciting return to school - new things to learn, updates to friends we missed over the summer, and opportunities to apply what we know into better future reports.

Power BI Desktop
Power BI service

Important

Power BI Desktop is only released as a single .exe file that contains all supported languages. The .msi version is no longer being released.

The links beside each update mean the following:

[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:

Reporting

Color and text classes in themes [video] [article] [blog]
New default themes [video] [blog]
Personalized visualization pane improvements (preview) [video] [blog]

Analytics

Custom format strings [video] [blog]
Conditional formatting for more visual formatting options [video] [blog]
Drillthrough discoverability improvement [video] [blog]
New DAX expressions: REMOVEFILTERS and CONVERT [video] [blog]

Visuals

PowerApps visual now generally available [video] [blog]

Data connectivity

PostgreSQL connector enhancements [video] [blog]

Data preparation

Copy to clipboard from data profiling [video] [blog]

Template apps

Google Analytics report [blog]

Other

Performance improvements for multi-dimensional models [video] [blog]
Query performance improvements for DirectQuery models [video] [blog] https://youtu.be/neq0THnRJzo?t=1208

Note

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

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

August 2019 Update (2.72.5556.801)

Our August updates were hot and shone brightly on the reports you create in Power BI.

Power BI Desktop
Power BI service

The links beside each update mean the following:

[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 were new to Power BI Desktop this month:

Reporting

Grouping visuals [video] [article] [blog]
Filter pane migration [video] [blog]
Icon style picker for conditional formatting of icons [video] [blog]
Conditional formatting warnings [video] [blog]

Analytics

Key influencers visual improvements, general availability [video] [blog]

Visuals

New Power BI visuals and updates [video] [blog]

Data connectivity

Support for SAP HANA HDI Containers [video] [blog]
Edit SAP variables in the Power BI service (preview) [video] [blog]
PostgreSQL DirectQuery [video] [blog]
MarkLogic connector now generally available [video] [blog]
New Power Platform category within Get Data [video] [blog]

Template apps

Facebook Pages - basic analytics [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.

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

July 2019 Update (2.71.5523.641)

Our July updates were skyrocketing with colorful bursts of new features and functionality for your Power BI.

Power BI Desktop
Power BI service

You can now download the latest version of Power BI Desktop. If you're running Windows 10, you can also get Power BI Desktop from the Windows Store. The monthly versions are the same even though the version numbering might differ between the two, regardless of which way you install Power BI Desktop. See this article for more information.

The links beside each update mean the following:

[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 were new to Power BI Desktop this month:

Reporting

Icon sets for table and matrix [video] [blog]
Percent support for conditional formatting by rules [video] [blog]
New filter pane is now generally available [video] [blog]
Data colors support when using play axis on scatter charts [video] [blog]
Performance improvements when using relative date and dropdown slicers [video] [blog]

Analytics

Counts for Key influencers visual (preview) [video] [blog]
Aggregations improvements [video] [blog]

Visuals

PowerApps visual is now certified [video] [blog]
Three new Power BI visuals and updates [video] [blog]

Data connectivity

Azure Data Lake Storage Gen2 connector (beta) [video] [blog]
Dynamics 365 Customer Insights connector [video] [blog]

Data preparation

New transform: Split column by positions [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.

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

June 2019 Update (2.70.5494.561)

Our June updates spread sunshine and blue skies on your reports, with a refreshing and bright new color scheme for your Power BI, and a host of other improvements.

Power BI Desktop
Power BI service

The links beside each update mean the following:

[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 were new to Power BI Desktop this month:

Reporting

Updated pane design [video] [blog]
Visual level filters for slicers [video] [blog]
Sorting for the performance analyzer pane [video] [blog]
Conditional formatting updates for formatting options [video] [blog]
Visual header tooltips [video] [blog]
Table and matrix total label customization [video] [blog]
Sync slicer support for hierarchy slicer [video] [blog]
Consistent font sizes across visuals [video] [blog]

Analytics

Key influencers visual updates (preview) [video] [blog]
- Key influencers with Live connect to Power BI semantic models
- Key influencers accessibility
- Support for Cloud RLS
Manage aggregations dialog accessibility [video] [blog]

Modeling

New == DAX comparison operator [video] [blog]

Visuals

Personalized visualization pane (preview) [video] [blog]
Three new Power BI visuals and updates [video] [blog]

Data connectivity

Connect to shared and certified semantic models [video] [blog]
Common Data Service connector is now generally available [video] [blog]
Azure Data Explorer connector is now generally available [video] [blog]
Enhancements to the Cosmos DB connector [video] [blog]
Entersoft data connector [video] [blog]

Data preparation

Improvements to M Intellisense [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.

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

May 2019 Update (2.69.5467.1251)

Our May updates bloomed in your garden of great reports, with compelling new features and a flower pot full of colorful, beautiful visuals.

Power BI Desktop
Power BI service

The links beside each update mean the following:

[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 were new to Power BI Desktop this month:

Reporting

Performance Analyzer pane [video] [article] [blog]
Filter pane improvements (preview) [video] [blog]
Table and matrix keyboard navigation [video] [blog]
Line data label position control [video] [blog]
KPI visual indicator text size control [video] [blog]

Analytics

Key influencers visual improvements (preview) [video] [blog]
- Binning support
- Formatting options
- Mobile support

Modeling

Disable auto-date tables for new reports [video] [blog]
Update to the ALLSELECTED DAX function [video] [blog]

Visuals

ArcGIS maps for Power BI updates [video] [blog]
Six new Power BI visuals and updates [video] [blog]

Data connectivity

Essbase connector - support for Native Query (MDX) [video] [blog]
Intune Data Warehouse connector [video] [blog]
Tenforce connector [video] [blog]
Roamler connector [video] [blog]

Other

Automatic query cancellation for Power BI Desktop [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.

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

April 2019 Update (2.68.5432.361)

Our April updates were packed full of updates that put spring in your step on rainy days.

Power BI Desktop
Power BI service

The links beside each update mean the following:

[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 were new to Power BI Desktop this month:

Reporting

Filter pane improvements [video] [article] [blog]
Conditional formatting for visual titles [video] [article] [blog]
Conditional formatting for web URL actions for buttons, shapes and images [video] [blog]

Analytics

Drill through across reports [video] [article] [blog]
Key Influencers visual now supports continuous analysis for numeric targets [video] [blog]
Python support not generally available [video] [blog]
Partial synonym matching for terms in Q&A [video] [blog]

Modeling

New DAX function - ALLCROSSFILTERED [video] [blog]

Power BI visuals

One new custom visual [blog]

Data connectivity

Power BI dataflows connector now generally available [video] [blog]
Oracle Essbase connector now supports DirectQuery, and is generally available [video] [blog]
PDF connector now generally available [video] [blog]
Web By Example connector - automatic table inference [video] [blog]
Intersystems IRIS connector [video] [blog]
Indexima connector [video] [blog]
Luminis InformationGrid connector [video] [blog]
Solver BI360 connector [video] [blog]
Paxata connector [video] [blog]

Data preparation

Data Profiling enhancements and general availability [video] [blog]
Fuzzy merge performance enhancements and general availability [video] [blog]
M Intellisense supported in formula bar and custom column dialog, and is generally available [video] [blog]

Other

Power BI Report Builder [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.

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

March 2019 Update (2.67.5404.581)

Our March updates were packed full of compelling and useful updates, and we hope these improvements make you feel as lucky as finding a four-leaf clover.

Power BI Desktop
Power BI service

The links beside each update mean the following:

[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 were new to Power BI Desktop in March:

Reporting

Single select slicer [video] [blog]
Heat map support for Bing maps [video] [blog]
Cross-highlight by axis labels [video] [blog]
Default tooltip formatting [video] [blog]
Static web URL support for buttons, shapes and images [video] [blog]
Filter pane improvements [video] [blog]
Page alignment options [video] [blog]
Selection pane improvements [video] [blog]
Formatting updates for maps [video] [blog]
Accessible visual interaction [video] [blog]

Analytics

Q&A recommendations for improving results [video] [blog]
Show dates as a hierarchy now generally available [video] [blog]

Modeling

New modeling view now generally available [video] [blog]
New DAX functions [video] [blog]

Power BI visuals

New certified Power BI visuals setting in the admin portal [video] [blog]
Two new Power BI visuals [video] [blog]

Data connectivity

PDF connector now supports tables spanning multiple pages (preview) [video] [blog]
Intelligent Plant's Industrial App Store connector [video] [blog]
Azure Cost Management connector [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.

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

February 2019 Update (2.66.5376.1681)

Our February updates made customers swoon and love all our new data connectors, features, and analytics enhancements. Just like a box of chocolates, you never know what you get... but with this February update, all changes were sweet and downright delicious.

Power BI Desktop
Power BI service

You can download the latest version of Power BI Desktop. If you're running Windows 10, you can also get Power BI Desktop from the Windows Store. The monthly versions are the same even though the version numbering might differ between the two, regardless of which way you install Power BI Desktop. See this article for more information.

The links beside each update mean the following:

[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:

Reporting

Updates to the new filter pane (preview) [video] [blog]
Cross-highlight on a single point in line charts [video] [blog]
Word wrap on titles [video] [blog]
Update default visual interaction to cross-filter [video] [blog]
Rounded corners for visual borders [video] [blog]

Analytics

Key influencers visual (preview) [video] [blog]
Insights questions in Q&A [video] [blog]
Auto-generated suggested questions for Q&A explorer [video] [blog]
Improved Python & R script editor [video] [blog]

Power BI visuals

Ten new Power BI visuals, new Power BI visuals feature [video] [blog]

Data connectivity

Microsoft Graph Security [video] [blog]
Guidanz' BI Connector for OBIEE [video] [blog]
MarkLogic [video] [blog]
Kronos Workforce Dimensions [video] [blog]
SurveyMonkey [video] [blog]
Qubole Presto [video] [blog]
Quick Base [video] [blog]
Sagra Emigo [video] [blog]

Other

Improved Live connect and DirectQuery error messages [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.

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

There was no Power BI Desktop release in January 2019 - we were all busy having a happy holiday, spending time with friends and family.

December 2018 Update (2.65.5313.621)

Our December updates made sugar plums dance in our customers' heads, or at least created compelling data-driven visuals of said sugar plums.

The links beside each update mean the following:

[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 an 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:

Reporting

Smart guides for aligning objects on a page [video] [article] [blog]
ArcGIS Maps for Power BI updates [video] [article] [blog]
Fields list accessibility support [video] [article] [blog]
Set tab order for objects on a page [video] [article] [blog]
Tooltips for button visuals [video] [article] [blog]
Updated icons for Visual interactions [video] [article] [blog]

Analytics

Live connect support for Q&A (preview) [video] [blog]

Modeling

DAX formula bar updates [video] [article] [blog]
Data view accessibility support [video] [article] [blog]

Power BI visuals

One new custom visual [video] [blog]

Data connectivity

AtScale connector (Beta) [video] [blog]
Oracle Essbase connector (Beta) [video] [article] [blog]

Data preparation

Fuzzy merge - support for Top N best matches [video] [blog]

Other

High contrast support for all panes and report footer [video] [article] [blog]
Updated keyboard shortcut dialog [video] [article] [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.

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

Note

You might also be interested in learning what's new in the mobile apps for Power BI.

November 2018 Update (2.64.5285.582)

Our November updates were a bountiful harvest of new features and functionality. So you could sit down with your family of data and analytics enthusiasts, pass the potatoes, and dig in to our feast of updates.

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

Reporting

Expand and collapse matrix row headers [video] [article] [blog]
Copy and paste between Desktop files [video] [article] [blog]
Updated filtering experience (preview) [video] [article] [blog]
Report accessibility improvements [video] [article] [blog]

Analytics

Color saturation on visuals upgraded to use conditional formatting [video] [blog]
Follow up questions in the Q&A explorer [video] [blog]

Modeling

New modeling view (preview) [video] [article] [blog]
Composite models now generally available [video] [article] [blog]
Modeling accessibility improvements [video] [article] [blog]
New DAX functions [video] [blog]

Power BI visuals

Five new Power BI visuals [video] [blog]

Data connectivity

Azure Developer Operations Server connector [video] [blog]
PDF Connector support for Start Page and End Page parameters [video] [article] [blog]
Improved Azure Consumption Insights connector [video] [article] [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.

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

Note

You might also be interested in learning what's new in the mobile apps for Power BI.

October 2018 Update (2.63.3272.40262)

Our October updates were spooky-good, frighteningly helpful, and sweeter than an orange bucket full of candy.

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

Reporting

Search in filter cards [video] [article] [blog]
Accessibility improvements for authoring experiences [video] [article] [blog]
Performance improvements for ArcGIS Map [video] [blog]

Modeling

DAX editor improvements [video] [article] [blog]

Analytics

Composite models and aggregation support in the Power BI service (preview) [video] [article - aggregations] [article - composite models] [blog]
Explain the increase for non-additive measures [video] [blog]

Power BI visuals

Five new Power BI visuals [video] [blog]

Data connectivity

Web by Example connector now generally available [video] [article] [blog]
SAP BW connector implementation v2 now generally available [video] [article] [blog]
SAP BW Message Server Connector now generally available [video] [blog]
Vertica connector now generally available [video] [blog]
Dynamics NAV and Dynamics 365 business Central connectors now generally available [video] [blog]
New Dynamics 365 business Central On-premises connector [video] [blog]

Data preparation

Data Profiling in Power Query Editor (preview) [video] [blog]
Fuzzy Matching options for Merge Queries (preview) [video] [blog]

Other areas

Control export data options for reports [video] [blog]
Transport layer security settings [video] [article] [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.

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

Note

You might also be interested in learning what's new in the mobile apps for Power BI.

September 2018 Update (2.62.5222.582)

Our September updates were like settling in to an exciting new classroom. Hopefully you found these updates as useful as a handful of just-sharpened No. 2 pencils.

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

Reporting

Dot plot layout support in scatter charts [video] [article] [blog]
Copy value and selection from table and matrix visuals [video] [blog]
Built-in report theme options [video] [article] [blog]
Report page tooltips generally available, new Card support [video] [article] [blog]
Accessibility improvements for analytics and formatting pane support [video] [blog]

Analytics

Aggregations (preview) [video] [article] [blog]

Power BI visuals

Five new Power BI visuals [video] [blog]

Data connectivity

PDF file connector (preview) [video] [article] [blog]
SAP BW connector - support for measure properties [video] [blog]
Dataflows connector (beta) [article] [blog]

Data preparation

M Intellisense [video] [blog]
Add column from examples - support for text padding [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.

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 mobile apps for Power BI.

August 2018 Update (2.61.5192.321)

Our August updates were august in their own right, and followed quickly on the heels of July's big releases. Hopefully you found these updates like a sunny day on the beach; dip your toes in, we think you'll find these updates feel just right.

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

Modeling

Data categories for measures [video] [article] [blog]
Statistical DAX functions [video] [blog]

Reporting

Export to PDF, and print your reports [video] [article] [blog]
Create bookmark groups [video] [article] [blog]
Theming is generally available [video] [article] [blog]
Slicer restatement [video] [blog]

Analytics

Conditional formatting by values [video] [article] [blog]
Python integration [video] [blog]
Q&A improvements [video] [blog]

Power BI visuals

Five new Power BI visuals [video] [blog]

Data connectivity

Spark connector generally available [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.

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 mobile apps for Power BI.

July 2018 Update (2.60.5169.3201)

July's big updates were worthy of a fireworks show in their own right, with long-requested data and reporting features that launch your visuals sky-high, and burst with arcing displays of colorful insights.

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

Modeling

Composite models (Preview) [video] [article] [blog]
Many-to-many relationships (Preview) (associated with composite models) [video] [article] [blog]
Storage mode (Preview) (associated with composite models) [video] [article] [blog]

Reporting

New visual header with more flexibility and formatting [video] [article] [blog]
Wallpaper formatting [video] [article] [blog]
Theming update - more visual and page control (Preview) [video] [blog]
Tooltips for table and matrix [video] [blog]
Turn tooltips off for visuals [video] [blog]
Slicer accessibility [video] [blog]
Formatting pane improvements [video] [blog]
Stepped line support for line and combo charts [video] [blog]
Turn off combo chart data labels for individual series [video] [blog]
Sorting experience improvement [video] [blog]

Analytics

Distribution factor insights [video] [blog]

Power BI visuals

Power BI certified category [video] [blog]
Disabling specific organizational visuals [video] [blog]
Four new Power BI visuals [video] [blog]

Data connectivity

IBM DB2 DirectQuery connector (Preview) [video] [blog]
Improvements to Web By Example connector [video] [article] [blog]
SAP HANA - default values for variables in Variable Input experience [video] [article] [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.

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 mobile apps for Power BI.

June 2018 Update (2.59.5135.101)

The sun was shining on June's updates, with features and improvements that warmed up your reports and let you bask in the insights they provided.

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

Reporting

High contrast support for reports [video] [article] [blog]
Donut radius control [video] [blog]
Pie and donut detail labels position control [video] [blog]
Format data labels separately for each measure in a combo chart [video] [blog]
Longer phone reports [video] [blog]

Power BI visuals

Two new Power BI visuals [video] [blog]

Modeling

Filtering and sorting in data view [video] [article] [blog]
Improved locale filtering [video] [blog]

Data connectivity

SAP BusinessWarehouse connector improvements (new driver and improved performance, plus improved support for hierarchy variables) [video] [article] [blog]
Spark connector now supports Windows Authentication [video] [blog]
OData V4 connector enhancements [video] [blog]
ODBC connector improvements (folding support for Top Rows, ability to filter navigation by DSN catalog) [video] [blog]

Other

National/Regional cloud selector [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.

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 mobile apps for Power BI.

May 2018 Update (2.58.5103.281)

May's updates were a blooming collection of features and improvements that we hope spread sunshine on your reports, and made them blossom with beautiful insights.

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

Reporting

Conditional formatting by a different field [video] [blog]
Advanced slicer syncing [video] [blog]
Log axis improvements [video] [blog]
Data label options for funnel chart [video] [blog]
Set line stroke width to zero [video] [blog]

Analytics

Measure drillthrough [video] [article] [blog]

Power BI Premium

Incremental refresh (preview) [video] [article] [blog]

Power BI visuals

Many new Power BI visuals [video] [blog]

Data connectivity

New From Web connector - by example data extraction (preview) [video] [article] [blog]
Common Data Service for Apps connector (beta) [video] [blog]
Azure KustoDB connector (beta) [video] [blog]
Google BigQuery and Azure HDInsight Spark connectors now generally available [video] [blog]
Adobe Analytics connector update - support for multiple domain logins (preview) [video] [blog]
Visual Studio Team Services connector update - analytics views support [video] [blog]
OLE DB connector update - support for alternate Windows credentials [video] [blog]
SAP BW DirectQuery connector update - improved technical name support [video] [blog]

Data preparation

Improvements to Add Column from Examples [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.

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 mobile apps for Power BI.

April 2018 Update (2.57.5068.501)

We're not fooling about how happy we were with April's updates to Power BI Desktop. We showered the updates across a handful of areas, and hope they help you grow your future reports with amazing, beautiful visuals.

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

Reporting

Q&A Explorer [video] [blog]
Buttons to trigger actions [video] [article] [blog]
Combo chart line styles [video] [blog]
Improved default sort for visuals [video] [blog]
Numeric slicer now generally available [video] [blog]

Analytics

Update your linguistic schema [video] [article] [blog]
New DAX function: COMBINEVALUES() [video] [blog]

Power BI visuals

Organizational visuals now generally available [video] [article] [blog]
Many new Power BI visuals [video] [blog]

Data connectivity

Adobe Analytics connector now generally available [video] [article] [blog]
SAP HANA connector improvement: Port selection [video] [article] [blog]
Dynamics 365 Business Central connector [video] [article] [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.

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 mobile apps for Power BI.

March 2018 Update ()

We were feeling lucky as a four-leaf clover about March's updates to Power BI Desktop. The following updates were new to Power BI Desktop in March:

Reporting

Report page tooltips [video] [blog]
Bookmarking is now generally available [video] [article] [blog]
Display units and precision control for Table and Matrix columns [video] [article] [blog]
Turn off the visual header in Reading mode for a report [video] [blog]
Improved default visual placement [video] [blog]

Power BI visuals

Many new Power BI visuals [video] [article] [blog]

Data connectivity

Visual Studio Team Services connector improvements [video] [article] [blog]
SAP HANA connector enhancements [video] [article] [blog]
- DirectQuery multidimensional support is now generally available
- SSL certificate validation support
SAP BW DirectQuery now generally available [video] [article] [blog]
Azure Analysis Services connector now generally available [video] [article] [blog]

Other

Improved error reporting [video] [article] [blog]
View previous errors you've encountered [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.

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 mobile apps for Power BI.

February 2018 Update (2.55.5010.521)

Our hearts were full of love for the updates to Power BI Desktop in February, and we hope you found them just as sweet as a box of chocolates.

The links beside each update mean the following:

[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 for this month 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 were new to Power BI Desktop in February 2018:

Reporting

Multi-select data points across multiple pages [video] [article] [blog]
Sync slicers across multiple pages of a report [video] [article] [blog]
Numeric range slicer improvement - whole number snapping (Preview) [video] [article] [blog]
Faster geocoding for Bing maps (web Preview) - up to 6x faster [video] [blog]
Overflow data labels for bar and column charts visuals [video] [blog]
Search the Formatting and Analytics panes [video] [article] [blog]

Power BI visuals

Organization Power BI visuals (Preview) [video] [article] [blog]

Analytics

Set a custom date table [video] [article] [blog]
Quick measures are now generally available [video] [article] [blog]

Data connectivity

Improvements to DirectQuery over SAP HANA (Preview) [video] [article] [blog]

Other

DirectQuery performance improvements [video] [article] [blog]
Open and save performance improvements [video] [blog]
Show items with no data improvements [video] [blog]
Persistent filters control for upcoming Power BI service feature [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.

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 mobile apps for Power BI.

January 2018 Update (2.54.4970.761)

We rang in the new year with a collection of updates to Power BI Desktop, and our new year's resolution is to keep them coming.

The links beside each update mean the following:

[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 for this month 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 were new to Power BI Desktop in January:

Reporting

Show and hide pages [video] [blog]
Control data label background color for Cartesian and maps visuals [video] [blog]
Increase the area used for axis labels in charts [video] [blog]
Bar / column padding control [video] [blog]
Show dates as a hierarchy (preview) [video] [blog]
Add an anchor date for a relative date slicer [video] [blog]
Top N selection in Q&A [blog]
Many new Power BI visuals [video] [blog]

Analytics

Correlation coefficient quick measure [blog]

Data connectivity

Support for Microsoft Entra authentication for Azure SQL Database and Data Warehouse connectors [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.

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 mobile apps for Power BI.

December 2017 Update (2.53.4954.481)

December brought a Ho-Ho-Whole lot of updates to Power BI Desktop, chock full of features gifts for all business intelligence minded kids (and adults) to enjoy.

The links beside each update mean the following:

[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 were new to Power BI Desktop in December:

Reporting

Q&A for report creation [video] [blog]
Cross-highlighting for bookmarks [video] [blog]
More bookmark flexibility [video] [blog]
Field properties pane and field descriptions[video] [blog]
Scatter visual from x- and y-axis groupings [video] [blog]
High density sampling for maps based on latitude and longitude [video] [blog]
Responsive slicers [video] [blog]
Recently released Power BI visuals [video] [blog]

Analytics

Drill filters other visuals [video] [blog]

Data connectivity

Adobe Analytics connector [video] [blog]
HDInsight Interactive Query connector [video] [blog]
Data.World connector [video] [blog]
SAP BW connector improvements [video] [blog]
IBM Netezza connector now generally available [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.

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 mobile apps for Power BI.

November 2017 Update (2.52.4921.202)

November brought a whole harvest worth of updates to Power BI Desktop.

The links beside each update mean the following:

[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 were new to Power BI Desktop in November:

Reporting

Rule-based conditional formatting for Table and Matrix visuals [video] [blog]
Cell alignment for Table and Matrix visuals [video] [blog]
Control visual ordering through the selection pane [video] [blog]
Lock objects on your report [video] [blog]
Esri Plus Subscription is available for ArcGIS Maps for Power BI [video] [blog]
Report options for slow data sources [video] [blog]
Filtering performance improvements [video] [blog]
Recently released Power BI visuals [video] [blog]

Analytics

Cell-level formatting for multidimensional AS models for multi-row card [video] [blog]

Data connectivity

Impala connector - support for Windows Authentication [video] [blog]

Other

Query editing - Add Column from Example improvements [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.

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 mobile apps for Power BI.

October 2017 Update (2.51.4885.543)

October brought a frighteningly compelling group of useful updates to Power BI Desktop.

The links beside each update mean the following:

[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:

Reporting:

Bookmarking (preview) [video] [blog] [article]
Selection pane and visual display controls [video] [blog] [article]
Bookmark links for shapes and images [video] [blog] [article]
Spotlight [video] [blog] [article]
Scatter and Bubble markers [video] [blog] [article]
Increase the number of data points displayed in Scatter visuals [video] [blog]

Analytics:

Quick measures for SSAS live connections [video] [blog] [article]
Sales from new customers quick measure [video] [blog] [article]
Cell-level formatting for multi-dimensional Analysis Services (AS) models [video] [blog]

Data Connectivity:

Vertica connector (beta) [video] [blog] [article]
SAP BW connector - support for additional member properties [video] [blog]

Other:

Get Power BI Desktop from the Windows Store [video] [blog] [article]
Improved access to help content [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.

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 mobile apps for Power BI.

September 2017 Update (2.50.4859.502)

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

Report View:

Drill through to another report page [video] [blog] [article]
Ribbon chart [video] [blog] [article]
Insights about Explain the increase / Explain the decrease [video] [blog] [article]
Theming preview update - chart style controls [video] [blog] [article]
Accessibility improvements [video] [blog] [article]
- Accessible See data [video] [blog] [article]
- Keyboard shortcut helper dialog [video] [blog] [article]
High density scatter chart sampling [video] [blog] [article]
Gridline style control [video] [blog] [article]
New Power BI visuals [video] [blog]
- Calendar by Tallan [video] [blog]
- Enlighten Aquarium [video] [blog]
- Visio visual (preview) [video] [blog]
- Impact bubble chart [video] [blog]

Data Connectivity:

Azure Consumption Insights connector [video] [blog] [article]
Improvements to the Dynamics 365 for Financials connector [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.

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 mobile apps for Power BI.

August 2017 Update (2.49.4831.222)

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

Report View:

Show values on rows for matrix [video] [blog]
Color scales on font colors for table and matrix [video] [blog]
Custom subtotal settings per level of matrix [video] [blog]
Line styles and legend options [video] [blog]
Scatter chart performance improvements [video] [blog]
New Power BI visuals [video] [blog]
- Dot Plot by MAQ Software [video] [blog]
- Power KPI [video] [blog]
- Funnel plot [video] [blog]
- Beyondsoft Calendar [video] [blog]

Analytics & Modeling:

What if parameters [video] [blog]
New scatter chart analytics features [video] [blog]
- Symmetry shading [video] [blog]
- Ratio lines [video] [blog]
New quick measure: weighted average [video] [blog]

Data Connectivity:

Live connect to the Power BI service is generally available [video] [blog]
Google BigQuery connector (beta) [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.

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 mobile apps for Power BI.

July 2017 Update (2.48.4792.321)

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

Report View:

New table & matrix visuals are now generally available [video] [blog]
Renaming fields in visuals [video] [blog]
Power BI visuals store integration [video] [blog]
Relative date filters [video] [blog]
Responsive layout for visuals (preview) [video] [blog]
New waterfall chart option - breakdown [video] [blog]
Custom visual updates [video] [blog]
- Drill-down Choropleth [video] [blog]
- Drill-down Cartogram [video] [blog]
- Drill-down Player [video] [blog]
- Certified Power BI visuals [blog]

Analytics & Modeling:

Quick measures from the community [video] [blog]
- Star rating [video] [blog]
- Concatenated list of values [video] [blog]
Bidirectional cross filtering for DirectQuery is now generally available [video] [blog]

Data Connectivity:

Snowflake connector general availability [video] [blog]

Query Editing:

Add Column from Examples enhancements [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.

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 mobile apps for Power BI.

June 2017 Update (2.47.4766.542)

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

Report View:

Data bars for new table and matrix visuals (Preview) [video] [blog]
Markers on line, area, and combo visuals (Preview) [video] [blog]
Visual font family setting [video] [blog]
Horizontal image slicer [video] [blog]
Combo chart formatting updates [video] [blog]
Bing maps improvements [video] [article] [blog]
High density line sampling [video] [article] [blog]
Accessible reports [video] [article] [blog]

Data Connectivity:

Custom Data Connectors support [video] [blog]
Power BI service Live Connect to on-premises and push streaming semantic models [video] [blog]
Impala connector is now generally available [video] [blog]
Amazon Redshift connector is now generally available [video] [blog]
SAP BW connector - DirectQuery support [video] [blog]
IBM Netezza connector (beta) [video] [blog]

Query Editing:

Add Column from Examples enhancements [video] [article] [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.

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 mobile apps for Power BI.

May 2017 Update (2.46.4732.461)

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

Report View:

Relative date slicer (Preview) [video] [blog]
New table visual (Preview) [video] [blog]
Combo chart data label enhancements [video] [blog]
More URL support in table and matrix visuals [video] [blog]
mailto links in textbox [video] [blog]

Analytics:

Report level measures for live connections to Analysis Services tabular models and Power BI service semantic models [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:
- Dynamics 365 for Customer Insights [video] [blog]

Query Editing:

Two new transforms:
- Extract text before/after/between delimiters [video] [blog]
- Unpivot only selected columns [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.

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 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:

Rename axis titles [video] [blog]
New matrix visual enhancements: column sorting, column resizing, and word wrap (Preview) [video] [article] [blog]

Analytics:

Quick measures [video] [blog] [in-depth blog] [article]
Show value as [video] [blog]
Q&A in Spanish (Preview) [video] [blog]

Data Connectivity:

Connect to semantic models 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:

Add Column from Example [video] [article] [blog] [another blog]
Split column (by delimiter/number of characters) into rows [video] [blog]
Group by: basic mode [video] [blog]
Go to column [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.

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 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:

New matrix visual (Preview) [video] [article] [blog]
Numeric range slicer (Preview) [video] [article] [blog]
Data labels on pie and donut visuals - percent of total [video] [blog]
Cross-highlight using multiple series [video] [blog]
Textbox - ability to choose font color [video] [blog]
Report theming (Preview) [video] [article] [blog]

Analytics:

Clustering - now generally available [video] [blog]

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.

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 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:

Word wrap on matrix row headers [video] [blog]
X- and Y-axis font size control [video] [blog]
Cartesian chart minimum category width [video] [blog]
Line chart line thickness and join type controls [video] [blog]

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.

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 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:

Table and matrix conditional formatting improvement - blank formatting [video] [blog]
New aggregations for string and dateTime columns [video] [blog]
Table header word wrap [video] [blog]
General Availability (GA) of Phone reports [video] [blog]

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.

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 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:

Hierarchical axis [video] [blog]
Axis label and title color control [video] [blog]
Matrix conditional formatting [video] [blog]
Table and matrix column formatting [video] [blog]
Drop-down slicer [video] [blog]
Mobile reports scrolling [video] [blog]

Analytics

Clustering (preview) [video] [blog]
Forecasting (now in the Power BI service) [blog]
Groups (now on the ribbon) [video] [blog]

Data Connectors:

New data connectors [video]:
- Spark DirectQuery [video] [blog]
- OData connector improvements [video] [blog]
- Enhanced combine binaries experience [video] [blog]
- Azure Analysis Services [video] [blog]

Query Editing improvements

Improved function authoring experience [video] [blog]
Support for percentage data type [video] [blog]
Added Maximize and Restore buttons in Navigator and Query Dependencies [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.

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 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:

Improved date axis range formatting [video]
Date slicer [blog] [video]
Report gridlines and snap to grid (Preview) [article] [blog] [video]
Data label improvements [blog] [video]
Map formatting options [blog] [video]
Improved date axis range formatting [blog]

Analytics

Grouping [blog] [video]
Binning [blog] [video]
Top-N filter [blog] [video]
Include/exclude data points [blog] [video]
R-powered Power BI visuals[blog]

Data Connectors:

New data connectors [video]:
- Microsoft Dynamics 365 for Financials (Beta) [blog]
- OLE DB [blog]
- Mixpanel [blog]

Query Editing improvements

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

Other improvements

Diagnostics information in the About dialog [blog] [video]

Note

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

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 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:

ArcGIS Maps for Power BI (Preview) [blog] [video]
Mobile report layout (Preview) [blog] [video]
Updated drill behavior [article] [blog] [video]

Analytics

Forecasting (Preview) [article] [blog] [video]
Use your own R IDE [blog] [video]

Data Connectors:

New data connectors:
- Snowflake connector DirectQuery support [blog]
- ProjectPlace connector [article] [blog]
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]
Key boarding - support for smart typing in drop-down menus [blog]

Other improvements

In-product links to the Power BI Community [blog] [video]

Note

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

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 mobile apps for Power BI.

August 2016 Update (2.38.4491.282)

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:

Drill down (or back up) on line charts [blog] [video]
Continuous axis for the Date axis [blog] [video]
General availability of Inline Hierarchies [article] [blog] [video]
Predefined matrix styles (similar to table formatting in Excel) [blog] [video]
Reorder fields, in charts and tooltips [blog] [video]
Color formatting for KPI visuals [blog] [video]

Analytics (New!)

The all-new Analytics pane [article] [blog] [video]
Dynamic reference lines [blog] [video]

Data Connectors:

New data connectors:
- Snowflake connector (Preview) [blog]
Improvements to existing connectors:
- Impala connector - DirectQuery support [article] [blog]
- Web connector - Web page previews [blog] [video]
- General availability for the SAP Business Warehouse connector [article] [blog]

Query Editor improvements:

Option to Merge/Append as New Query [blog] [video]

Other improvements

Auto-recover Desktop files [blog] [video]

Note

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

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 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:

Predefined table styles [blog] [video]
Shape Maps update - use custom maps [article] [blog] [video]

Data Connectors:

New data connectors:
- Amazon Redshift [article] [blog]
- Impala [article] [blog]
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 referenced 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 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:

New visual - Shape Maps [video] [article]
Searchable slicers [video] [blog]
Configurable line chart labels [video] [blog]
New sign-in entry points [video] [blog]

Data Access:

Row Level Security [blog] [article]

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 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:

Customizable tooltips [video] [article]
Conditional formatting in tables [video] [article]
Publish to Pyramid server [blog]
Scrolling loads more data in charts [video] [blog]
Keyboard nudging for visuals [blog]

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 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:

Modeling 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 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 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
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 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 lay out 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:

SSAS Multidimensional support
SAP Hana
R Script
DirectQuery for SQL Server, Azure SQL Database and Azure Synapse Analytics (formerly SQL Data Warehouse)
Azure Data Lake
Marketo

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 items (Data Model, Queries, Power View) into a new Power BI Desktop file
HDInsight Spark connector
Azure Synapse Analytics (formerly 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 semantic models 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 - Key boarding 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!