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
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- 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
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- 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
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- 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
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- 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
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- 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
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- 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
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.