Building a client portal app with embedded Power BI reports

on YouTube ↗19m

" summary

Built a customer portal combining an R Shiny front end running on Azure App Service with embedded Power BI reports, plumber APIs for forecasts and PDFs, and AzureAuth plus httr to fetch embed tokens. Embedding uses the Power BI JavaScript library (powerbi-embed.js), sendCustomMessage/addCustomMessageHandler and Shiny.onInputChange to sync filters, bookmarks and events. Requires Power BI Embedded Capacity, adds request logging for audits, and successfully delivers unified UX while avoiding repeated iframe logins and manual app republish.

AI-written summary · about

" chapters (28)

1. 0:00Introduction
2. 0:37Axi
3. 1:09What to expect
4. 1:33Why are we speaking
5. 2:13About the customer
6. 3:07Before we started
7. 3:40Requirements
8. 4:22What is Shiny
9. 4:52Shiny vs Power BI
10. 5:20Creating interactive web applications
11. 5:51BI Tools and R
12. 6:53BI R Integrations
13. 7:28Migration to Shiny
14. 8:04Embedding
15. 8:40Writing the application
16. 8:53Creating the dashboard
17. 9:05Embedding the dashboard
18. 9:24Power BI Desktop Software
19. 10:09Embedding Power BI Dashboard
20. 11:03Embedding Power BI Dashboard into another shiny app
21. 11:24Power BI JavaScript
22. 11:43Send Custom Meshes
23. 12:16Embed Power BI Dashboards
24. 13:16Authentication
25. 14:45Lessons Learned
26. 15:08Recap
27. 15:32Code Samples
28. 15:56Why integrate BI into Shiny

" related talks

• 19mBuilding a client portal app with embedded Power BI reportsThomas Wouters, Joran De Wilde · rstudio::conf(2022)
• 01h 01mIntroducing the Reimagined Power BI PlatformJen Underwood · PASS BA Marathon 2015
• 48mPower BI for DevelopersPeter Meyers · NDC Sydney 2018
• 57mBillions of records: the real success story using Microsoft Power BI EmbeddedIrina Dragunova · NDC Oslo 2020
• 23mEmpowering Decisions: Advanced Portfolio Analysis and Management through ShinyLovekumar Patel · posit::conf(2024)
• 52mPower BI + Azure Synapse Analytics. All you need to start creating a unified analytics solutionPawel Potasinski · SQLBits 2023
• 33mEnhance your applications with Amazon QuickSight embedded analyticsKareem Syed-Mohammed · AWS Summit San Francisco 2022
• 59mA pragmatic approach to turn your data into actionable insightsIrina Dragunova · NDC London 2021