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

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.

September 2024 Update (2.136.1202.0)

We fell into our September updates with a lot of anticipation, as days got shorter, and the dark mode of fall became part of our daily routine.

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

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:

General

• Dark mode now available in Power BI Desktop [blog] [video] [article]

Copilot and AI

• Default full report summaries and answers in the Copilot pane [blog] [video]

Reporting

• Updated menu bar in the Power BI service view mode [blog] [video]
• Visual calculations update (preview) [blog] [video] [article]
• Visual level format strings (preview) [blog] [video] [article]
• Power BI in Teams - now supporting multifactor authentication [blog] [video]
• Multiple org apps per workspace, custom colors (preview) [blog] [article]
• Subscribe to reports on the last day of the month [blog]

Note

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

Modeling

• Introducing Fabric Metrics Layer (preview) [blog] [video]
• Live edit of semantic models in Direct Lake mode with Power BI Desktop (preview) [blog] [video] [article]
• Q&A now supports semantic models with OLS [blog]

Visuals

• Many new and updated visuals [blog]

Data connectivity

• Connected tables in Excel now available in semi-annual [blog] [article]

Other

• General availability of Get data experience in Power BI Report Builder [blog] [video] [article]

Power BI service

The following updates are new to the Power BI service this month:

There were no updates for the Power BI service this month.

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:

• September 2024 version of Power BI Desktop - 32-bit
• September 2024 version of Power BI Desktop - 64-bit

August 2024 Update (2.132.908.0)

Our August updates got us back into school mode with a collection of new features, a great video that showed how many of the compelling updates can sharpen your business intelligence pencils, and set you up for great grades in creating insights and actionable business intelligence.

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

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:

Copilot and AI

• Ask Copilot questions against your semantic model (Preview) [blog] [video] [article]

Reporting

• Visual level format strings (Preview) [blog] [video] [article]
• Dynamic per-recipient subscriptions (general availability) [blog] [video] [article]
• Deliver subscriptions to OneDrive and SharePoint (general availability) [blog] [video] [article]
• Updated Save and Upload to OneDrive flow in Power BI [blog] [video]
• Data limit [blog] [article]
• Visuals, shapes and line enhancements [blog]

Note

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

Modeling

• DAX Query View in the web [blog] [video] [article]

Visuals

• Many new and updated visuals [blog]

Other

• Paginated Reports - Sharing of reports connecting to Get Data data sources made easy [blog] [article]

Power BI service

The following updates are new to the Power BI service this month:

There were no updates for the Power BI service this month.

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:

• August 2024 version of Power BI Desktop - 32-bit
• August 2024 version of Power BI Desktop - 64-bit

July 2024 Update (2.131.901.0)

July let you declare independence from waiting on others to create compelling reports and visuals, enabling you to launch your own spectacular display of sizzling analytics and insights.

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

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

• Customize your reference layers in the Azure Maps visual [blog] [video] [article]

Note

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

Modeling

• General availability of enhanced row-level security editor in Power BI Desktop [blog] [video] [article]
• DAX Query View available in live connect [blog] [video] [article]
• Add or update multiple measures in DAX Query View [blog] [video]

Data connectivity

• Certified connector updates [blog] [article]

Visuals

• Many new and updated visuals [blog] [video]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint - new export to PowerPoint dialog [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 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:

• July 2024 version of Power BI Desktop - 32-bit
• July 2024 version of Power BI Desktop - 64-bit

June 2024 Update (2.130.754.0)

June's updates were a sunny collection of capabilities that let you chart a course to the best business intelligence insights using 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

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]
• Power BI Home in Power BI Desktop now generally available [blog] [video] [article]

Note

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

Modeling

• Download large semantic models [blog] [video] [article]
• New INFO functions [blog] [video]

Visuals

• Many new and updated visuals [blog] [video]

Power BI service

No updates for the Power BI service were provided this month.

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:

• June 2024 version of Power BI Desktop - 32-bit
• June 2024 version of Power BI Desktop - 64-bit

May 2024 Update (2.129.905.0)

May brought a colorful bouquet 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

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

• Modern Tooltip now on by default [blog] [video] [article]
• Matrix layouts [blog] [video]
• Line updates [blog] [video]
• On-object interactions updates [blog] [video] [article]
• Publish to folders (Preview) [blog] [video]
• You can now ask Copilot questions about data in your model (Preview) [blog] [video]

Note

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

Modeling

• DAX Query View now generally available [blog] [video] [article]
• Copilot to write and explain DAX queries in DAX Query View updates (Preview) [blog] [video] [article]
• New Manage relationships dialog [blog] [video] [article]
• Refreshing calculated columns and calculated tables referencing DirectQuery sources with single sign-on [blog] [video]
• Model explorer and authoring calculation groups in Power BI Desktop now generally available [blog] [video] [article]

Data connectivity

• Microsoft Entra ID SSO support for Oracle database [blog] [video] [article]
• Certified connector updates [blog] [video]
• View reports in OneDrive and SharePoint with live connected semantic models [blog] [video]

Visuals

• Many new and updated visuals [blog] [video]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint - Image mode in the Power BI add-in for PowerPoint [video] [blog] [video] [article]
• Storytelling in PowerPoint - data updated notification [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.

April 2024 Update (2.128.751.0)

We were showering our users and customers with a refreshing collection of updates, capabilities, and features for the Power BI service and Power BI Desktop in April.

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

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

• New visual - 100% stacked area chart [blog]
• Line enhancements [blog]
• Enhance Q&A with Copilot-generated linguistic relationships [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] [video]

Other

• Introducing Copilot pane in Power BI Desktop [blog] [video]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint - improved image mode in the Power BI add-in for PowerPoint [video] [blog] [video] [article]
• Storytelling in PowerPoint - continuous slide show auto refresh [video] [blog] [article]
• Storytelling in PowerPoint - automatically populating the slide title [video] [blog] [article]
• Fabric metadata scanning sample app [blog] [article]
• Dynamic subscriptions for Power BI and paginated reports [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 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.

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

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]

Power BI service

The following updates are new to the Power BI service this month:

• Edit your data model in the Power BI service - updates [video] [blog] [video] [article]
• Undo/redo, clear all, and new filter cards in Explore [blog]
• Deliver report subscriptions to OneDrive SharePoint [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 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.

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

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 (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]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint - replace report URLs with shareable links in Power BI add-in [video] [blog] [video] [article]
• Data overview in Explore [blog] [video]
• DirectQuery connections update [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 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.

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint - suggested content [video] [blog] [video] [article]
• Search and sort in paginated reports [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.

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Explore (preview) [video] [blog]
• Copilot for Power BI in Microsoft Fabric (preview) [blog] [article]
• OneLake integration for Import-mode semantic models (preview) [blog]
• RLS/OLS security and stored credentials for Direct Lake semantic models (preview) [blog] [article]
• Stored credentials for Direct Lake semantic model [blog]
• Sharable cloud connections for semantic models (generally available) [blog]
• Semantic model scale-out (generally available) [blog] [article]
• Show visuals as tables (preview) [blog] [article]
• Advanced filtering for paginated reports [blog] [article]

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.

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• OneLake data hub (updates) [video] [blog]
• Deployment pipelines (updates) [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.

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Row-level security test as role improvements [blog] [article]

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• XMLA write support for Direct Lake semantic models [video] [blog]
• Automatic replica synchronization for semantic model scale-out [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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Semantic model details page revamp [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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint [video] [blog]
• Edit your data model in the Power BI service (updates) [video] [blog] [article]
• New admin setting to control email subscriptions [video] [blog] [article]
• Admin monitoring [video] [blog]
• Power BI implementation planning guidance [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.

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

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:

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]

Power BI service

The following updates are new to the Power BI service this month:

• Data loss prevention (DLP) policies now generally available [video] [blog]
• Classify and protect your Power BI data [video] [blog]
• Detect sensitive information using custom keywords [video] [blog]
• Complex conditions in DLP for Power BI [video] [blog]
• DLP policies in sovereign clouds [video] [blog]
• Edit your data model in the Power BI service (opt-in) [video] [blog] [article]
• Renaming of the Power BI Free user license [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 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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• New features to Deployment Pipeline [video] [blog] [article]
• Storytelling in PowerPoint - new style option [video] [blog]
• Visualizing views in Power Apps with Power BI quick report enabled by default [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.

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Storytelling in PowerPoint (general availability) [video] [blog]
• Power BI org app multiple audiences (general availability) [video] [blog]
• New Scanner API scenarios [blog]
• Email subscriptions [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.

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

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:

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]

Power BI service

The following updates are new to the Power BI service this month:

• New Get Data experience in the Power BI service [video] [blog]
• Compact view [blog]
• Linked metrics [blog]
• Follow metric [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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Power BI org app Multiple Audiences now generally available [video] [blog] [article]
• Deprecation of Getting Started in expanded view [blog]
• Changes to the Get Data experience [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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• New way to upload Power BI and Excel files [video] [blog] [article]
• Subscribe to a report with filters applied [video] [blog]
• Linked metrics [video] [blog]
• Information protection update [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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Guest users can now create their own email subscriptions [video] [blog] [article]
• Downloading a PBIX now available for more scenarios [video] [blog] [article]
• Administration and governance [video] [blog]
• Deployment pipelines updates [video] [blog] [article]

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Cross-tenant semantic model sharing [video] [blog]
• Auto-generate reports on existing semantic models [video] [blog]
• Discoverability feature for B2B content [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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• No Power BI service updates this month, stay tuned for next months' updates!

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Data hub improvements - data preview and export [video] [blog] [article]

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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Power BI data storytelling [video] [blog]
• Announcing the Data hub [video] [blog] [
• Power BI metrics 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

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

• 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]

Power BI service

The following updates are new to the Power BI service this month:

• Managing Power BI subscriptions gets easier [video] [blog]
• Semantic model hub improvements [video] [blog] [
• Deprecation of a Featured Dashboard as your default landing page [video] [blog]
• Deprecation of the Dashboard Performance Inspector [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

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:

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.

Power BI service

The following updates are new to the Power BI service this month:

• Power BI Goals updates [video] [blog] [article]

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Semantic models hub improvements [video] [blog] [article]
• Power BI Goals enhancements [video] [blog] [article]
• Quickly create reports from SharePoint document libraries [video] [blog] [article]
• Changing the default Power BI Home layout [video] [blog] [article]

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Power BI Goals enhancements [video] [blog] [article]
• Deployment pipelines enhancements [video] [blog] [article]
• Download .pbix improvements [video] [blog]

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.

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.

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Admin and governance - email subscriptions access using Admin API [video] [blog]
• Allow sharing links to include your changes to the report [video] [blog]
• Hybrid Tables in Power BI Premium (Preview) [video] [blog]
• Deployment pipelines - assign a workspace to all pipeline stages [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.

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Admin and governance - semantic models hub improvements [video] [blog]
• Admin and governance - Power BI Goals [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

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Power BI Premium is now generally available [video] [blog] [article]
• APIs to determine who has access to what Power BI items (preview) [video] [blog]
• Deployment pipeline APIs now generally available [video] [blog] [article]
• Upcoming automatic installation of the Power BI app for Microsoft Teams [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

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

Get started with metrics in Power BI (preview)

• Power BI Goals: automated status rules (preview) [video] [blog] [article]
• Power BI Goals: improved filtering (preview) [video] [blog] [article]
• APIs to determine who has access to what Power BI items (preview) [video] [blog]
• Service Principal support for read-only Admin APIs (general availability) [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

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Sensitivity labels for paginated reports (preview) [video] [blog] [article]
• Use automatic aggregations to enhance performance of DirectQuery semantic models [video] [blog]
• Power BI REST API support for DAX queries (preview) [video] [blog]
• Detailed historical activity information for Premium semantic models (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:

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Streaming dataflows (preview) [video] [blog] [article]
• Mandatory label policy (preview) [video] [blog]
• Sensitivity labels for Paginated reports (preview) [video] [blog]
• Custom help link for sensitivity labels [video] [blog]
• Semantic models hub improvements [video] [blog]
• Goals support in lineage view [blog]
• Scanner API (Admin REST APIs) enhanced to include new capabilities [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:

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Semantic models discoverability [video] [blog]
• Request access to semantic models [video] [blog]
• Mandatory label policy for sensitivity labels from Microsoft Purview Information Protection (preview) [video] [blog]
• Admin API to Set and Remove sensitivity labels from Microsoft Purview Information Protection [video] [blog]
• Automate deployments with new APIs and PowerShell samples (preview) [video] [blog]
• Manage dataflows in deployment pipelines (preview) [video] [blog]
• Admin APIs for deployment pipelines [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:

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Quickly create reports from SharePoint lists (Preview) [video] [blog]
• Reports, apps and dataflows endorsement is generally available [video] [blog]
• Semantic models hub improvements [video] [blog]
• Quick edit Paginated Reports from the Power BI service [video] [blog]
• Single sign-on enabled for new on-premises data sources for Paginated Reports [blog]
• Downstream inheritance for sensitivity labels (Preview) [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:

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.

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Easy report sharing using links [video] [blog]
• Improving the Create on top of published semantic model experience [video] [blog]
• New capabilities in Deployment Pipelines [video] [blog]
• Enhancements to Sensitivity Labels:
  • Sensitivity labels in Power BI embedded now generally available [video] [blog]
  • Securing the full data journey from Azure to Office (preview) [video] [blog]
  • Admin API to set and remove labels in Power BI [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:

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.

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

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 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.

Power BI service

The following updates are new to the Power BI service this month:

• Featured content on Home Updates [video] [blog]
• View semantic model details from workspace list view [video] [blog]
• Filter apps gallery to view only endorsed apps [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:

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

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.

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

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

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.

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:

Power BI service

• Power BI search in Microsoft Search in Bing and Office now generally available
• Home List experience
• Custom publish message
• New export settings are available in the Power BI admin portal
• Power BI Premium per user public preview now available
• Quickly create reports in the Service (coming soon)

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

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.

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:

Power BI service

• Certified and Promoted reports and apps
• The ‘new look’ of the Power BI service is live

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.

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.

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.

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.

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.

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.

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.

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.

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.

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 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.

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

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

Power BI service

Here were the updates in the Power BI service.

• Public preview of the 'new look' of workspaces in the Power BI service.
• General availability of designing custom navigation for Power BI apps.

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

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

Power BI service

Here were the updates in the Power BI service.

• Export reports to PDF, PPTX and PNG files using Power BI REST APIs.
• New and revamped global search experience in the Power BI service.
• Performance improvements to Multi-Geo Premium capacities.
• Public preview of read/write XMLA endpoints in Power BI Premium.

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

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:

Power BI service

Here were the updates in the Power BI service.

• Ability to promote dashboards, reports, and apps on Power BI Home.
• New Power BI tab to embed reports in Microsoft Teams.
• General availability of incremental refresh with support for Power BI Pro users.
• Email subscriptions support for external email addresses.
• General availability of Bring Your Own Key (BYOK) for Power BI Premium.
• New and improved usage metrics for the Power BI workspaces experience.

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

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:

Power BI service

Here was the update in the Power BI service.

• New activity log API that enables Power BI service admins to track user and admin activities within their tenant.

November 2019 Update (2.75.5649.341)

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

Power BI Desktop

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:

Power BI service

Here were the updates in the Power BI service.

• Public preview of large models in Power BI Premium.
• Public preview of using Microsoft cloud app security controls in Power BI.

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

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.

Power BI service

Here were the updates in the Power BI service.

• New Power Automate action to refresh Power BI semantic models.
• Contact list for reports and dashboards in the Power BI service.
• General availability of Automated Machine Learning
• Public preview of Power BI data lineage view.

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

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

• 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.

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.

Power BI service

Here was the update in the Power BI service.

• Updates to connection configuration for template apps.

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

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.

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.

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.

Power BI service

Here were the updates in the Power BI service.

• New capacity settings for Power BI Premium.
• Custom branding for your organization.
• Summarized data export with build permission.
• Support for URL parameters for paginated reports.
• Support for monthly e-mail subscriptions.

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

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.

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.

Power BI service

Here were the updates in the Power BI service.

• Support for non-premium semantic models for paginated reports.
• General availability of Power BI aggregations.
• Send refresh notifications to others.
• Testing tool for Power BI Premium capacities.
• Public preview of service availability notifications.
• Public preview of the New Look for Power BI reports.
• New Power BI region in South Africa.

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

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

• 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.

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.

Power BI service

Here were the updates in the Power BI service.

• Public preview of Shared and Certified semantic models.
• AI metrics available in the Microsoft Fabric Capacity Metrics app.
• General availability of Power BI template apps.
• General availability of paginated reports in Power BI.
• Public preview of Bring Your Own Key (BYOK) for Power BI Premium.
• Viewer role for the new workspaces experience.

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

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

• 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.

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.

Power BI service

Here were the updates in the Power BI service.

• Custom navigation for Power BI Apps.
• Additional attachments types (PPTX, XLSX, DOCX, CSV, XML) available for e-mail subscriptions within paginated reports.
• Commenting for Power BI reports in the service.

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

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

• 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.

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 channel describes and shows each of these updates. You can also see the videos from the blog post.

Power BI service

Here were the updates in the Power BI service.

• General availability of Power BI dataflows.
• General availability of the new workspaces experience.
• New Power BI regions in France and Korea.
• Updated Q&A experience for dashboards.
• Support for Azure Analysis Services within paginated reports.
• Paginated reports supported in Power BI Apps.
• E-mail subscriptions with PDF attachments for paginated reports.
• Power BI Premium summary and workload metrics supported in Admin Portal
• Query caching available in Power BI Premium.
• General availability of Power BI Home.

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

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 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.

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 channel describes and shows each of these updates. You can also see the videos from the blog post.

Power BI service

Here were the updates in the Power BI service.

• General Availability of Multi-Geo for Power BI Premium.
• Editing and managing Power BI content support for Azure B2B.
• Public preview of read-only XMLA endpoint.

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

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.

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 channel describes and shows each of these updates. You can also see the videos from the blog post.

Power BI service

Here were the updates in the Power BI service.

• Workloads and active semantic model size metrics in Capacity Monitoring app.
• Export to PDF for Power BI reports.
• On-demand e-mail subscriptions.
• Bulk operations in the Admin Portal.
• Filtered export for PPT and PDF.
• Help and support settings in the Admin Portal.
• Data lineage experience for dataflows.
• Certified Power BI visuals setting in the Admin Portal.

January 2019 Update

Power BI Desktop

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

Power BI service

Here were the updates in the Power BI service.

• Embedding secure Power BI reports in internal portals or websites.
• Updates to dataflows editor with new connectors, and support for native SQL queries and Power Query Online transformations.
• Personal bookmarks in the Power BI service.
• Time-based scheduling with e-mail subscriptions.

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.

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 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.

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 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.

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 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.

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 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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

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

Note

You might also be interested in learning what's new in the 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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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 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.

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.

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!