What's new in Microsoft Power BI Desktop 2.128.751.0
Apr 25, 2024
- Reporting:
- New visual - 100% stacked area chart [blog]
- Line enhancements [blog]
- Enhance Q&A with Copilot-generated linguistic relationships [blog]
- Visuals:
- Many new and updated visuals [blog] [video]
- Other:
- Introducing Copilot pane in Power BI Desktop
New in Microsoft Power BI Desktop 2.127.1080.0 (Apr 8, 2024)
- 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]
- 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]
New in Microsoft Power BI Desktop 2.126.927.0 (Feb 21, 2024)
- The following updates are new to Power BI Desktop this month:
- Reporting:
- Visual calculations (preview)
- Dynamic subscriptions for Power BI reports (preview)
- On-object interaction updates
- Power BI Home in Power BI Desktop is enabled by default (preview)
- Enhanced reference layer in Power BI Azure Maps visual
- Modeling:
- Measure descriptions with Copilot (preview)
- DAX query view improvements (preview)
- Visuals:
- Many new and updated visuals
- Other:
- Protected PBIX in Power BI Desktop
New in Microsoft Power BI Desktop 2.124.581.0 (Dec 12, 2023)
- 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]
New in Microsoft Power BI Desktop 2.120.731.0 (Sep 12, 2023)
- Reporting:
- New switcher layout
- New bubble range scaling setting
- On-object interactions (updates)
- Modeling:
- Updates to ORDERBY function
- Data connectivity:
- New modern data connectivity and discovery experience in dataflows [video] [blog]
- Lakehouses (connector update)
- Visuals:
- Many new and updated visuals
New in Microsoft Power BI Desktop 2.119.986.0 (Jul 27, 2023)
- Reporting:
- Smoothed and leader lines
- On-Object interaction
- Modeling:
- Edit your data model in the Power BI service
- Relationship validation
- Data connectivity:
- Many connector updates
- Visuals:
- Many new and updated visuals
New in Microsoft Power BI Desktop 2.118.286.0 (Jul 11, 2023)
- Reporting:
- New card visual
- OneLake data hub in Power BI Desktop
- On-Object interaction (updates)
- Data connectivity:
- Visual Cue for new tenant settings
- Tenant admin settings API
New in Microsoft Power BI Desktop 2.117.286.0 (Jun 1, 2023)
- Microsoft Fabric:
- Power BI Direct Lake mode (preview)
- Azure Analysis Services to Fabric and Power BI Premium Migration Experience now generally available
- Optimize ribbon in Power BI Desktop now generally available
- Hybrid tables now generally available
- Azure Log Analytics for Power BI datasets now generally available
- Power BI data hub updated and rebranded as OneLake data hub
- Reporting:
- Azure maps now generally available
- Measure driven data labels
- Use OneDrive and SharePoint files in Power BI Desktop
- Matrix accessibility improvements
- On-object interaction - updates (preview)
- Set query limits in Power BI Desktop
- Modeling:
- New DAX function: MATCHBY
- Data connectivity:
- On-premises data gateway, May 2023 release
- New Get Data category: Fabric
- New connectors:
- Lakehouse in Microsoft Fabric
- Warehouse in Microsoft Fabric
- KQL database in Microsoft Fabric
- MongoDB Atlas SQL
- Celonis EMS
- CloudBlue PSA
- SolarWinds Service Desk
- Many updated data connectors
- Visuals:
- Many new and updated visuals
New in Microsoft Power BI Desktop 2.116.404.0 (Apr 23, 2023)
- 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 datasets 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]
- Visuals:
- Many new and updated visuals [blog]
New in Microsoft Power BI Desktop 2.115.663.0 (Apr 11, 2023)
- Reporting:
- Apply all slicers button, clear all slicers button, optimization presets update
- Format pane - new styling
- On-object interaction (preview)
- Visual container improvements
- Data connectivity:
- Many updated data connectors
- Visuals:
- New visuals in AppSource
New in Microsoft Power BI Desktop 2.114.664.0 (Feb 24, 2023)
- Reporting:
- Conditional formatting based on string fields
- Smart Narrative visual summary icon
- Formatting image width in table and matrix
- Update your base theme in Power BI
- Report theme validation on custom theme import
- Text box visual indentation
- New accessible report themes
- Customize visible pages in the Page navigator visual
- Sensitivity labels now supported in PDF export from Power BI Desktop
- Enhanced row-level security editor
- Analytics:
- Quick create SDK
- Modeling:
- New DAX functions: LINEST and LINESTX
- Data connectivity:
- Many updated data connectors
- Note:
- See the data sources available to Power BI Desktop. Our list is always growing, so check back often.
- Visuals:
- New visuals in AppSource
New in Microsoft Power BI Desktop 2.110.1161.0 (Nov 8, 2022)
- Reporting:
- Reverse stack order for stacked column charts
- Query performance improvements
- Power BI Metrics
- Analytics:
- Quick measure suggestions - experimental feature (Preview)
- Modeling:
- Relationship editing in the properties pane (Preview)
- DAX formula bar support for Power BI Desktop model view
- Data connectivity:
- Introducing tenant setting for Power BI datamarts (preview)
New in Microsoft Power BI Desktop 2.110.805.0 (Oct 21, 2022)
- Reporting:
- Reverse stack order for stacked column charts
- Query performance improvements
- Power BI Metrics
- Analytics:
- Quick measure suggestions - experimental feature (Preview)
- Modeling:
- Relationship editing in the properties pane (Preview)
- DAX formula bar support for Power BI Desktop model view
- Data connectivity:
- Introducing tenant setting for Power BI datamarts (preview)
- Visuals:
- New visuals in AppSource
- Others:
- Power BI Ideas website enhancements
- Update to release notes
New in Microsoft Power BI Desktop 2.109.1021.0 (Oct 4, 2022)
- Reporting:
- Hierarchical axis by default
- Improved display name for summarized fields
- Conditional formatting for data labels
- Translations support for composite models on Power BI datasets and Analysis Services (preview)
- Mobile formatting options (general availability)
- Information protection update
- Data connectivity:
- Dremio (connector update)
- Profisee (new connector)
- Starburst Enterprise (connector update)
New in Microsoft Power BI Desktop 2.109.642.0 (Sep 21, 2022)
- Reporting:
- Hierarchical axis by default
- Improved display name for summarized fields
- Conditional formatting for data labels
- Translations support for composite models on Power BI datasets and Analysis Services (preview)
- Mobile formatting options (general availability)
- Information protection update
- Data connectivity:
- Dremio (connector update)
- Profisee (new connector)
- Starburst Enterprise (connector update)
- Visuals:
- New visuals in AppSource
- Others:
- Paginated reports data preview
New in Microsoft Power BI Desktop 2.108.564.0 (Aug 26, 2022)
- Reporting:
- Conditional formatting for data labels
- New Select sensitivity label dialog
- Data loss prevention policy update
- Metric visual
- Mobile formatting now supports text box visuals
- Modeling:
- DAX Editor improvements
- Data connectivity:
- MariaDB
- Google Sheets
- Certified connectors availability in Power BI dataflows and datamarts
- Visuals:
- New visuals in AppSource
New in Microsoft Power BI Desktop 2.107.841.0 (Jul 22, 2022)
- Reporting:
- Error bars (generally available)
- Filled Map for Azure Maps visual
- Composite models on Power BI datasets and Analysis Services
- Bold, italics and underline for text in the header tooltip
- Metric visuals updates
- Modeling:
- New DAX function: NETWORKDAYS
- Support for multi-role RLS in composite model
- Query performance improvement
- Data connectivity:
- Connect to datamarts
- Display name support in the Dataverse connector
- Many connector updates
- Visuals:
- New Power BI visuals' category list in AppSource
- New visuals in AppSource
- New visuals available
New in Microsoft Power BI Desktop 2.106.582.0 (Jun 15, 2022)
- Reporting:
- New format pane (generally available)
- Updates to error bars
- Information protection updates
- Table navigation improvements
- Canvas Zoom in Teams and quick create
- Modeling:
- Composite models on SQL Server Analysis Services
- Data connectivity:
- Connect to datamarts (preview)
- Many new data connectors
- Many connector updates (update)
- Note:
- See the data sources available to Power BI Desktop. Our list is always growing, so check back often.
- Visuals:
- New visuals in AppSource
- Many new visuals and updates
- Others:
- Power BI Desktop infrastructure update (WebView2)
- Improved support for single sign-on (SSO) for all users
New in Microsoft Power BI Desktop 2.104.702.0 (Apr 15, 2022)
- Reporting:
- New Format pane updates:
- Tooltips now support drill actions for matrix, line and area charts
- Updates to required permissions when using composite models on Power BI datasets
- Error bars for clustered column and bar charts
- Bookmark navigator now shows last selected bookmark per group
- Data preparation:
- Dynamic M query parameters now generally available
- Data connectivity:
- Autodesk Construction Cloud (new connector)
- Digital Construction Works Insights (update)
- Dremio, Dremio Cloud
- Visuals:
- New visuals in AppSource
- Many new visuals and updates
New in Microsoft Power BI Desktop 2.103.661.0 (Mar 17, 2022)
- The following updates are new to Power BI Desktop this month:
- Reporting:
- New Format pane to be Generally Available in May
- Error bars
- Dynamic format strings now supported for all chart elements
- Updates to the Azure Maps visual
- Sensitivity labels update
- Multi-row card selection
- Data connectivity and preparation:
- BitSight Security Ratings
- Bloomberg Enterprise Data and Analytics
- Anaplan
- FactSet Analytics
- AssembleViews
- Visuals:
- New visuals in AppSource
- Charticulator visual now certified
- Many new visuals and updates
- Other:
- Quickly create reports from SharePoint document libraries
- Changing the default Power BI Home layout
New in Microsoft Power BI Desktop 2.102.683.0 (Mar 17, 2022)
- Reporting:
- New mobile formatting options
- Sensitivity labels downstream inheritance
- Default label policies in Power BI
- New Format Pane (preview) - on by default
- Multi-row card selection
- Data preparation:
- Dynamic M Query Parameters now supports SQL Server and more data sources
- Data connectivity:
- Amazon OpenSearch Server
- OpenSearch Project
- Digital Construction Works Insights
- Azure Databricks
- BQE Core
- Microstrategy
- Starburst Enterprise
- Visuals:
- New visuals in AppSource
- Many new visuals and updates
- Other:
- WebView2 now required
- Power BI Release Plan app
New in Microsoft Power BI Desktop 2.102.683.0 (Feb 26, 2022)
- Reporting:
- New mobile formatting options
- Sensitivity labels downstream inheritance
- Default label policies in Power BI
- New Format Pane (preview) - on by default
- Multi-row card selection
- Data preparation:
- Dynamic M Query Parameters now supports SQL Server and more data sources
- Data connectivity:
- Amazon OpenSearch Server
- OpenSearch Project
- Digital Construction Works Insights
- Azure Databricks
- BQE Core
- Microstrategy
- Starburst Enterprise
- Visuals:
- New visuals in AppSource
- Many new visuals and updates
- Other:
- WebView2 now required
- Power BI Release Plan app
New in Microsoft Power BI Desktop 2.100.261.0 (Dec 16, 2021)
- This month's features are like a sleigh ride through your favorite snowy location, lighting up the season with all sorts of new things we've been wanting and asking for throughout the year.
- Reporting:
- Sparklines (preview)
- New Format Pane updates (preview)
- Data connectivity:
- Azure Data Explorer (update)
- TIBCO Data Virtualization now Generally Available
- Many more updated connectors
- Visuals:
- New visuals in AppSource
- Many new visuals and updates
- Other:
- Visualize your data quickly from Power Apps and Dynamics 365 apps (Preview)
New in Microsoft Power BI Desktop 2.99.563.0 (Nov 24, 2021)
- Reporting:
- New Format pane (preview)
- Page and bookmark navigators
- Sort legend
- Bold, italic, underline for text formatting
- Text box superscript, subscript, and bulleted lists
- Pie and donut chart rotation
- Scorecard visual
- Update on tenant-level Bing Maps feature switch
- Data connectivity:
- Azure Synapse Analytics (new connector) (preview)
- Google Sheets (new connector) (preview)
- Azure Cosmos DB V2 (new connector) (preview)
- Delta Sharing (new connector) (preview)
- Many more updated connectors
- Visuals:
- New visuals in AppSource
- Find report sample files easily in AppSource
- Many new visuals
- Other:
- Automatic page refresh now supports DirectQuery for Power BI datasets and Azure Analysis Services
New in Microsoft Power BI Desktop 2.98.683.0 (Oct 29, 2021)
- There's 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 (https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-whats-new-in-the-mobile-apps).
- Reporting:
- Heat map layer - Azure Maps Visual (preview) [video] [blog] [article]
- DirectQuery for Power BI datasets 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]
New in Microsoft Power BI Desktop 2.97.801.0 (Oct 12, 2021)
- 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]
New in Microsoft Power BI Desktop 2.95.804.0 (Jul 22, 2021)
- Reporting:
- Small multiples now generally available
- Conditional formatting for more properties
- Power Automate visual now available (preview)
- Sensitivity labels in Power BI Desktop
- Republish PBIX with option to not override label in destination
- Inherit sensitivity label set to Excel files when importing data into Power BI
- Analytics:
- Sharing Q&A synonyms
- Modeling:
- New Model View now generally available
- DirectQuery for Azure Analysis Services and Power BI datasets (preview)
- Data connectivity:
- New connectors - Amazon Athena
- Updates to many connectors
- Visuals:
- New visuals from various providers
- Template apps:
- Analyze email marketing performance using Mailchimp and ActiveCampaign
- Other:
- Power BI Desktop installer changes
New in Microsoft Power BI Desktop 2.94.242.0 (Jun 30, 2021)
- Most features are explained in a section in the monthly update blog post.
- Some features have a video excerpt that discusses the feature, which plays in a new browser tab.
- Some features have an article that provides more detail.
- The remaining features are self-explanatory and don't need an article or video.
New in Microsoft Power BI Desktop 2.93.981.0 (May 28, 2021)
- 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 datasets and Azure Analysis Services [video] [blog]
- Modeling:
- DirectQuery for Power BI datasets 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]
New in Microsoft Power BI Desktop 2.92.706.0 (Apr 29, 2021)
- 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 datasets 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]
New in Microsoft Power BI Desktop 2.92.303.0 (Apr 17, 2021)
- 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 datasets 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]
New in Microsoft Power BI Desktop 2.91.701.0 (Mar 30, 2021)
- Reporting:
- DirectQuery for Power BI datasets 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]
New in Microsoft Power BI Desktop 2.90.303.0 (Mar 18, 2021)
- Reporting:
- DirectQuery for Power BI datasets 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 dataset 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]
New in Microsoft Power BI Desktop 2.88.321.0 (Dec 24, 2020)
- Reporting:
- DirectQuery for Power BI datasets and Azure Analysis Services (preview)
- Small multiples (preview) [video] [blog]
- Data protection sensitivity labels in Power BI Desktop (preview) [
- Increased rectangle select data point limit
- Selection pane now available in mobile layout view
- Automatic page refresh for Analysis Services sources
- Data preparation:
- Changes to Power Query and dataflows
- Data connectivity:
- Microsoft Dataverse connector
- Azure Time Series Insights update
- SurveyMonkey update
- Cognite update
- Visuals:
- New visuals from various providers
New in Microsoft Power BI Desktop 2.87.1061.0 (Dec 1, 2020)
- 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]
New in Microsoft Power BI Desktop 2.83.5894.661 (Jul 23, 2020)
- 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]
New in Microsoft Power BI Desktop 2.82.5858.301 (Jul 9, 2020)
- Reporting:
- Enhancements to mobile layout authoring
- Automatic page refresh now generally available
- Hierarchical slicer now generally available
- Modern ribbon now generally available
- RLS now supported for Featured Tables in Excel's Data Types gallery
- Analytics:
- AI insights now generally available
- Visuals:
- Line chart dot formatting options
- Many new visuals from multiple vendors
- Template apps:
- Agile HR Analytics
- Uber User Data Report
- Modeling:
- Model view enabled for live connect (preview)
- Updates to Model view
- Data connectivity:
- Palantir Foundry connector
- Other features:
- New Power BI trainings
New in Microsoft Power BI Desktop 2.78.5740.642 Store App (Feb 20, 2020)
- The following updates are 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]
New in Microsoft Power BI Desktop 2.76.5678.782 (Feb 10, 2020)
- Reporting:
- Customize the current theme (preview)
- Export the current theme (preview)
- Setting table column or matrix value as a custom URL
- KPI visual formatting settings
- New decomposition tree formatting
- Filter pane toggle button in the new ribbon
- Automatic page refresh query details
- Analytics:
- Load more for Analyze insights
- New DAX function: Quarter
- Visuals:
- Personalizing the Visuals pane (generally availability)
- New custom visuals
- Data connectivity:
- Azure Data Lake Storage Gen2 connector (generally availability)
- Power Platform Dataflows connector (generally availability)
- PostgreSQL connector now includes the Npgsql provider
- AtScale connector (general availability)
- Azure Time Series Insights connector
- Data Virtuality connector
- Zucchetti HR Infinity connector
- Data preparation:
- Updates to AI Insights functions (preview)
- Template apps:
- Omnichannel insights for Dynamics 365
- Customer service analytics for Dynamics 365
- Microsoft Forms Pro for Customer Services
New in Microsoft Power BI Desktop 2.71.5523.641 (Jul 19, 2019)
- 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 custom 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]
New in Microsoft Power BI Desktop 2.70.5494.561 (Jun 11, 2019)
- Our June updates are here to spread sunshine and blue skies on your reports, with a refreshing and bright new color scheme for your Power BI Desktop, and a host of other improvements.
- 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 may 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:
- 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 datasets
- 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 custom visuals and updates [video] [blog]
- Data connectivity
- Connect to shared and certified datasets [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]
New in Microsoft Power BI Desktop 2.69.5467.1251 (May 18, 2019)
- Reporting:
- Performance Analyzer pane
- Filter pane improvements (preview)
- Table and matrix keyboard navigation
- Line data label position control
- KPI visual indicator text size control
- Analytics:
- Key influencers visual improvements (preview)
- Binning support
- Formatting options
- Mobile support
- Modeling:
- Disable auto-date tables for new reports
- Update to the ALLSELECTED DAX function
- Visuals:
- ArcGIS maps for Power BI updates]
- Six new custom visuals and updates
- Data connectivity:
- Essbase connector - support for Native Query (MDX)
- Intune Data Warehouse connector
- Tenforce connector
- Roamler connectorog
- Other:
- Automatic query cancellation for Power BI Desktop
New in Microsoft Power BI Desktop 2.68.5432.361 (Apr 11, 2019)
- 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:
- Drillthrough 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]
- Custom 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 Paginated Report Builder [blog]
New in Microsoft Power BI Desktop 2.67.5404.581 (Apr 1, 2019)
- Reporting:
- Single select slicer
- Heat map support for Bing maps
- Cross-highlight by axis labels
- Default tooltip formatting
- Static web URL support for buttons, shapes and images
- Filter pane improvements
- Page alignment options
- Selection pane improvements
- Formatting updates for maps
- Accessible visual interaction
- Analytics:
- Q&A recommendations for improving results
- Show dates as a hierarchy now generally available
- Modeling:
- New modeling view now generally available
- New DAX functions
- Custom visuals:
- New certified custom visuals setting in the admin portal
- Two new custom visuals
- Data connectivity:
- PDF connector now supports tables spanning multiple pages (preview)
- Intelligent Plant's Industrial App Store connector
- Azure Cost Management connector
New in Microsoft Power BI Desktop 2.62.5222.582 (Sep 12, 2018)
- 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.
New in Microsoft Power BI Desktop 2.61.5192.321 (Aug 9, 2018)
- The following updates are new to Power BI Desktop this month:
- 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]
- Custom visuals
- Five new custom visuals [video] [blog]
- Data connectivity
- Spark connector generally available [video] [blog]
New in Microsoft Power BI Desktop 2.60.5169.3201 (Jul 24, 2018)
- This month's big updates are 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.
- 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, 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:
- 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]
- Custom visuals
- Power BI certified category [video] [blog]
- Disabling specific organizational visuals [video] [blog]
- Four new custom 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]
New in Microsoft Power BI Desktop 2.59.5135.101 (Jun 6, 2018)
- Reporting:
- High contrast support for reports
- Donut radius control
- Pie and donut detail labels position control
- Format data labels separately for each measure in a combo chart
- Longer phone reports
- Custom visuals:
- Two new custom visuals
- Modeling:
- Filtering and sorting in data view
- Improved locale filtering
- Data connectivity:
- SAP BusinessWarehouse connector improvements (new driver and improved performance, plus improved support for hierarchy variables)
- Spark connector now supports Windows Authentication
- OData V4 connector enhancements
- ODBC connector improvements (folding support for Top Rows, ability to filter navigation by DSN catalog)
- Other:
- Sovereign cloud selector
New in Microsoft Power BI Desktop 2.58.5103.281 (May 8, 2018)
- Reporting:
- Conditional formatting by a different field
- Advanced slicer syncing
- Log axis improvements
- Data label options for funnel chart
- Set line stroke width to zero
- Analytics:
- Measure drillthrough
- Power BI Premium:
- Incremental refresh (preview)
- Custom visuals:
- Many new custom visuals
- Data connectivity:
- New From Web connector - by example data extraction (preview)
- Common Data Service for Apps connector (beta)
- Azure KustoDB connector (beta)
- Google BigQuery and Azure HDInsight Spark connectors now generally available
- Adobe Analytics connector update - support for multiple domain logins (preview)
- Visual Studio Team Services connector update - analytics views support
- OLE DB connector update - support for alternate Windows credentials
- SAP BW DirectQuery connector update - improved technical name support
- Data preparation:
- Improvements to Add Column from Examples
New in Microsoft Power BI Desktop 2.57.5068.501 (Apr 5, 2018)
- Reporting:
- Q&A Explorer
- Buttons to trigger actions
- Combo chart line styles
- Improved default sort for visuals
- Numeric slicer now generally available
- Analytics:
- Update your linguistic schema
- New DAX function: COMBINEVALUES()
- Custom visuals:
- Organizational visuals now generally available
- Many new custom visuals
- Data connectivity:
- Adobe Analytics connector now generally available
- SAP HANA connector improvement: Port selection
- Dynamics 365 Business Central connector
New in Microsoft Power BI Desktop 2.56.5023.621 (Mar 8, 2018)
- Reporting:
- Report page tooltips
- Bookmarking is now generally available
- Display units and precision control for Table and Matrix columns
- Turn off the visual header in Reading mode for a report
- Improved default visual placement
- Custom visuals:
- Many new custom visuals
- Data connectivity:
- Visual Studio Team Services connector improvements
- SAP HANA connector enhancements
- DirectQuery multidimensional support is now generally available
- SSL certificate validation support
- SAP BW DirectQuery now generally available
- Azure Analysis Services connector now generally available
- Other:
- Improved error reporting
- View previous errors you've encountered
New in Microsoft Power BI Desktop 2.55.5010.521 (Feb 7, 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]
- Custom visuals:
- Organization custom 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]
New in Microsoft Power BI Desktop 2.55.5010.201 (Feb 6, 2018)
- Reporting:
- Multi-select data points across multiple pages
- Sync slicers across multiple pages of a report
- Numeric range slicer improvement - whole number snapping (Preview)
- Faster geocoding for Bing maps (web Preview) - approximately 6x faster
- Overflow data labels for bar and column charts visuals
- Search the Formatting and Analytics panes
- Custom visuals:
- Organization custom visuals (Preview)
- Analytics:
- Set a custom date table
- Quick measures are now generally available
- Data connectivity:
- Improvements to DirectQuery over SAP HANA (Preview)
- Other:
- DirectQuery performance improvements
- Open and save performance improvements
- Show items with no data improvements
- Persistent filters control for upcoming Power BI service feature
New in Microsoft Power BI Desktop 2.54.4970.761 (Jan 13, 2018)
- 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 custom visuals [video] [blog]
- Analytics:
- Correlation coefficient quick measure [blog]
- Data connectivity:
- Support for Azure Active Directory authentication for Azure SQL Database and Data Warehouse connectors
New in Microsoft Power BI Desktop 2.53.4954.481 (Dec 13, 2017)
- Reporting:
- Q&A for report creation
- Cross-highlighting for bookmarks
- More bookmark flexibility
- Field properties pane and field descriptions
- Scatter visual from x- and y-axis groupings
- High density sampling for maps based on latitude and longitude
- Responsive slicers
- Recently released custom visuals
- Analytics:
- Drill filters other visuals
- Data connectivity:
- Adobe Analytics connector
- HDInsight Interactive Query connector
- Data.World connector
- SAP BW connector improvements
- IBM Netezza connector now generally available
New in Microsoft Power BI Desktop 2.52.4921.202 (Nov 8, 2017)
- Reporting:
- Rule-based conditional formatting for Table and Matrix visuals
- Cell alignment for Table and Matrix visuals
- Control visual ordering through the selection pane
- Lock objects on your report
- Esri Plus Subscription is available for ArcGIS Maps for Power BI
- Report options for slow data sources
- Filtering performance improvements
- Recently released custom visuals
- Analytics:
- Cell-level formatting for multidimensional AS models for multi-row card
- Data Connectivity:
- Impala connector - support for Windows Authentication
- Other:
- Query editing - Add Column from Example improvements
New in Microsoft Power BI Desktop 2.51.4885.543 (Oct 6, 2017)
- Reporting:
- Bookmarking (preview)
- Selection pane and visual display controls
- Bookmark links for shapes and images
- Spotlight
- Scatter and Bubble markers
- Increase the number of data points displayed in Scatter visuals
- Analytics:
- Quick measures for SSAS live connections
- Sales from new customers quick measure
- Cell-level formatting for multi-dimensional Analysis Services (AS) models
- Data Connectivity:
- Vertica connector (beta)
- SAP BW connector - support for additional member properties
- Other:
- Get Power BI Desktop from the Windows Store
- Improved access to help content
New in Microsoft Power BI Desktop 2.50.4859.502 (Sep 14, 2017)
- Report View:
- Drillthrough to another report page
- Ribbon chart
- Insights about Explain the increase / Explain the decrease
- Theming preview update - chart style controls
- Accessibility improvements
- Accessible See data
- Keyboard shortcut helper dialog
- High density scatter chart sampling
- Gridline style control
- New custom visuals:
- Calendar by Tallan
- Enlighten Aquarium
- Visio visual (preview)
- Impact bubble chart
- Data Connectivity:
- Azure Consumption Insights connector
- Improvements to the Dynamics 365 for Financials connector
New in Microsoft Power BI Desktop 2.49.4831.222 (Aug 13, 2017)
- Report View:
- Show values on rows for matrix
- Color scales on font colors for table and matrix
- Custom subtotal settings per level of matrix
- Line styles and legend options
- Scatter chart performance improvements
- New custom visuals
- Dot Plot by MAQ Software
- Power KPI
- Funnel plot
- Beyondsoft Calendar
- Analytics & Modeling:
- What if parameters
- New scatter chart analytics features
- Symmetry shading
- Ratio lines
- New quick measure: weighted average
- Data Connectivity:
- Live connect to the Power BI service is generally available
- Google BigQuery connector (beta)
New in Microsoft Power BI Desktop 2.48.4792.321 (Jul 6, 2017)
- Report View:
- New table & matrix visuals are now generally available
- Renaming fields in visuals
- Custom visuals store integration
- Relative date filters
- Responsive layout for visuals (preview)
- New waterfall chart option - breakdown
- Custom visual updates:
- Drilldown Choropleth
- Drilldown Cartogram
- Drilldown Player
- Certified custom visuals
- Analytics & Modeling:
- Bidirectional cross filtering for DirectQuery is now generally available
- Quick measures from the community:
- Star rating
- Concatenated list of values
- Data Connectivity:
- Snowflake connector general availability
- Query Editing:
- Add Column from Examples enhancements
New in Microsoft Power BI Desktop 2.47.4766.542 (Jun 12, 2017)
- Report View:
- Data bars for new table and matrix visuals (Preview)
- Markers on line, area, and combo visuals (Preview)
- Visual font family setting
- Horizontal image slicer
- Combo chart formatting updates
- Bing maps improvements
- High density line sampling
- Accessible reports
- Data Connectivity:
- Custom Data Connectors support
- Power BI service Live Connect to On-premises and Push streaming datasets
- Impala connector is now generally available
- Amazon Redshift connector is now generally available
- SAP BW connector - DirectQuery support
- IBM Netezza connector (beta)
- Query Editing:
- Add Column from Examples enhancements
New in Microsoft Power BI Desktop 2.46.4732.461 (May 5, 2017)
- Report View:
- Relative date slicer (Preview)
- New table visual (Preview)
- Combo chart data label enhancements
- More URL support in table and matrix visuals
- mailto links in textbox
- Analytics:
- Report level measures for live connections to Analysis Services tabular models and Power BI service datasets
- Two new quick measures (Preview)
- Bin by count
- Data Connectivity:
- Combine files - ability to reference First File as example
- New data connectors:
- Dynamics 365 for Customer Insights
- Query Editing:
- Two new transforms:
- Extract text before/after/between delimiters
- Unpivot only selected columns
New in Microsoft Power BI Desktop 2.45.4704.442 (Apr 4, 2017)
- Report View:
- Rename axis titles
- New matrix visual enhancements: column sorting, column resizing, and word wrap (Preview)
- Analytics:
- Quick measures
- Show value as
- Q&A in Spanish (Preview)
- Data Connectivity:
- Connect to datasets in the Power BI service (Preview)
- New or enhanced data connectors:
- Redshift Connector: beta support, and Publish to Power BI service
- SAP HANA and BW: enhancements to parameter input experience
- Query Editing:
- Add Column from Example
- Split column (by delimiter/number of characters) into rows
- Group by: basic mode
- Go to column
New in Microsoft Power BI Desktop 2.44.4675.422 (Mar 8, 2017)
- Report View:
- New matrix visual (Preview)
- Numeric range slicer (Preview)
- Data labels on pie and donut visuals - percent of total
- Cross-highlight using multiple series
- Textbox - ability to choose font color
- Report theming (Preview)
- Analytics:
- Clustering - now generally available
- Data Connectivity:
- New or enhanced data connectors :
- Azure Analysis Services database (Beta)
- Azure Data Lake Store - now generally available
- DB2 connector - option to specify package collection
- Combine binaries - specify a sample file to use
- Query Editing improvements:
- Split column by delimiter - automatic detection of delimiter character
New in Microsoft Power BI Desktop 2.43.4647.541 (Feb 10, 2017)
- Report View:
- Word wrap on matrix row headers
- X- and Y-axis font size control
- Cartesian chart minimum category width
- Line chart line thickness and join type controls
- Analytics:
- Two new Quick Calcs: Percent of row total, and percent of column total
- Data Connectivity:
- New or enhanced data connectors:
- ODBC and OLE DB connectors - support for Select related tables
- Enhanced Folder connector - support for combining binaries from the Preview dialog
- Unified Text and CSV connectors
- New - PowerApps Common Data Service connector
- Query Editing improvements:
- Quickly change a column's data type and locale with the new Using locale option in the Column headers type menu
- Easily insert steps into existing queries, using the new Insert Step After option
- Other improvements:
- Solutions Templates and Partner Showcase quick access
New in Microsoft Power BI Desktop 2.42.4611.482 (Jan 13, 2017)
- We're excited about the fresh new features we're launching this month, as the first update of the new year. 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
- Report View:
- Table and matrix conditional formatting improvement - blank formatting [video] [blog]
- New aggregations for string and dateTime columns
- Table header word wrap
- General Availability (GA) of Phone reports
- Data Connectors:
- New or enhanced data connectors [video]:
- Visual Studio Team Services connector (Beta)
- Enhanced SQL Server connector - support for SQL Failover option
- Query Editing improvements:
- New transform: extract values from a nested list
New in Microsoft Power BI Desktop 2.41.4581.301 (Nov 30, 2016)
- Report View:
- Hierarchical axis
- Axis label and title color control
- Matrix conditional formatting
- Table and matrix column formatting
- Drop-down slicer
- Mobile reports scrolling
- Analytics:
- Clustering (preview)
- Forecasting (now in the Power BI service)
- Groups (now on the ribbon)
- Data Connectors:
- New data connectors: Spark DirectQuery
- OData connector improvements
- Enhanced combine binaries experience
- Azure Analysis Services
- Query Editing improvements:
- Improved function authoring experience
- Support for percentage data type
- Added Maximize and Restore buttons in Navigator and Query Dependencies
New in Microsoft Power BI Desktop 2.40.4554.361 (Nov 1, 2016)
- Report View:
- Improved date axis range formatting
- Date slicer
- Report gridlines and snap to grid (Preview)
- Data label improvements
- Map formatting options
- Improved date axis range formatting
- Analytics:
- Grouping
- Binning
- Top-N filter
- Include/exclude data points
- R-powered custom visuals
- Data Connectors:
- New data connectors:
- Microsoft Dynamics 365 for Financials (Beta)
- OLE DB
- Mixpanel
- Query Editing improvements:
- Support for table parameters in the Invoke Function dialog
- Other improvements:
- Diagnostics information in the About dialog
New in Microsoft Power BI Desktop 2.39.4526.362 (Oct 6, 2016)
- Report View:
- ArcGIS Maps for Power BI (Preview)
- Mobile report layout (Preview)
- Updated drill behavior
- Analytics:
- Forecasting (Preview)
- Use your own R IDE
- Data Connectors:
- New data connectors:
- Snowflake connector DirectQuery support
- ProjectPlace connector
- Improvements to existing connectors:
- Oracle connector - improved Navigator previews performance
- OData connector - support for Select Related Tables option
- SAP Business Warehouse and SAP HANA connectors - enhancements to parameter input interface
- Web connector - support for specifying HTTP request headers within the dialog
- Query Editor improvements:
- Query Dependencies view
- Show Errors experience
- Query Editor ribbon support for scalar values
- Add function invocation column
- Expand & Aggregate columns - support for Load More values
- New transform - convert Table Column to a list
- Keyboarding - support for smart typing in drop-down menus
- Other improvements:
- In-product links to the Power BI Community
New in Microsoft Power BI Desktop 2.37.4464.321 (Jul 30, 2016)
- REPORT VIEW:
- Predefined table styles
- Shape Maps update - use custom maps
- DATA CONNECTORS:
- New data connectors:
- Amazon Redshift
- Impala
- Improvements to existing connectors:
- Web connector - support for specifying a connection timeout
- CSV and Text - support for fixed-width delimited files
- Improvements and changes to the SAP Business Warehouse connector
- QUERY EDITOR IMPROVEMENTS:
- Use R script in Query Editor
- Query parameter enhancements:
- List query output as allowed values for a parameter
- Overwrite existing user-defined functions
New in Microsoft Power BI Desktop 2.36.4434.362 (Jul 4, 2016)
- Report View:
- New visual - Shape Maps
- Searchable slicers
- Configurable line chart labels
- New sign-in entry points
- Data Access:
- Row Level Security
- Data Connectors:
- New data connector: Azure Enterprise
- Enhanced SAP BW and HANA connectors:
- Allow multi-select of values for Variables/Parameters
- Support for Hierarchies in SAP BW
- Enhanced OData connector - imports Open Type columns
- Enhanced Access DB connector - button to Select Related Tables in Navigator dialog
- Data Connectors:
- Templates - option to Load or Edit
- Query parameter enhancements:
- Option to always allow Parameter specification
- Create new parameter directly in context
- Option to generate Step Names in English
- Descriptions for Query Steps [video]
- New Data Transformations:
- 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
New in Microsoft Power BI Desktop 2.35.4399.381 (Jun 2, 2016)
- Report View:
- Customizable tooltips
- Conditional formatting in tables
- Publish to Pyramid server
- Scrolling loads more data in charts
- Keyboard nudging for visuals
- Analytics:
- Quick Calcs - % of grand total
- Data Connectivity:
- New data connectors:
- Informix
- comScore Digital Analytix
- Troux
- Planview Enterprise
- Improved DB2 connector
- Text/CSV connector exposes editable settings in preview dialog
- Improved relational database connectors with Display Schema information
- Data Source Settings enhancements
- Advanced Filter Rows dialog mode
- Inline Input controls for Function invocation within Query Editor
- Query Parameters:
- 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
- Support for reordering Query Steps using drag-and-drop
- Date picker support in Conditional Columns dialog input Date fields
- New context menu entry to create new queries from the Queries pane
New in Microsoft Power BI Desktop 2.34.4372.322 (May 4, 2016)
- Report View:
- Additional styles on a table, matrix, and multi-row card
- Trend lines on single visuals
- New drill action – See Records
- Map auto-zoom during drill/filter
- In-line hierarchy labels for expanded view (Preview - see the article)
- Data Modeling:
- Modelling operations are no longer blocked while visuals are refreshing
- Time Intelligence with built-in date hierarchy fields (Preview)
- Data model synonyms
- Data Connectivity:
- Query Parameters
- Power BI Template files
- New Online Services category in Get Data dialog
- 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
- New Connectors:
- SharePoint Folder
- Webtrends
- SparkPost
- tyGraph
New in Microsoft Power BI Desktop 2.33.4337.281 (Mar 28, 2016)
- 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
New in Microsoft Power BI Desktop 2.32.4307.362 (Mar 2, 2016)
- Report View:
- See Data Behind a Visual (including Export Data to CSV)
- Map improvements – plot map with latitude/longitude only
- KPI consumption release support (including navigation hierarchy support and KPI trend for SSAS MD)
- SSAS Exploration Mode: Support for Display folders in the Fields pane
- Ribbon layout improvements: Contextual ribbon tab for Report Tools
- New KPI visual
- Get reports opened to the same page that was visible when they were saved
- Edit Query option in table context menu in the Fields pane (Report & Data views)
- Duplicate Page from the ribbon
- Data Modeling:
- Ability to define hierarchies
- Performance Improvement: Table & Column rename optimizations
- Data Connectivity:
- DirectQuery support for Oracle and Teradata databases
- DirectQuery – support for creating Calculated Columns
- Support for publishing Analysis Services Live reports
- JSON File connector
- SQL Sentry connector
- Support for jagged CSV files
- Exchange Connector – OAuth support
- SharePoint List Connector – URL validation
- Database Connectors – ability to disable Navigation Columns in Query previews (Performance optimization)
- Web Connector – fine-grained scoping of Credentials
- Enter Data dialog UX enhancements
- SAP HANA – Support for single sign-on with Windows Authentication (Power BI Desktop only)
- SAP HANA – Support for Field labels
- Alphabetical sort of columns in Choose Columns builder
- Improved performance of renaming/removing/reordering columns
- Virtualized Preview in Query Editor
- Visual indicator for unloaded queries in Query Editor
- 1-click Percentage transform
New in Microsoft Power BI Desktop 2.31.4280.361 (Jan 31, 2016)
- Report View:
- See data behind a visual
- You can now add borders to a visual
- Add an image background to a visual
- Data Connectivity:
- 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)
- DirectQuery: you can now create measures when using DirectQuery mode
- 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
New in Microsoft Power BI Desktop 2.30.4246.181 (Jan 28, 2016)
- Report Authoring:
- Formatting Pane and Ribbon:
- Format data labels per category services
- Change the number of decimal places shown in visuals
- Change text size in visuals
- Ability to layout visuals accurately: alignment, distribute, size, position
- Set styles across multiple visuals through Format Painter
- Optimized Home ribbon layout
- Enhancements to Visualizations:
- Visual cue for sort state in Table visual
- New visual: Stacked Area chart
- Smart tooltips for Area and Line charts on hover
- Ability to create reference line/region for a Cartesian visual
- Improved data labels for Pie and Scatter charts
- R Visuals integration in Power BI Desktop (Preview feature)
- Suggested table-to-table relationships when trying to create visuals involving two tables which are not related
- Data Modeling:
- Relationships View
- Zooming slider
- Fit Zoom to screen
- Reset layout
- Ability to zoom in CTRL+(mouse selection range)
- Data Connectivity:
- SSAS Multidimensional support - hierarchies support
- Stripe Connector
- Smartsheet Connector
- Enter Data: paste or enter data to create a table
- DirectQuery improvements: support for all data types of T-SQL and SAP HANA, resulting in performance improvements
- ODBC Connector: support for selecting User/System DSNs
- CSV Connector: ability to specify Column Delimiter in the Source dialog
New in Microsoft Power BI Desktop 2.29.4217.221 (Jan 28, 2016)
- 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 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
New in Microsoft Power BI Desktop 2.28.4190.122 (Jan 28, 2016)
- 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