Power BI

Updates
Chris Wagner & Helen Wall
Power BI Updates – November 2022 Click here for Microsoft's full update details

Report and Visuals Modeling

• Dynamic Slicers using Field Parameters • Optimize Ribbon!
• Un-share and un-synchronize axes for • Control when visuals refresh
small multiples • Predefine setting combinations to meet reporting needs
• Customize Azure map labels • Launch Performance Analyzer
• New color theme (GitHub sample!) • New DAX functions EVALUATEANDLOG, TOCSV, TOJSON
Les Says: Make sure you
enable this and file tickets
Service and Mobile if you still have issues
before GA.
Service Metrics WebView2
• New way to upload Excel and • Show the same • WebView2 will soon be necessary for
Power BI files metric on multiple Power BI Desktop
• Subscribe to report with filters scorecards
applied!!!!

Data Connectors
• Databricks now supports gracefully • Spigit / Projectplace / Planview Enterprise One – PRM (Update)
cancelling queries • Planview Enterprise One – CTM (Update)
• Dremio Cloud (Update) • SumTotal (Update)
• Kognitwin (Update)
 Power BI Updates – October 2022 Click here for Microsoft's full update details
Les Says: Make sure the
value is right. AI ain’t
Report and Visuals always that freaken smart.

• Reverse stack order for stacked column charts Modeling

• Rollups for Metrics • Quick measure suggestions (Preview)
• API for admins to access scorecards • Relationships editing properties pane (Preview)
• DAX formula bar support in Model view
Data God Pick

Service and Mobile Les Says: Did you WANT

Service your data to leave your
freaken tenant? Huh?
• Guest users can create email subscriptions
Well, ok then. Your call.
• Tenant email subscriptions available to external users
• Deployment pipeline history and Azure DevOps extension

Data Connectors
• Eduframe Reporting PBI Admin Says: Enable the
• Socialbakers Metrics appropriate people in your
• Tenant settings for Power BI Datamarts organization to take
advantage of PBI Datamarts.
Power BI Updates – September 2022 Click here for Microsoft's full update details

Report and Visuals Modeling

• Hierarchical axis by default • Translations support for Composite models
• Improved display name for • Paginated reports data preview
summarized fields
• Conditional formatting for data
labels

Service and Mobile

Service Mobile Embedded
• Cross-tenant Dataset sharing • Power BI fonts (iOS and • Power BI component for
• Auto-generate reports on existing Android) Vue.js
Datasets • Windows app: WebView2 • Export paginated reports using
• Discoverability for B2B content upgraded browsing Dataset as data source

Data Connectors
• Profisee – New
• Dremio – Update
• Starburst Enterprise – Update
 Power BI Updates – August 2022 Click here for Microsoft's full update details

Report and Visuals Modeling

• Conditional formatting for data labels • DAX Editor Improvements
• Metric Visual

Service and Mobile

Service Mobile
• Buy Visuals in App Store! • Text box visuals are now supported
• Follow Metrics from mobile

Data Connectors
• MariaDB (Update) • Certified connectors in Dataflows and Datamarts
• Google Sheets (Update)
Power BI Updates – July 2022 Click here for Microsoft's full update details

Report and Visuals Modeling

• Error Bar Improvements & GA • New DAX function: NETWORKDAYS
• Composite models on Power BI • Multi-role RLS in composite models
Datasets & Analysis Services • Query performance improvement
• Filled Map for Azure Maps Visual!
• Metric Visuals Updates

Service and Mobile

Service Mobile
• Data Hub improvements – data • Data – In – SPAAAAAAACE!!!!
preview & export • Track metrics with multiple milestones &
• Accessibility enhancements for targets
embedded reports

Data Connectors
• Connect to Datamarts • FactSet RMS – New
• Display Name – Dataverse • Funnel - New
• Databricks Update
 Power BI Updates – June 2022 Click here for Microsoft's full update details

Report and Visuals

• New Format Pane (Generally available) • Capabilities.json file for Modeling
• Updates to Error Bars (Preview) defining visual permissions • Composite models for SQL
• Information protection updates • Improving custom visual Server Analysis Services
• Table navigation improvements load time
• Canvas zoom in Teams

Service and Mobile

Service Embedded Analytics
• Data Storytelling • Hierarchy slicers (JS API's)
• Data hub • Paginated reports with SSO data
• Metrics updates • JS SDK Paginated Reports parameters
• DirectQuery for Power BI Datasets

Data Connectors
• Datamarts! (Preview) • Hexagon PPM Smart API (Update) • Anaplan (Update)
• Databricks (New) • Snowflake (Update) • Azure Databricks (Update)
• SingleStore (New) • Vessel Insight (Update) • Dremio Cloud (Update)
• Workplace Analytics/Viva Insights (Update) • FactSet Analytics (Update)
Power BI Updates – May 2022 Click here for Microsoft's full update details

Report and Visuals

• Field parameters – Preview! • Charticulator is now GA!!
• Composite model Management!! • Error bars for combo charts – Preview
• Format pane updates - Preview • ArcGIS visual updates
• Canvas Zoom • Dumbbell Bar Chart (Nova Silva)
• Data point rectangular selection • Drill Down Map PRO (ZoomCharts)

Service and Mobile

Service Mobile
• File downloads API • Goal updates in activity feed
• Datasets hub improvements • Windows app – new minimum OS requirement
• Deprecation of dashboard features

Data Connectors
• Azure DataBricks – Update • FactSet RMS – New
• Denodo - Update • Funnel - New
• Google Sheets – Update!
• Autodesk Construction Cloud - Update
 Power BI Updates – April 2022 Click here for Microsoft's full update details

Report and Visuals

• New Format Pane Updates (Preview) Modeling
• Tooltips for drill actions in matrix, line, and area charts! • Dynamic query parameters now
• Error bars for clustered and bar charts generally available
• Bookmark navigator displays last selected bookmark per group • Updates to required permissions
• PowerGantt Chart by Nova Silva for composition model datasets

Service and Mobile

Service Mobile
• Updates for Power BI Goals with bulk • Visual interaction support in formatting options
updates, as well as sharing and access • Goals push notifications
banner

Data Connectors
• Autodesk Construction Cloud (New)
• Digital Construction Works Insights (Update)
• Dremio, Dremio Cloud (Update)
Power BI Updates – March 2022 Click here for Microsoft's full update details

Report and Visuals

• Dynamic Format Strings! • Improved slicer accessibility • Charticulator NOW
• Error Bars! • graphomate 2021.4 CERTIFIED
• Multi-Row card selection (take 2) • Updated sensitivity labels • Create reports from
• Quick Create from SharePoint • Azure map visual updates SharePoint documents

Service and Mobile

Service Embedded Analytics
• Datasets hub improvements • Improved method for multi-tenancy deployment
• Goals Enhancements • Paginated reports – support for SSO data sources
• Custom Statuses
• Notifications

Data Connectors
• Anaplan – Update
• Bloomberg Enterprise Data & Analytics - Update
• FactSet Analytics – Update
• AssembleViews - Update
• BitSight - New
 Power BI Updates – February 2022 Click here for Microsoft's full update details

Report and Visuals

• New Format Pane (Preview) Modeling
• Plotly.js (Akvelon) • Dynamic query parameters now supported in SQL Server
• HTML Text Styler 2.0 + other data sources! (Preview)
• Multiple Sparklines (Excelnaccess.com)
• Financial Reporting Matrix (Profitbase)

Service and Mobile

Embedded Service Mobile
• Power BI Dataset as data • Download *.pbix improvements • Mobile-optimized report
source for paginated reports • Deployment pipeline enhancements authoring enhancements
• New Dataset permission API's • Updated Goals (notifications, multiple • Dark mode (Windows app)
• Delete Dashboard API owners, personal workspaces) • App new look available

Data Connectors
• Amazon OpenSearch Service • Azure Databricks - Update
• OpenSearch Project • BQE Core – Update
• Data Construction Works • MicroStrategy – Update
Insight • Starburst Enterprise – Update
January 2022: The Microsoft Power BI team
is taking a much-deserved break this month!
 Power BI Updates – December 2021 Click here for Microsoft's full update details

Report and Visuals Modeling

• Sparklines! (Preview) • Visualize data with
• Format pane updates (Preview) PowerApps/Dynamics 365 (Preview)
• Zebra BI Cards 1.0
• Drill Down Combo Bar PRO
(ZoomCharts)

Service and Mobile

Embedded Service Mobile
• Improved matrix • Hybrid Tables (Premium) • New report default view
performance (4.1 API) • Email subscription access via Admin API • Recommended Content
• Dataset as data source for • Sharing links include updates to report support hints
paginated reports changes • Support for Goals

Data Connectors
• Azure Data Explore – Update • Starburst Enterprise - Update
• FHIR – Update • TIBCO Data Virtualization (Generally
• Dremio Software – Update Available)
• BQE Core – Update
• Exasol – Update
Power BI Updates – November 2021 Click here for Microsoft's full update details

Report and Visuals

• Page and Bookmark Navigators • Scorecard visual • New format pane (Preview)
• New Formatting Options • AppSource find report files • Tenant-level Bing Maps
• Sort legend • Drill Down map PRO feature switch update
• Bold, italic, and underline text formats • Inforiver standard edition
• Text box super/subscripts, bullet lists • Lipstick Bar Chart

Service and Mobile Service Embedded Analytics

Mobile • Datasets hub improvements • Power BI Embedded Gen2
• Updated report filters • Azure Lockbox Support • Control embed token
• QR codes with URL • Power BI Goals (goal level expiry
parameters permissions, Power Automate • Embedding support for
Integration, formatting) paginated report visuals

Data Connectors

• Azure Synapse Analytics (Preview) • Google BigQuery (Update)

• Google Sheets (Preview) • Cognite Data Fusion (Update)
• Azure Cosmos DB V2 (Preview) • Dremio Cloud (Update)
• Delta Sharing (Preview)
 Power BI Updates – October 2021 Click here for Microsoft's full update details

Report and Visuals Modeling

• Azure Maps Visual – Heat Map Layer • Switch Functions- Performance • Lollipop Bar Chart – Nova
• Proxy Models – Individual Table(s) Improvements Silva
linking • Bitwise Functions • Drill Down TimeSeries
• BITLSHIFT/BITRSHIFT Pro - ZoomCharts
• BITAND/BITOR/BITXOR

Service and Mobile Service Developers

Embedded • Premium Gen2 – GA!!!! • Modern Tooltips
• Object Level Security (OLS) • Auto Install Power BI in • Modern Dialog
is now GA Teams
• Adjust Zoom levels • API – Who has access to what Paginated Reports
• Export API Update • Deployment Pipelines APIs- GA • ODBC Connector - GA

Data Connectors
• Azure Databricks – UPDATE!!!! • Amazon Athena – GA
• Amazon Redshift - Update • SIS-CC-SDMX – New
• Dataverse - Update • SumTotal - Update
• Azure Cosmos DB V2 - New • Usercube - New
Power BI Updates – September 2021 Click here for Microsoft's full update details

Report and Visuals

• PAFnow Process Mining flowchart • New button formatting • CALCULATE aggregate
• Drill Down Network PRO • Waterfall charts toggle totals functions
• Annotated Bar • Line chart series labels • XIRR new parameters
• Graphomate pictograms • Sensitivity label for templates

Service and Mobile Service Paginated Reports

Mobile • Goals: Automated status rules • New version of Power
• Goals Available and improved filtering BI Report Builder
• Content Exploration • API’s to Determine Artifacts
• Request Access to reports • Service Principals support for
read-only Admin API’s

Data Connectors

• Power BI Connector in Power • Bloomberg Enterprise Data and Analytics (Update)

Automate (New) • DataVirtuality (Update)
• Azure Databricks (Update) • Vena (Update)
Authors

Helen Wall
LinkedIn Learning [in]structor for Power BI and AWS QuickSight | Data Science, Visualization, and
Analytics | helendatadesign.com

Helen is an instructor for several courses in the LinkedIn Learning library that focus on business
intelligence applications such as Microsoft’s Power BI and AWS QuickSight. Helen recorded the
videos comprising these courses, and also authored, developed, and designed the creative content
and projects within these courses. LinkedIn Learning is a paid subscription service, but it’s a great
investment to learn more about technology and business skills as a subscription allows you to
access unlimited courses in the online library.

Chris Wagner
Analytics Architect at Rockwell Automation | Analytics Rebel | Power BI Boss | White Rabbit

Chris has been working in the Data and Analytics space for nearly 20 years. Chris has dedicated
his professional career to making data and information accessible to the masses. A significant
component in making data available is continually learning new things and teaching others from
these experiences. To help people keep up with this ever-changing landscape, Chris frequently
posts on LinkedIn and to this blog.