Streamlining Power BI with PowerShell

on YouTube ↗48m

" summary

PowerShell module PSP PowerBI Tools and Microsoft’s management module get inventory (workspaces, reports, users), add counts, and run actions like renaming and assigning owners; a custom set-psbi-workspace command batch-renames and moves capacities. Activity retrieval extends the native 30 days activity window into 30-day aggregates (Microsoft’s cmdlet returns 24 hours), enables unused-report detection, and automates cleanup, backups and license checks — demos show the commands working against an org with admin/fabric permissions.

AI-written summary · about

" chapters (15)

1. 0:00Power BI and PowerShell intro
2. 3:24PSP Power BI Tools module
3. 7:23Microsoft’s Power BI module
4. 10:16Limitations of Power BI module
5. 13:51Extending activity events
6. 17:30Automating workspace management
7. 21:23Health checks and cleanup
8. 24:26PowerShell module help
9. 27:03Exporting Power BI data
10. 29:58Non-admin access and future phases
11. 31:50Planned streamlining features
12. 35:06Security and naming conventions
13. 37:12Deployment and migration
14. 38:43Future use cases
15. 47:23Q&A

" related talks

• 50mAdvanced Power BI refresh with ADF/SynapseMathias Halkjaer · SQLBits 2022
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 50mPower BI Incremental refresh made simple.Robert French · SQLBits 2023
• 45mRebooting your SME Data Analysis StrategyMark Hayes · SQLBits 2020
• 50mDataOps 101 – A Better Way to Develop and Deliver Data AnalyticsJohn Kerski · SQLBits 2023
• 50mPower BI + Azure Synapse Analytics: Beginning your journeyPatrick LeBlanc, Adam Saxton · SQLBits 2023
• 51mSupercharge Power BI with Azure Synapse AnalyticsMathias Halkjaer · SQLBits 2023
• 49mHow to start with Azure Synapse Analytics - Power BI Developer EditionWolfgang Strasser · Power Platform Virtual Conference 2021