--- id: video/DVgclv3alZU type: video title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" summary: "Business Central 2026 release wave 1 Power BI and Excel changes: a five-click Power BI demo deployment for demo companies, Excel pivot tables on Power BI semantic models, agentic Excel, calendar configuration guidance, and updated Power BI Subscription Billing, Sales and Inventory apps." tier: official language: en tags: - power bi embedded - demo experience - excel pivot tables - agentic excel - semantic models - calendar configuration - subscription billing app - customer retention - abc analysis - power bi apps system: reporting review: state: reviewed by: opus at: "2026-10-07T22:48:38.678Z" flags: [] generated: at: "2026-10-07T22:48:38.712Z" pipeline: 0.2.0 prompts: extract-video: 1 summarize-video: 2 input_hash: 5a703ace4428a8449906b76ec92cd2861f35da0617167f155db7eab2afa0c877 evidence: - kind: video url: https://www.youtube.com/watch?v=DVgclv3alZU&t=32s title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" date: "2026-04-08T10:04:12.000Z" commit: null t: 32 quote: The investments in this area for this wave is about three things. Better or easier ways to demo Power BI embedded in Business Central. - kind: video url: https://www.youtube.com/watch?v=DVgclv3alZU&t=91s title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" date: "2026-04-08T10:04:12.000Z" commit: null t: 91 quote: We want it to be so easy for partners if you want to go uh to a prospective customer and demo the embedded Power - kind: video url: https://www.youtube.com/watch?v=DVgclv3alZU&t=105s title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" date: "2026-04-08T10:04:12.000Z" commit: null t: 105 quote: This only for now works for demo companies. Later, we hope to it make this same setup experience easy in production environments. - kind: video url: https://www.youtube.com/watch?v=DVgclv3alZU&t=261s title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" date: "2026-04-08T10:04:12.000Z" commit: null t: 261 quote: We have configured the parameters and the first refresh has been scheduled, but if you want to have it recurringly scheduled, you will have - kind: video url: https://www.youtube.com/watch?v=DVgclv3alZU&t=311s title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" date: "2026-04-08T10:04:12.000Z" commit: null t: 311 quote: Analysis services um had Excel as the main client to do pivot tables and analyze your OLAP cubes. And analysis services later on became - kind: video url: https://www.youtube.com/watch?v=DVgclv3alZU&t=398s title: "What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1)" date: "2026-04-08T10:04:12.000Z" commit: null t: 398 quote: There's another application that's quite new in the world of Excel uh called agentic Excel capabilities. And this works very well together with edit links: learn: [] objects: [] features: [] topics: [] localizations: [] videos: [] posts: [] guidelines: [] video_id: DVgclv3alZU channel: yt-microsoft source_name: Microsoft Dynamics 365 Business Central (YouTube) url: https://www.youtube.com/watch?v=DVgclv3alZU published_at: "2026-04-08T10:04:12.000Z" duration_s: 889 captions: full audience: - functional consultant - partner - administrator - decision maker chapters: - t: 0 title: Introduction and Investment Highlights - t: 91 title: Five Clicks to Power BI Demo - t: 228 title: Power BI Deployment Configuration and Setup - t: 297 title: Excel as a Client for Power BI - t: 391 title: Agentic Excel Capabilities - t: 466 title: Calendar Configuration for Power BI Apps - t: 517 title: "Updated Power BI Apps: Subscription Billing, Sales, and Inventory" - t: 599 title: Resources and Related Sessions - t: 644 title: Partner and Customer Resources features: - name: Five Clicks to Power BI Demo status: unclear t: 91 verified: false status_source: video - name: Excel as Client for Power BI Semantic Models status: unclear t: 297 verified: false status_source: video - name: Agentic Excel Capabilities status: unclear t: 391 verified: false status_source: video - name: Calendar Configuration for Power BI Apps status: unclear t: 466 verified: false status_source: video - name: Power BI Subscription Billing App Updates status: unclear t: 517 verified: false status_source: video - name: Power BI Sales App - Customer Retention Analysis status: unclear t: 517 verified: false status_source: video - name: Power BI Inventory App - ABC Analysis status: unclear t: 517 verified: false status_source: video objects_mentioned: [] quotes: - t: 32 text: The investments in this area for this wave is about three things. Better or easier ways to demo Power BI embedded in Business Central. check: exact - t: 91 text: We want it to be so easy for partners if you want to go uh to a prospective customer and demo the embedded Power check: exact - t: 105 text: This only for now works for demo companies. Later, we hope to it make this same setup experience easy in production environments. check: exact - t: 261 text: We have configured the parameters and the first refresh has been scheduled, but if you want to have it recurringly scheduled, you will have check: exact - t: 311 text: Analysis services um had Excel as the main client to do pivot tables and analyze your OLAP cubes. And analysis services later on became check: exact - t: 398 text: There's another application that's quite new in the world of Excel uh called agentic Excel capabilities. And this works very well together with edit check: exact --- # What's New: Enhanced Power BI and Excel with Business Central (2026 release wave 1) > Business Central 2026 release wave 1 Power BI and Excel changes: a five-click Power BI demo deployment for demo companies, Excel pivot tables on Power BI semantic models, agentic Excel, calendar configuration guidance, and updated Power BI Subscription Billing, Sales and Inventory apps. [Watch on YouTube](https://www.youtube.com/watch?v=DVgclv3alZU) · Microsoft Dynamics 365 Business Central (YouTube) · 2026-04-08 · 14:49 · tier official · reviewed (checked by Opus) ## Overview The session covers three investment areas for this wave: easier demos of Power BI embedded in Business Central, Excel as a client for Power BI semantic models, and updates to the Power BI apps. The demo shows how to pick reports on the Power BI deployments page, deploy them matched to the Business Central version, and view them in the role center. It also describes using Excel with Power BI apps through Get Data from Fabric to build pivot tables, and agentic Excel for analysing report outputs and edit in Excel scenarios. App updates include a redesigned Subscription Billing app, customer retention analysis in Sales, and ABC analysis in Inventory. Calendar setup guidance covers fiscal and week-based calendars. ## Key points - The five-click Power BI deployment currently works only for demo companies; the presenter says they hope to bring the same setup to production environments later. - Deployed demo reports are matched automatically to the Business Central version and shown in the role center. - Recurring refresh scheduling is not part of the deployment for this release; it must be set up in the Power BI workspace. - Excel can connect to Power BI apps through Get Data from Fabric, and pivot tables can be inserted on the semantic model as an alternative to Power BI visuals. - Agentic Excel can reason over Business Central data, such as financial report Excel outputs and edit in Excel scenarios, and changes can be pushed back to Business Central. - Documentation now covers configuring fiscal and week-based calendars so they are reflected in Power BI apps. - App updates: Subscription Billing gets a full visual redesign, Sales adds customer retention analysis, and Inventory adds ABC analysis. ## Chapters - [0:00](https://www.youtube.com/watch?v=DVgclv3alZU&t=0s) Introduction and Investment Highlights - [1:31](https://www.youtube.com/watch?v=DVgclv3alZU&t=91s) Five Clicks to Power BI Demo - [3:48](https://www.youtube.com/watch?v=DVgclv3alZU&t=228s) Power BI Deployment Configuration and Setup - [4:57](https://www.youtube.com/watch?v=DVgclv3alZU&t=297s) Excel as a Client for Power BI - [6:31](https://www.youtube.com/watch?v=DVgclv3alZU&t=391s) Agentic Excel Capabilities - [7:46](https://www.youtube.com/watch?v=DVgclv3alZU&t=466s) Calendar Configuration for Power BI Apps - [8:37](https://www.youtube.com/watch?v=DVgclv3alZU&t=517s) Updated Power BI Apps: Subscription Billing, Sales, and Inventory - [9:59](https://www.youtube.com/watch?v=DVgclv3alZU&t=599s) Resources and Related Sessions - [10:44](https://www.youtube.com/watch?v=DVgclv3alZU&t=644s) Partner and Customer Resources ## Features | Feature | Status | At | |---|---|---| | Five Clicks to Power BI Demo | status not stated, demoed | [1:31](https://www.youtube.com/watch?v=DVgclv3alZU&t=91s) | | Excel as Client for Power BI Semantic Models | status not stated | [4:57](https://www.youtube.com/watch?v=DVgclv3alZU&t=297s) | | Agentic Excel Capabilities | status not stated | [6:31](https://www.youtube.com/watch?v=DVgclv3alZU&t=391s) | | Calendar Configuration for Power BI Apps | status not stated | [7:46](https://www.youtube.com/watch?v=DVgclv3alZU&t=466s) | | Power BI Subscription Billing App Updates | status not stated | [8:37](https://www.youtube.com/watch?v=DVgclv3alZU&t=517s) | | Power BI Sales App - Customer Retention Analysis | status not stated | [8:37](https://www.youtube.com/watch?v=DVgclv3alZU&t=517s) | | Power BI Inventory App - ABC Analysis | status not stated | [8:37](https://www.youtube.com/watch?v=DVgclv3alZU&t=517s) | ## Quotes - [0:32](https://www.youtube.com/watch?v=DVgclv3alZU&t=32s) "The investments in this area for this wave is about three things. Better or easier ways to demo Power BI embedded in Business Central." - [1:31](https://www.youtube.com/watch?v=DVgclv3alZU&t=91s) "We want it to be so easy for partners if you want to go uh to a prospective customer and demo the embedded Power" - [1:45](https://www.youtube.com/watch?v=DVgclv3alZU&t=105s) "This only for now works for demo companies. Later, we hope to it make this same setup experience easy in production environments." - [4:21](https://www.youtube.com/watch?v=DVgclv3alZU&t=261s) "We have configured the parameters and the first refresh has been scheduled, but if you want to have it recurringly scheduled, you will have" - [5:11](https://www.youtube.com/watch?v=DVgclv3alZU&t=311s) "Analysis services um had Excel as the main client to do pivot tables and analyze your OLAP cubes. And analysis services later on became" - [6:38](https://www.youtube.com/watch?v=DVgclv3alZU&t=398s) "There's another application that's quite new in the world of Excel uh called agentic Excel capabilities. And this works very well together with edit" ## Disclaimers in the video - [1:45](https://www.youtube.com/watch?v=DVgclv3alZU&t=105s) coming-later: This only for now works for demo companies. Later, we hope to it make this same setup experience easy in production environments. - [4:00](https://www.youtube.com/watch?v=DVgclv3alZU&t=240s) not-in-this-release: is not currently part of it, uh but that is something we are uh that you would have to configure in your workspace. - [4:21](https://www.youtube.com/watch?v=DVgclv3alZU&t=261s) not-in-this-release: if you want to have it recurringly scheduled, you will have to do it at least for this release in uh So, for example, I can show it here uh in my workspace. Presenters (as heard): Kenny Pontoppidan, Joshua.