Power BI Weekly
Issue #38 - 17th December 2019
This week, Microsoft has released a multipart series entitled the Power BI Adoption Framework, detailing some best practices when it comes to organisations adopting Power BI. Great content to give to potential Power BI users. Elsewhere, Richard Tkachuk has provided a comparison between Power BI Premium and Azure Analysis Services, Marc Lelijveld has described how to implement a Thumbs up or down Measure Power BI report sentiment with MS Power Automate MS Flow, and Rishi Sapra has written a five-part series on Income Statement Analysis.
🛠️ Data Prep
- Matthew Roche (@SQLAllFather) provides a Power BIte: Dataflows enhanced compute engine
- On the Excelguru blog, Ken Puls (@kpuls) explains how to Remove Dynamic Number of Top Rows
- Chandeep Chhabra (@chandeep2786) writes about Dynamic Column Names in Power Query
- On the RADACAD blog, Leila Etaati (@leila_etaati) covers the Form Processing Workflow with AI Builder- Data Transformation with Power BI- Part 3
- On the Power BI blog, Kelly Kaye explains how to Learn how Power BI can help with extracting data from a website - webinar by Indira Bandari
🧩 Data Modeling
- Bill Anton (@SQLbyoBI) describes DAX Variables and IF/SWITCH Statements
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Calculate Totals in Power BI: Using Iterators in DAX
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) delves into Extracting Unique Insights In Power BI Using Ranking DAX Measures, describes Understanding Evaluation Context in Power BI, provides an Introduction to Filter Context in Power BI and explains Row Context in Power BI
- James Serra (@JamesSerra) discusses Azure Synapse Analytics & Power BI performance
- On the Prologika blog, Teo Lachev (@tlachev) provides some Tips for Extended Events
⚙️ Report Design and Visualizations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Data Visualization in Power BI: Showcasing Sales Performance Effectively
- On the Power BI community blog, Rishi Sapra (@rsaprano) writes about Income Statement Analysis: Part 1 of 5, Part 2 of 5: Create Simple Matrix view with Actuals, Part 3 of 5: Format the page and add Dynamic Measure, Part 4 of 5: Add KPI Cards and Waterfall and Part 5 of 5: Add IS Tables and Bookmarks
- Prathy Kamasani (@pkamasani) explains How I designed a layered donut chart
⚙️ Data Exploration
- Marc Lelijveld (@MarcLelijveld) discusses Thumbs up or down? Measure Power BI report sentiment with MS Power Automate (MS Flow)
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes Three Killer Ways to Use Bookmarks
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) describes How to Build your First Power BI Dashboard
🚀 Deployment, Security and Operations
- On the Power BI blog, Richard Tkachuk (@richardtkachuk) blogs about Power BI Premium and Azure Analysis Services
- Ike Ellis (@ike_ellis) spoke about Power BI Premium at Power Platform Summit 2019 - San Diego
- On the Prologika blog, Teo Lachev (@tlachev) discusses Power BI Incremental Refresh
- Gilbert Quevauvilliers (@GilbertQue) explains How to quickly and easily copy a report with a shared dataset to another New App Workspace in the Power BI Service
- Kasper de Jonge (@kjonge) explains how to Learn AAD when you manage a Power BI environment
- Chris Webb (@cwebb_bi) blogs about Testing Performance Of Power BI Reports In The Browser, Part 3
- On the Power BI community blog, Rory Neary (@AzureRory) describes The Ultimate CDS Power BI Explorer Part 1 – From Zero to Hero
🌐 General
- On the Power BI blog, Sandy Rivas (@SandyRivas) writes that Communities Wins Silver Stevie Award for Innovation
- Kasper de Jonge (@kjonge) talks about Building a dataculture with Power BI
- Matthew Roche (@SQLAllFather) writes about The Power BI Adoption Framework – it's Power BI AF