Power BI Desktop feature summaries
- Power BI July 2021 Feature Summary
- Reporting
- Small multiples
- Conditional formatting for more properties
- Power BI’s built-in visuals now include the Power Automate visual
- 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
- Modeling
- New Model View
- DirectQuery for Azure Analysis Services & Power BI datasets Updates
- Data connectivity
- Amazon Athena (new connector)
- Databricks (updated connector)
- Dremio (updated connector)
- MariaDB (updated connector)
- Service
- Streaming dataflows
- Mandatory label policy
- Custom help link for sensitivity labels
- Datasets hub improvements
- Goals support in lineage view
- Scanner API (Admin REST APIs) enhancements to include dataset tables, columns, measures, DAX expressions, and mashup queries
- Visualizations
- New visuals
- Charticulator (custom visual version 1.0.5)
- Multiple Sparklines
- Acterys Reporting
- PureViz Infographic – from PowerPoint to Power BI
- Dynamic radial bar chart by JTA
- Drill Down Waterfall PRO
- Control Chart XmR by Nova Silva
- Editor’s picks
- Template apps
- Analyze your email marketing performance using Mailchimp and ActiveCampaign
- Other
- Power BI Desktop Installer Changes & WebView2
- Power BI June 2021 Feature Summary
- Reporting
- Paginated reports visual
- Area chart transparency sliders
- Inner padding for continuous axes
- Small multiples: responsiveness and conditional formatting
- Analytics
- Q&A improvement for inferred results
- Modeling
- Format strings now persisted when using DirectQuery for Power BI datasets and Azure Analysis Services
- Data preparation
- DirectQuery support for Dataflows
- Select all operation is now supported for Dynamic M Query Parameters
- Data connectivity
- Assemble Views (new connector)
- BQE Core (new connector)
- SumTotal (new connector)
- Adobe Analytics (updated connector)
- Anaplan (updated connector)
- Azure Databricks (updated connector)
- Cognite Data Fusion (updated connector)
- Dynamics 365 Business Central (updated connector)
- FactSet Analytics (updated connector)
- Google BigQuery (updated connector)
- Starburst Enterprise (updated connector)
- Vessel Insight (updated connector)
- Workplace Analytics (updated connector)
- Snowflake (updated connector)
- Azure Consumption Insights (connector deprecated)
- Service
- Datasets discoverability
- Request access to datasets
- Mandatory label policy for Microsoft Information Protection sensitivity labels
- Admin API to Set and Remove Microsoft Information Protection sensitivity labels
- Automate deployments with new APIs and PowerShell samples
- Manage Dataflows in deployment pipelines
- Admin APIs for deployment pipelines
- Mobile
- A new look for the Power BI Windows app
- Passing URL parameters to paginated reports
- Visualizations
- New visuals
- Drill Down Combo Bar PRO by ZoomCharts
- Dumbbell Bar Chart by Nova Silva
- graphomate bubbles 2021.2
- Zebra BI Tables 5.0
- Zebra BI Charts 5.0
- Editor’s picks
- Template apps
- Template app one-click update and republish
- Salesforce Analytics for Sales Managers
- Other
- Power BI Desktop Installer Changes
- June update of Power BI Report Builder
- Report action bar now available in the Power BI SharePoint Online Webpart
- Power BI May 2021 Feature Summary
- Reporting
- Modern visual tooltips
- Small multiples: now on by default and updated roadmap
- New field list
- Support for removing the sensitivity label in Desktop
- Analytics
- Smart Narratives and Anomaly detection
- Q&A now supports DirectQuery for Power BI datasets and Azure Analysis Services
- Modeling
- DirectQuery for Power BI datasets and Azure Analysis Services
- Model View Updates
- Data connectivity
- New Connector: EQuIS
- Connector Update: Automation Anywhere
- Connector Update: Vena
- Connector Update: Azure Databricks
- Connector Update: Amazon Redshift
- Connector Update: Vertica
- Connector Deprecation: Microsoft Graph Security
- Service
- Quickly create reports from SharePoint lists
- Reports, apps and dataflows endorsement
- Datasets hub improvements
- Quick Edit Paginated Reports from the Service
- Single sign-on enabled for new on-premises data sources for paginated reports
- Downstream inheritance for sensitivity labels
- Mobile
- Work side by side with other apps on your iPad or Android tablet
- Visualizations
- New visuals
- ADWISE roadmap v2.0
- Bubble chart by Akvelon
- Cycle Plot by Nova Silva
- Drill Down Donut PRO by ZoomCharts
- Drill Down Map PRO by ZoomCharts
- Drill Down Pie PRO by ZoomCharts
- graphomate charts 2021.2
- graphomate matrix 2021.2
- Editor’s picks
- Template apps
- Dataflows Snapshot Analysis
- Developers
- Dialog boxes support for Power BI custom visuals
- Displaying a warning icon for a custom visual
- Other
- Share and Collaborate in Excel for the web connected to Power BI
- Power BI April 2021 Feature Summary
- Reporting
- Power Automate for Power BI
- Small multiples: padding controls and combo chart support
- New and improved shapes
- Invert axis and continuous axis sorting
- Modeling
- DirectQuery for Power BI datasets and Azure Analysis Services
- CROSSFILTER supports many-to-many relationships
- Performance improvements to IF and SWITCH functions
- Data connectivity
- New Connector: Bloomberg Data and Analytics
- New Connector: SoftOne BI
- Text/CSV By Example now generally available
- Automatic Table Detection from Excel files now generally available
- Automatic Table Detection from JSON files now generally available
- Service
- Easy report sharing via links
- Improving the Create on top of published dataset experience
- New capabilities in Deployment Pipelines
- Enhancements to Sensitivity Labels
- Sensitivity labels in Power BI embedded now generally available
- Securing the full data journey from Azure to Office
- Admin API to Set and Remove labels in Power BI
- Visualizations
- Microsoft Charticulator visual
- New visuals
- Financial Reporting Matrix by Profitbase
- Merged Bar Chart by Nova Silva
- Editor’s picks
- Developers
- API v3.6.0 is now available
- Other
- Simplifying collection of diagnostic information
- Power BI March 2021 Feature Summary
- Reporting
- DirectQuery for Power BI datasets and Azure Analysis Services (preview)
- Advanced Data Selection in Azure Maps Visual
- Color Picker Updates
- Updates to new Field List (preview)
- Word-wrap in Small Multiples titles (preview)
- Updates to background settings on Small Multiples (preview)
- Analytics
- X axis constant line for line charts
- Modeling
- Model View UI (preview)
- IF.EAGER
- CALCULATE filters are easier to use
- Data connectivity
- Kerberos-based SSO for Denodo
- Certified Connectors
- Service
- Featured content on Home Updates
- View dataset details from workspace list view
- Filter apps gallery to view only endorsed apps
- Visualizations
- New visuals
- SMART KPI List by Nova Silva
- Comparison Chart
- Combo Bar PRO Visual
- Editor’s picks
- Template Apps
- Download PBIX files for installed template apps
- Analyze Popular Stocks with Power BI
- Facebook Ads Overview Report – by Windsor.ai
- Embedded
- The new Power BI embedded analytics playground
- Power BI Embedded Generation 2 (preview)
- Power BI embedded analytics new Contoso demo
- New Client API documentation
- Other
- Windows 7 Deprecation
- Certificate revocation check controls now available in Desktop interface
- External Tools integration in Desktop generally available
- Power BI instructor led training – Advanced Data Modeling and data shaping
- Desktop change log
- Power BI February 2021 Feature Summary
- Reporting
- DirectQuery for PBI datasets and Azure Analysis Services Updates (preview)
- Search Bar
- Model View Updates (preview)
- New Field List (preview)
- Small Multiples (preview): gridlines and background colors
- Color picker
- Smart guides for aligning objects are now available in the mobile layout view
- New filter operations: “is empty” and “is not empty”
- More granular control over certificate revocation check for web connections
- Analytics
- Anomaly detection now in ribbon
- Data connectivity
- Snowflake: Support for Custom Roles
- Parquet Files: Connector Available in Power BI Desktop
- Hive LLAP: Support for Windows Authentication
- Salesforce: API Update
- SAP HANA and BW: New Documentation
- Service
- Email subscription attachment
- Mobile
- Easily find your org’s endorsed content using the mobile app
- Power BI free license users can now navigate to workspaces in the mobile apps
- Visualizations
- New visuals
- Shielded HTML Viewer by Nova Silva
- Zebra BI Tables (version 4.5)
- Zebra BI Charts (version 4.5)
- ValQ 2.0 Released with Connected and Collaborative Planning Features
- Drill Down Combo PRO by ZoomCharts
- Editor’s picks
- Template Apps
- Microsoft partners: Installing a preconfigured template app
- Sales Analytics AI for Microsoft Business Central
- Developers
- Visual container fix
- EnumObjectInst with no datarole support
- Other
- New icon update
- Heads up: Microsoft 365, including Power BI, ending support for Internet Explorer 11 and legacy version of Microsoft Edge
- Paginated reports export API is now generally available
- Instructor led training February 24th and 25th
- Power BI December 2020 Feature Summary
- Reporting
- DirectQuery for Power BI datasets and Azure Analysis Services (preview)
- Small multiples (preview)
- Data protection sensitivity labels in Power BI Desktop (preview)
- Increased rectangle select data point limit
- Selection pane is now available in the mobile layout view
- Automatic page refresh for Analysis Services and Power BI datasets
- Data preparation
- Recent changes to Power Query and Dataflows
- Data connectivity
- Microsoft Dataverse Connector
- Azure Time Series Insights Update
- SurveyMonkey Update
- Cognite Update
- 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)
- Mobile
- Dark mode support in the Power BI Android app
- Anomaly detection is now supported in all mobile apps (iOS, Android and Windows)
- Embedded
- New look for Embedded scenarios
- New capabilities in embedding for your organization
- Personalize visuals experience now fully supported on embedded scenarios
- New Q&A embed experience
- Power BI APIs & Life-Cycle Management
- Coming Soon
- Visualizations
- New visuals
- Strip Plot by Nova Silva
- Intelligent Narratives by Arria NLG
- Editor’s picks
- Template Apps
- Test Your Analytics Maturity
- Apps on AppSource
- Power BI Gold suite
- Developers
- New Admin APIs and Service Principal authentication to make for better tenant metadata scanning
- Power BI Visuals Platform adds support for conditional formatting
- Power BI November 2020 Feature Summary
- Reporting
- New Field List (Preview)
- New Model View (Preview)
- Apply all filters is now generally available
- Visual Zoom Slider
- Data point rectangle select extended to Map visual
- Certificate revocation check for web connections
- Paginated Reports Updates
- Crediting total labels for stacked visuals (Sept 2020)
- Analytics
- Anomaly Detection (Preview)
- Q&A now supports partial matching data values
- Data connectivity
- Hive LLAP connector generally available
- New connectors: Actian, Anaplan, Starburst Presto
- Service
- Certified and Promoted reports and apps
- The ‘new look’ of the Power BI service is live
- Visualizations
- New Visualizations
- Zebra BI 4.4
- New Visual by ZoomCharts: Drill Down Map PRO
- xViz Scatter/ Bubble chart
- Editor’s picks
- Developers
- Power BI Automation and APIs
- Fetch more data API 3.4
- Enhanced testing of your developed custom visual
- Coming Soon
- Power BI October 2020 Feature Summary
- Reporting
- Canvas watermarks
- Personalize visuals is now generally available
- Data point rectangle select for Treemap
- Analytics
- Export data from Q&A visual
- Data preparation
- Dynamic M Query Parameters (preview)
- Automatic Table Detection from Excel files
- Automatic Table Detection from JSON files
- Data connectivity
- Broader geographical support for Power Platform Dataflows connector
- MariaDB now supports DirectQuery
- Updated SharePoint Online List Connector
- New connectors
- Service
- Updates to the ‘new look’ experience and release plan
- Mobile
- Power BI for HoloLens 2 (preview)
- Automatic page refresh is now supported on the Windows app
- Support for notch displays
- Embedded
- Power BI Automation and APIs
- Power BI Embedded Analytics
- Visualizations
- Extended admin capability features are now generally available!
- New visuals
- Zebra BI Charts (version 4.3)
- Zebra BI Tables (version 4.3)
- RoadMap by ADWISE (version v1.5.0)
- ZoomCharts (version 1.6)
- Bullet Chart by xViz
- Editor’s picks
- Template Apps
- Simplified installation
- Find template apps from the Power BI Desktop
- DirectQuery support for template apps
- Community
- Power Platform Community Conference
- Data Stories Gallery theme
- Other
- Export data source to PBIDS in Power BI Desktop
- Icon update
- Desktop splash screen dismiss
- Power BI September 2020 Feature Summary
- Analytics
- Smart narratives (preview)
- Q&A now supports arithmetic operations
- Reporting
- Data point rectangle select for additional charts
- Added general visual option to maintain layer order
- Search for a workspace during publish
- Total labels for stacked visuals
- Mobile authoring enhancements
- Bookmark pane is now available in the Mobile layout view
- New options: turn off gridlines and snap to grid.
- Mobile
- Improved navigation tree (iOS and Android)
- Share from Power BI using your favorite apps (iOS and Android)
- Pinch and zoom is now available in all report views – on both phones and tablets (iOS and Android)
- Auto play a slideshow on startup (Windows)
- Service
- New capabilities in lineage view
- Search within lineage view
- Data source impact analysis
- Excel inherits the Power BI dataset’s sensitivity label when using a PivotTable connection
- Analyze in Excel provides Excel file instead of .ODC
- Deployment pipelines is now generally available
- Modeling
- Enhanced Dataset Metadata is now generally available
- Performance improvements to aggregation expressions involving columns of currency data type
- Data connectivity
- CDS connector (preview)
- Azure Databricks
- MariaDB
- Hexagon PPM Smart API
- Other data connectivity updates
- Community
- Spanish language community forum is now available
- Data Stories Gallery theme for October
- Visualizations
- Collage by CloudScope
- Advanced Trellis / Small Multiples Chart by xViz
- Waterfall Chart by xViz
- Editor’s picks
- Template Apps
- Multichannel Attribution Dashboard
- Workplace Analytics Dashboard
- Power BI Desktop August 2020 Feature Summary
- Reporting
- Perspectives support for Personalize visuals (preview)
- Rectangular lasso select for data points (preview)
- Added dynamic formatting support to more visuals
- Analytics
- Direct Query support for Q&A (preview)
- Visualizations
- Linear Gauge by xViz
- Advanced Pie & Donut by xViz
- Ratings visual by TME AG
- Toggle switch by TME AG
- Drill down Pie PRO by ZoomCharts
- ADWISE RoadMap
- Updates to ArcGIS Maps
- Extending Admin capabilities for AppSource visuals
- Template Apps
- Agile CRM Analytics for Dynamics 365
- Data Preparation
- Text/CSV By Example (preview)
- Data connectivity
- Cherwell connector
- Automation Anywhere connector
- Acterys connector
- Power BI Desktop July 2020 Feature Summary
- Reporting
- Gradient legend
- Ability to further customize slicer header text
- Relative time filter is now generally available
- Analytics
- Enhancements to Q&A
- Field synonyms
- Visual renames as suggested synonyms
- Orange underlines for ambiguous terms
- Updates to Q&A pop-out
- Visualizations
- Azure Maps visual (preview)
- Bubble layer
- 3D bar chart layer
- Reference layer
- Custom tile layer
- Real-time traffic overlay
- Updates to Multi-Axis Chart by xViz
- Modeling
- Support for Excel financial functions
- Model view enabled for live connect is now generally available
- Data Preparation
- Global option to disable automatic type detection
- Template Apps
- YouTube Analytics by MAQ Software
- Other
- Launch external tools from Power BI Desktop (preview)
- Power BI Desktop June 2020 Feature Summary
- Reporting
- Enhancements to mobile layout authoring
- New phone emulator
- Updated visualization pane
- Support for overlaid visuals
- Automatic page refresh is now generally available
- Hierarchical slicer is now generally available
- New options for expand/collapse icons
- Icons now scale with font size
- Ability to customize indentation for child items
- Supported with AI visuals
- Modern ribbon is now generally available
- RLS is now supported for Featured Tables in Excel’s Data Types gallery
- Analytics
- AI insights are now generally available
- Visualizations
- Line chart dot formatting options
- Radar chart by MAQ Software
- ValQ for Modern Visual Planning
- Advanced Trellis by xViz
- Updates to Gantt chart by xViz
- Updates to Cards with States by OKViz
- 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
- Power BI Desktop May 2020 Feature Summary
- Reporting
- Curate featured tables for Excel (preview)
- Apply all filters (preview)
- Enhancements to change detection (preview)
- Change detection simulation in Desktop
- Change detection queries in Performance Analyzer
- Drill through button action is now generally available
- Conditionally set the drill through destination
- Conditionally format disabled and enabled state tooltips
- Customize formatting for the disabled state
- Enhancements to page navigation action
- Conditionally set the navigation destination
- Support for shapes and images
- Buttons now support fill images
- Drop shadow support for visuals
- Filter pane migration
- Analytics
- Decomposition tree is now generally available
- Visualizations
- Packed bubble chart by xViz
- Updates to hierarchy filter by xViz
- Power Apps visual is now compatible with all languages supported in Power BI
- Modeling
- List separator and decimal symbol will now default to the standard DAX separators
- Data preparation
- Direct Query on Dataflows
- Web by example now automatically suggests tables by default
- Enhancements to Query Diagnostics: Privacy Level partitions
- Data connectivity
- Witivio connector
- Linkar connector
- Webtrends connector
- Planview ProjectPlace connector
- Shortcuts Business Insights connector
- Vessel Insights connector
- Zoho Creator connector
- Other
- Power BI Desktop April 2020 Feature Summary
- Reporting
- Personalize visuals (preview)
- Change detection for page refresh (preview)
- Relative time filter (preview)
- Rectangular lasso select across visuals
- Conditional formatting for totals and subtotals in table and matrix
- Customize theme dialog is now generally available
- Improved discoverability for conditional formatting
- Analytics
- Direct Query support for AI visuals
- Decomposition tree
- Key influencers
- Decomposition tree now supports tooltips
- Q&A updates
- Suggest questions
- Teach Q&A now supports measure conditions
- Q&A is now supported on Power BI datasets
- Visualizations
- Radar/Polar chart by xViz
- Comicgen by Gramener
- Pareto by sio2Graphs
- Growth Rate Combo Chart by Djeeni
- Smart Filter Pro by OKViz
- New Visualization icons
- Template Apps
- Power Platform Center of Excellence StartKit
- Azure Cognitive Search: analyze logs and metrics
- COVID-19 Apps
- Data preparation
- Enhancements to Query Diagnostics
- Data connectivity
- CDM Folder view for Azure Data Lake Storage Gen2
- Other
- New instructor-led training
- Announcing the New Personalize Visuals Experience for Power BI Reports
- Power BI Desktop March 2020 Feature Summary
- Reporting
- New action types for buttons
- Page navigation
- Drill through (preview)
- Multi-column sort for tables
- Dual axis for line chart
- Filter pane search
- Updates to decomposition tree
- Bars per level formatting option
- Updates to behavior of data bar length
- New ribbon is now on by default
- Modeling
- New DAX function: COALESCE
- Visualizations
- Waterfall chart by xViz
- Updates to ArcGIS Maps
- New connection options
- Enterprise support is now generally available
- Support for multiple reference layers
- New table of contents
- Template Apps
- Azure DevOps dashboard by Data Maru
- TeamsPower by Encamina
- Data preparation
- Query diagnostics is now generally available
- Data connectivity
- Hive LLAP connector
- Cognite connector
- Other
- Enhanced dataset metadata (preview)
- Using default system credentials for web proxy
- New instructor-led administrator in a day training
- Power BI Desktop February 2020 Feature Summary
- Dataset management
- Incremental refresh is now generally available
- Reporting
- Hierarchical slicer (preview)
- Updates to the new ribbon (preview)
- Title bar updates
- Keytips
- Accessibility
- Modeling
- New DAX Functions
- FirstNonBlankValue
- LastNonBlankValue
- Visualizations
- Funnel and pyramid chart by xViz
- OEE Dashboard by 3AG Systems
- Organization chart by MAQ Software
- PI VIZpack by PQ Systems
- Histogram
- Individuals control chart
- Individuals and moving range control chart
- Multi-group individuals chart
- X-bar control chart
- X-bar and range control chart
- P-chart
- U-chart
- Updates to Zebra BI tables and charts
- Template Apps
- Microsoft 365 usage analytics
- NFL analytics by P3
- Acterys for Quickbooks, Xero & WorkflowMax
- Data preparation
- Non-admin support for query diagnostics
- Data connectivity
- MicroStrategy connector is now generally available
- FHIR connector is now generally available
- Factset connector
- TIBCO connector
- Jamf Pro connector
- Asana connector
- Power BI Desktop December 2019 Feature Summary
- Reporting
- Customize current theme (preview)
- Export current theme
- 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 (preview)
- Analytics
- Load more for Analyze insights
- New DAX function: Quarter
- Visualizations
- Personalization of the visualization pane is now generally available
- New xViz visuals
- Hierarchy tree
- Bullet chart
- Parallel Coordinates
- Gantt chart
- New Zebra BI visuals
- Zebra BI charts
- Zebra BI tables
- Drill Down Combo Bar PRO by ZoomCharts
- Annotated Bar by Queryon
- Tachometer 5 Ranges
- ValQ licensing updates
- Data connectivity
- Azure Data Lake Storage Gen2 connector is now generally available
- Power Platform Dataflows connector
- PostgreSQL connector now includes the Npgsql provider
- AtScale connector is now generally available
- 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 Service
- Power BI Desktop November 2019 Feature Summary
- Other
- Reporting
- Decomposition tree visual (preview)
- Analytics
- Conditionally format button formatting
- Visualizations
- ArcGIS Maps for Power BI update
- New xViz visuals
- Advanced Gauge
- Hierarchical Filter
- ZoomCharts Drill-Down Waterfall Visual
- Financial Reporting Matrix by Profitbase
- Distribution
- Tree
- Data connectivity
- LinkedIn Sales Navigator connector
- Edit SAP variables experience now generally available
- Vena connector
- SiteImprove connector
- Product Insights connector
- Web By Example connector – support for extracting links
- Data Preparation
- AI functions in Power Query (Preview)
- Template apps
- LinkedIn Sales Navigator for Sales Operations
- Power BI Desktop October 2019 Feature Summary
- Reporting
- Automatic page refresh for DirectQuery (preview)
- Analytics
- The new Q&A visual
- Improved user experience for Q&A
- Natural Language improvements for Q&A
- Q&A tooling (Preview)
- Support for SSAS and Azure AS including RLS
- Visualizations
- PowerApps visual is now included by default
- New xViz visuals
- Hierarchical Variance Table
- Linear Gauge
- Tag Cloud
- Data connectivity
- Sagra Emigo connector generally available
- Azure Cost Management connector updated
- New Workplace Analytics connector
- Data Preparation
- Query diagnostics
- Data profiling enhancements
- Template Apps
- Other
- New file format: .pbids
- Performance improvements for modeling operations
- Power BI Desktop September 2019 Feature Summary
- Reporting
- Color and text classes in themes
- New default themes
- Personalized visualization pane improvements (preview)
- Unpin default visuals
- About info for visuals
- Analytics
- Custom format strings
- Conditional formatting for more visual formatting options
- Alt text
- Border color
- Gauge colors
- Drill through discoverability improvement
- New DAX expressions: REMOVEFILTERS and CONVERT
- Visualizations
- PowerApps visual now generally available
- Data connectivity
- PostgreSQL connector enhancements:
- Support for folding over Native Database queries
- DirectQuery support generally available
- Data preparation
- Copy to clipboard from data profiling
- Template apps
- Other
- Performance improvements for multi-dimensional models
- Query performance improvements for DirectQuery models
- Power BI Desktop August 2019 Feature Summary
- Reporting
- Grouping visuals
- Filter pane auto-update
- Icon style picker for Icons conditional formatting
- Conditional formatting warnings
- Analytics
- Key influencers improvements
- Measure support
- General availability
- Visualizations
- xViz visualization suite by Visual BI
- Multiple Axis chart
- Marimekko chart
- Variance chart
- Horizon chart
- Data connectivity
- Support for SAP HANA HDI Containers
- Edit SAP variables in Power BI Service (preview)
- PostgreSQL DirectQuery (beta)
- MarkLogic connector now generally available
- New Power Platform category within Get Data
- Template apps
- Facebook Pages – Basic Analytics
- Power BI Desktop July 2019 Feature Summary
- Reporting
- Icon sets for table and matrix
- Percent support for conditional formatting by rules
- New filter pane is now generally available
- Data colors support when using play axis on scatter charts
- Performance improves when using relative date and dropdown slicers
- Analytics
- Counts for Key influencers visual (preview)
- Aggregations improvements
- RLS support
- Aggregations now generally available
- Visualizations
- PowerApps visual is now certified
- InfoCard
- Sunburst by MAQ Software
- Flying Brick visual
- Data connectivity
- Azure Data Lake Storage Gen2 connector (beta)
- Azure Cosmos DB Connector is now generally available
- Dynamics 365 Customer Insights connector
- Data preparation
- New Transform: Split column by positions
- Power BI Desktop June 2019 Feature Summary
- Reporting
- Updated pane design
- Visual level filters for slicers
- Sorting for the performance analyzer pane
- Conditional formatting updates for formatting options
- Visual background and title colors
- Card colors
- Gauge fill
- Visual header tooltips
- Table & matrix total label customization
- Sync slicer support for hierarchy slicer
- Consistent font sizes across visuals
- Analytics
- Key Influencers visual updates (preview)
- Key Influencers with Live Connect to Power BI datasets
- Key Influencers accessibility
- Support for Cloud RLS
- Manage aggregations dialog accessibility
- Modeling
- New DAX comparison operator: ==
- Visualization
- Personalized visualization pane (preview)
- SCADAvis.io Synoptic Visual
- PAFnow Process Mining
- DualCard
- Data connectivity
- Connect to shared and certified datasets
- Common Data Service connector is now generally available
- Azure Data Explorer connector is now generally available
- Enhancements to the Cosmos DB connector
- Entersoft
- Data preparation
- Improvements to M Intellisense
- Power BI Desktop May 2019 Feature Summary
- Reporting
- Performance analyzer pane
- Filter pane improvements (preview)
- Sorting filter cards
- Theming support
- 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
- Visualizations
- ArcGIS maps for Power BI updates
- Mapbox updates
- ValQ – Modern Digital Planning
- Advanced Graph Visual
- Craydec Control Charts
- Walkers Animated Pictogram
- Treemap Bar Chart by MAQ Software
- Data connectivity
- Essbase connector: Support for Native Query (MDX).
- Intune Data Warehouse connector
- Tenforce connector
- Roamler connector
- Other
- Automatic query cancellation for Power BI Desktop
- Power BI Desktop April 2019 Feature Summary
- Reporting
- Filter pane improvements
- Support for full filter pane editing
- Ability to rename filters
- Filter pane scales with the report page
- Restrict ability to change filter type
- Improved filter pane accessibility
- Conditional formatting for visual titles
- Conditional formatting for web URL actions for buttons, shapes, and images
- Analytics
- Drillthrough across reports
- Key Influencers visual now supports continuous analysis for numeric targets
- Python support is now generally available
- Partial synonym matching for terms in Q&A
- Modeling
- New DAX function – ALLCROSSFILTERED
- Visualizations
- Data connectivity
- Power BI dataflows connector now generally available
- Oracle Essbase connector now supports DirectQuery and is generally available
- PDF connector now generally available
- Web By Example connector – automatic table inference
- Intersystems IRIS connector
- Indexima connector
- Luminis InformationGrid
- Solver BI360
- Paxata
- Data preparation
- Data Profiling enhancements and general availability
- Fuzzy merge performance enhancements & general availability
- M Intellisense supported in formula bar and custom column dialog & is generally available
- Other
- Power BI Paginated Report Builder
- Power BI Desktop March 2019 Feature Summary
- 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 & images
- Filter pane improvement
- Page alignment options
- Selection pane improvements
- Formatting updates for maps
- Adjust map points to a smaller size
- Ability to add zoom buttons
- Accessible visual interaction
- Analytics
- Q&A recommendations for improving results
- Show dates as a hierarchy now generally available
- Modelling
- New modelling view now generally available
- New DAX functions
- Custom visuals
- New certified custom visuals setting in admin portal
- Craydec Regression Chart
- Power Slicer
- Data connectivity
- PDF connector now supports tables spanning multiple pages (preview)
- Intelligent Plant’s Industrial App Store connector
- Azure Cost Management connector
- Power BI Desktop February 2019 Feature Summary
- Reporting
- Updates to the new filter pane (preview)
- More filter pane formatting
- Accessibility improvements for the new filtering experience
- Cross-highlight on a single point in line charts
- Word wrap on titles
- Update default visual interaction to cross-filter
- Rounded corners for visual borders
- Analytics
- Key Influencers visual (preview)
- Insights questions in Q&A
- Auto-generated suggested questions for Q&A explorer
- Improved Python & R script editor
- Custom visuals
- Additional purchases for custom visuals
- Advanced Donut Visual
- Advanced Combo Visual
- Advanced TimeSeries Visual
- Advanced Network Visualization
- 3AG Systems – Line chart with absolute variance
- Summary Table
- KPImg
- Ultimate KPI Card
- Violin Plot
- Data connectivity
- Microsoft Graph Security
- Guidanz’ BI Connector for OBIEE
- MarkLogic
- Kronos Workforce Dimensions
- SurveyMonkey
- Qubole Presto
- Quick Base
- Sagra Emigo
- Other
- Improved Live connect & Direct Query error messages
- Power BI Desktop December 2018 Feature Summary
- Here’s the complete list of December updates:
- Reporting
- Smart guides for aligning objects on a page
- ArcGIS Maps for Power BI updates
- Fields list accessibility support
- Set tab order for objects on a page
- Tooltips for button visuals
- Updated icons for “Visual interactions”
- Analytics
- Live connect support for Q&A (preview)
- Modeling
- DAX formula bar updates
- Data view accessibility support
- Custom visuals
- BIpm: Interactive directed flow graph
- Data connectivity
- AtScale connector (Beta)
- Oracle Essbase connector (Beta)
- Data preparation
- Fuzzy merge – support for Top N best matches
- Other
- High contrast support for all panes and report footer
- Updated keyboard shortcuts dialog
- Power BI Desktop November 2018 Feature Summary
- Reporting
- Expand & collapse matrix row headers
- Copy & paste between Desktop files
- Updated filtering experience (preview)
- Report accessibility improvements
- Analytics
- Color saturation on visuals upgraded to use conditional formatting
- Related questions in the Q&A explorer
- Modeling
- New modeling view (preview)
- Composite models now generally available
- Modeling accessibility improvements
- New DAX functions
- Custom visuals
- Calendar by MAQ Software
- Ratings by MAQ Software
- Hourglass Chart by MAQ Software
- Forecast Using Multiple Models by MAQ Software
- Pie Charts Tree
- Data connectivity
- Azure DevOps Server connector
- PDF Connector support for Start Page and End Page parameters
- Improved Azure Consumption Insights connector
- Power BI Desktop October 2018 Feature Summary
- Reporting
- Search in filter cards
- Improved accessible authoring experiences
- Performance improvements for ArcGIS Map
- Modeling
- Analytics
- Composite models & Aggregation support in the Power BI service (preview)
- Explain the increase for non-additive measures
- Custom visuals
- Mapbox updates – 3D extrusion on fill maps & more
- Various bar & column chart visuals by Akvelon
- 3AG Systems – Column chart with small multiples
- 3AG Systems – Bar chart with absolute variance
- 3AG Systems – Column chart with relative variance
- Data connectivity
- Web By Example connector is now generally available
- SAP BW Connector implementation v2 is now generally available
- SAP BW Message Server Connector is now generally available
- Vertica connector is now generally available
- Dynamics NAV and Dynamics 365 Business Central connectors are now generally available
- New Dynamics 365 Business Central On-premises connector
- Data preparation
- Data Profiling in Query Editor (preview)
- Fuzzy Matching options for Merge Queries (preview)
- Other
- Control export data options for your reports
- Transport layer security settings
- Power BI Desktop September 2018 Feature Summary
- Reporting
- Dot plot layout support in scatter charts
- Copy value and selection from table & matrix
- Built-in report theme options
- Report page tooltips generally available & Card support
- Accessibility improvements for analytics and formatting pane support
- Analytics
- Aggregations (preview)
- Q&A support for RLS
- Custom visuals
- Horizon Chart
- Text Enhancer by MAQ Software
- Advance Card
- Multi KPI
- Custom visual API updates
- Data connectivity
- PDF file connector (preview)
- SAP BW connector – support for measure properties
- Dataflows connector (beta)
- Data preparation
- M intellisense (preview)
- Add Column From Examples – support for text padding
- Power BI Desktop August 2018 Feature Summary
- Reporting
- Print reports through Export to PDF
- Create bookmark groups
- Theming generally available
- Slicer restatement
- Analytics
- Conditional formatting by values
- Python integration (preview)
- Q&A improvements
- Q&A in Power BI Desktop generally available
- Better matching experience for Power BI Desktop and Power BI Premium
- Modeling
- Data categories for measures
- Statistical DAX functions
- Custom visuals
- 3AG Systems – Column Chart with Variance
- Scatter Chart by Akvelon
- Small Multiples Line Chart
- Add Natural Language Summaries for BI
- Pivot Slicer
- Data connectivity
- Spark connector generally available
- Power BI Desktop July 2018 Feature Summary
- Reporting
- New visual header with more flexibility and formatting
- Wallpaper formatting
- Theming update – more visual and page control (preview)
- Tooltips for table and matrix
- Turn tooltips off for visuals
- Slicer accessibility
- Formatting pane improvements
- Stepped line support for line and combo charts
- Turn off combo chart data labels for individual series
- Sorting experience improvement
- Analytics
- Distribution factor insights
- Custom visuals
- Power BI certified category
- Disabling specific organizational visual
- Visio custom visual generally available
- Mapbox custom visual generally available
- DataText Box custom visual
- China Scatter Map custom visual
- Data Connectivity
- IBM DB2 DirectQuery connector (preview)
- Improvements to Web By Example connector
- Support for importing multiple custom tables
- Automatic completions for specifying sample values
- Exposure of attribute selectors in HTML.Table function
- SAP HANA – Default values for variables in Variable Input experience
- Power BI Desktop June 2018 Feature Summary
- 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
- Organization Chart
- China Heat Map
- Modeling
- Filtering and sorting in data view
- Improved locale formatting
- Data connectivity
- SAP BusinessWarehouse connector improvements
- New driver and improved performance
- 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
- Power BI Desktop May 2018 Feature Summary
- 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
- Power BI Premium
- Incremental refresh (preview)
- Custom visuals
- Collage by CloudScope
- Chinese Color Map
- 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
- Power BI Desktop April 2018 Feature Summary
- Reporting
- Q&A Explorer (preview)
- 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
- Overview by CloudScope
- Icon Map by Altius
- Hexbin Scatterplot
- Data connectivity
- Adobe Analytics connector now generally available
- SAP HANA connector improvement: Port selection
- Dynamics 365 Business Central connector
- Power BI Desktop March 2018 Feature Summary
- Reporting
- Report page tooltips (preview)
- Bookmarking is now generally available
- Display units and precision control for table & matrix columns
- Turn off the visual header in reading mode for a report
- Improved default visual placement
- Custom visuals
- Mapbox
- User List by CloudScope
- Timeline by CloudScope
- KPI Chart by Akvelon
- R DataTable
- Outliers Detection
- Data Insights by MAQ Software
- Dumbbell Chart by MAQ Software
- Clustering using OPTICS by MAQ Software
- Data connectivity
- SAP HANA connector enhancements
- DirectQuery multidimensional support is now generally available
- SSL certificate validation support
- SAP BW DirectQuery is now generally available
- Azure Analysis Services connector is now generally available
- Other
- Improved error reporting
- View previous errors you’ve encountered
- Power BI Desktop February 2018 Feature Summary
- Reporting
- Multi-select data points across multiple charts
- Sync slicers across multiple pages of your report
- Numeric range slicer improvement – whole number snapping (preview)
- Faster geocoding for Bing maps (web preview)
- Overflow data labels for bar and column charts
- Search the formatting and analytics pane
- Analytics
- Mark custom date table
- Quick measures are now generally available
- UTCNOW() and UTCTODAY()
- Custom visuals
- Organizational custom visuals (preview)
- Network Visualization and Filter
- Slope Chart by MAQ Software
- Filter by List
- as Timeline
- as T-Accounts
- 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 up coming Power BI service feature
- Consulting Services quick link
- Power BI Desktop January 2018 Feature Summary
- Reporting
- Show and hide pages
- Control data label background color for Cartesian and maps visuals
- Increase area used for axis labels in charts
- Bar/column padding control
- Show dates as a hierarchy (preview)
- Add an anchor date for relative date slicer
- Top N selection in Q&A
- Analytics
- Correlation coefficient quick measure
- Custom Visuals
- PowerApps
- TreeViz
- Funnel with Source by MAQ Software
- Box and Whisker chart by MAQ Software
- Agility Planning Matrix Light
- Image Grid
- Gantt Chart by MAQ Software
- Data connectivity
- Support for Azure Active Directory authentication for Azure SQL Database & Data Warehouse connectors
- Other
- Advanced language settings for the Windows store app
- Happy New Year from Power BI Desktop
- Power BI Desktop December 2017 Feature Summary
- Reporting
- Q&A for report creation (preview)
- Cross-highlighting for bookmarks
- More bookmark flexibility
- Field properties pane and field descriptions
- Scatter visual from x- & y-axis groupings
- High density sampling for maps based on latitude and longitude
- Responsive slicers
- New custom visuals
- Card Browser
- Table Heatmap
- Data Image by CloudScope
- Power KPI Matrix
- Text Filter
- ChartAccent – LineChart
- ChartAccent – BarChart
- Analytics
- Drill filters other visuals
- Data connectivity
- Adobe Analytics connector (preview)
- HDInsight Interactive Query connector
- Data.World connector
- SAP BW connector improvements:
- Support for connecting to an SAP BW Message Server
- Support for Windows Authentication
- IBM Netezza connector is now generally available
- Power BI Desktop November 2017 Feature Summary
- Reporting
- Rule-based conditional formatting for table and matrix
- Cell alignment for table and matrix
- 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
- Image Timeline
- Social network graph
- Venn diagram by MAQ Software
- HTML viewer
- Analytics
- Cell-level formatting for multidimensional AS models for multi-row card
- Data connectivity
- Impala connector – support for Windows Authentication
- Query editing
- Add Column From Examples improvements
- Power BI Desktop October 2017 Feature Summary
- Reporting
- Bookmarking (preview)
- Selection pane and visual display controls
- Bookmark links for shapes and images (preview)
- Spotlight
- Scatter & bubble markers
- Increase the number of data points shown in scatter charts
- Analytics
- Quick measures for SSAS live connections
- Sales from new customers quick measure
- Cell-level formatting for multidimensional AS models
- Data connectivity
- Vertica connector (beta)
- SAP BW connector: support for additional member properties
- Other
- Power BI Desktop in the Windows Store
- Improved access to help content
- Power BI Desktop September 2017 Feature Summary
- Reporting
- Drillthrough to another report page
- Explain the increase/decrease insights (preview)
- Ribbon chart
- Theming preview update – chart style controls
- Accessibility improvements
- Accessible See data
- Keyboard shortcut helper dialog
- High density scatter chart sampling
- Cartesian gridline style control
- New community visuals
- Visio visual (preview)
- Calendar by Tallan
- Enlighten Aquarium
- Impact Bubble Chart
- Data connectivity
- Azure Consumption Insights connector
- Improvements to the Dynamics 365 for Financials connector
- Power BI Desktop August 2017 Feature Summary
- Reporting
- Show values on rows for matrix
- Color scales on font colors for table & 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
- What if parameters
- New scatter chart analytics features
- Symmetry shading
- Ratio line
- New quick measure: weighted average
- Data connectivity
- Live connect to the Power BI service is generally available
- Google BigQuery connector (beta)
- Power BI Desktop July 2017 Feature Summary
- Reporting
- 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
- Quick measures from the community
- Star rating
- Concatenated list of values
- Bidirectional cross filtering for DirectQuery is now generally available
- Data connectivity
- Snowflake connector general availability
- Query editing
- Add Column from Examples enhancements
- Power BI Desktop June 2017 Feature Summary
- Reporting
- Data bars for new table & matrix (preview)
- Markers on line, area, & combo charts
- Accessible reports
- Consume Power BI reports with keyboard navigation and screen reader support
- Create accessible reports
- Visuals font family setting
- Horizontal Image Slicer
- Combo chart formatting updates
- Force zeros to align between the two axes
- Shade area of the line
- Bing maps improvements
- Map themes
- Improved geo hierarchy experience
- High density line sampling
- 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 (beta)
- IBM Netezza connector (beta)
- Query editing
- “Add Column from Examples” enhancements
- Power BI Desktop May 2017 Feature Summary
- Report view
- Relative date slicer (preview)
- New table visual (preview)
- Combo chart data label enhancements
- More URL support in table & matrix
- Mailto links in textbox
- Analytics
- Report level measures for live connections to Analysis Services tabular models & Power BI service datasets
- 2 new quick measures (preview): Total for category & Rolling average
- Bin by count
- Data connectivity
- New connector: Dynamics 365 for Customer Insights
- Combine files – ability to reference “First File” as example
- Query editing
- Two new transforms:
- Extract text before/after/between delimiters
- Unpivot only selected columns
- Connecting to datasets in the Power BI service from Desktop
- Quick Measures Preview
- Power BI Desktop April 2017 Feature Summary
- Report view
- Rename axis titles
- New matrix visual enhancements: column sorting, column resizing, and word wrapping (preview)
- Analytics
- Quick measures and show value as (preview)
- Q&A in Spanish (preview)
- Data connectivity
- Connect to datasets in the Power BI service (preview)
- Redshift Connector: beta support & publish to Power BI service
- SAP HANA & BW Connectors: enhancements to parameter input experience
- Query editing
- Add column by example
- Split column (by delimiter/number of characters) into rows
- Group by – basic mode
- Go to column
- Power BI Community Report Theme Gallery
- Power BI Desktop March 2017 Feature Summary
- Report view
- Report theming preview
- New matrix visual preview
- Textbox font color
- Numeric range slicer preview
- Percent of total on pie and donut chart data labels
- Cross-highlight using multiple series
- Analytics
- Clustering is now generally available
- Data connectivity
- New Connector: Azure Analysis Services
- Azure Data Lake Store connector is now generally available
- DB2 connector: option to specify package collection
- Combine binaries: ability to specify sample file to use
- Query editing
- Split column by delimiter: automatic detection of delimiter character
- Power BI Desktop February 2017 Feature Summary
- 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
- 2 new Quick Calcs: Percent of row total & percent of column total
- Data connectivity
- ODBC and OLE DB connectors: support for selecting related tables
- Enhanced Folder connector: support for combining binaries from the Preview dialog
- Unified text & CSV connectors
- PowerApps Common Data Service connector
- Query editing improvements
- Specify the desired column type and locale in column headers type menus
- Easily insert steps in existing queries
- Other
- Solution Templates and Partner Showcase quick access
- Power BI Desktop January 2017 Feature Summary
- Report View
- Table header word wrap
- Table & matrix conditional formatting improvement – blank formatting
- New aggregations for string and dateTime columns
- Phone reports GA
- Data Connectivity
- Visual Studio Team Services connector
- Enhanced SQL Server connector – support for SQL Failover option
- Query Editing Improvements
- New transform: extract values from a nested list
- Power BI Desktop – 2016 Year in Review
- Announcing the Preview of Download Power BI Desktop files from the web
- Power BI Desktop November 2016 Feature Summary
- Report View
- Dropdown slicer
- Hierarchical axis
- Matrix conditional formatting
- Table & matrix column formatting
- Axis label and title color control
- Phone reports scrolling
- Analytics
- Clustering (preview)
- Forecasting – now available on Power BI on the web
- Groups – ribbon entry point
- Data Connectors
- Spark DirectQuery
- OData connector – folding of expand record operations
- Enhanced “combine binaries” experience
- Azure Analysis Services
- Web connector updates
- Query Editing Improvements
- Improved “function authoring” experience
- Support for percentage data type
- Maximize/Restore buttons in the Navigator and Query Dependencies dialogs
- Power BI Desktop October 2016 Feature Summary
- Report View
- 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
- Microsoft Dynamics 365 for Financials
- OLEDB
- Mixpanel
- Query Editing Improvements
- Support for table parameters in “Invoke Function” dialog
- Other Improvements
- Diagnostic information in the “About” dialog
- August Power BI Desktop Update: Updated Drill experience
- Power BI Desktop August 2016 Feature Summary
- Report View
- Drill on line chart
- Continuous axis for Date axis
- General availability of inline hierarchies
- Predefined matrix styles
- Reorder fields in charts and tooltips
- Color formatting for KPI visual
- Analytics
- Analytics pane
- Dynamic reference lines
- Data Connectors
- Impala DirectQuery support
- Snowflake connector
- Improved Web connector – Web page previews
- General availability of SAP BW connector
- Query Editing Improvements
- Option to Merge/Append as New Query
- Other Improvements
- Auto-recover Desktop files
