Extending Power BI with R

on YouTube ↗21m

" summary

Power BI now runs R by enabling an R install in Options, using Get Data -> R script to expose data frames that load into Power BI's in-memory columnstore, and by installing marketplace visuals that may wrap R. Demonstration shows read.csv to produce a data frame, Power Query M for mashups, a marketplace histogram visual using R, and that custom R visuals are static images so they render plots but do not fully participate in cross-filtering.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 7:53What is Power BI
3. 14:22Visual Query
4. 15:02Advanced Tab
5. 15:32Import Data
6. 16:32Add Visual
7. 17:02Add Bar Chart
8. 17:32Add Age
9. 18:02Connect to Marketplace
10. 18:32Create Histogram Visual
11. 19:02Cross Filtering
12. 19:32Adding Columns
13. 20:02Adding Visuals
14. 20:32Outro

" related talks

• 19mThe R integration in Power BI: Why R developers should be InterestedRyan E Wade · rstudio::conf 2019
• 19mThe R integration in Power BI: Why R developers should be InterestedRyan E Wade · rstudio::conf(2022)
• 58mReal world PowerBIMatt Davies · NDC Sydney 2017
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 48mPower BI for DevelopersPeter Meyers · NDC Sydney 2018
• 58mPower BI for DevelopersPeter Myers, Laurent Amar · NDC London 2019
• 47mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure 2021
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023