Building a client portal app with embedded Power BI reports
summary
Client portal delivers investor dashboards for Dutch Mortgage Portfolio Management Group by combining a Shiny app in Azure App Service with plumber APIs and R Markdown for templated documents and forecasts. Power BI reports live in the portal via embedded Power BI via powerbi-embed.js, using AzureAuth + httr to retrieve embed tokens and Power BI Embedded capacity so single-sign-on and cross-tool interactions (bookmarks, apply/delete filters) work. Logging, unified UX, and cost tradeoffs are part of the operational setup.
AI-written summary · about
chapters (28)
- 0:00Introduction
- 0:37Axi
- 1:09What to expect
- 1:33Why are we speaking
- 2:13About the customer
- 3:07Before we started
- 3:40Requirements
- 4:22What is Shiny
- 4:52Shiny vs Power BI
- 5:20Creating interactive web applications
- 5:51BI Tools and R
- 6:53BI R Integrations
- 7:28Migration to Shiny
- 8:04Embedding
- 8:40Writing the application
- 8:53Creating the dashboard
- 9:05Embedding the dashboard
- 9:24Power BI Desktop Software
- 10:09Embedding Power BI Dashboard
- 11:03Embedding Power BI Dashboard into another shiny app
- 11:24Power BI JavaScript
- 11:43Send Custom Meshes
- 12:16Embed Power BI Dashboards
- 13:16Authentication
- 14:45Lessons Learned
- 15:08Recap
- 15:32Code Samples
- 15:56Why integrate BI into Shiny
related talks
19mBuilding a client portal app with embedded Power BI reports
48mPower BI for Developers
23mEmpowering Decisions: Advanced Portfolio Analysis and Management through Shiny
59mA pragmatic approach to turn your data into actionable insights
09mPublishing Customer Facing Products with RStudio Connect
09mMaking the case for AI, chat bots, and Power BI
01h 33mPowerShell Universal Dashboard from start to finish
36mBuilding a Marketing Analytics Web App with Python