Power BI Weekly Newsletter Issue #131

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• Chris Webb (@cwebb_bi) covers Refreshing Power Pivot Excel Data Models That Use The Current Workbook As A Data Source In Excel Online
• On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) shares a Power Query Editor Tutorial: Extract Record Field Values From Lists and and a Power Query M Language Tutorial And Mastery
• Erik Svensen (@donsvensen) writes about PowerQuery – Add Year, Month and Day to your date table with Date.ToRecord
• Chandeep Chhabra (@chandeep2786) shares 5 Tricks to Reduce Steps in Power Query
• Ruth Pozuelo Martinez (@CurbalEN) describes how to Fix M intellisense once and for all
• Bryant Avey (@BryantAvey) presents Pattern-Driven Insight: Integrating Neo4j with Power BI
• Hima Bindu Marri (@sivahimabindu) describes Why and how to connect to a website through Power BI desktop

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• On the SQLBI blog, Marco Russo (@marcorus) describes Implementing real-time updates in Power BI using push datasets instead of DirectQuery
• Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Creating real time dashboards in Power BI with push datasets, blogs about Controlling drillthrough in Excel PivotTables connected to Power BI or Analysis Services, and shares the tutorials Binary – DAX Guide and IF – DAX Guide
• On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Modelar hechos con distintas granularidades de fecha [Spanish]
• On the MSSQLTips site, Kenneth A. Omorodion explains how to Combine Text Strings in Power BI Using DAX
• Dhruvin Shah (@DhruvinShah16) presents Power BI DAX for Beginners: MIN, MAX, MINX, MAXX, MINA, MINX
• On the Power BI Tips and Tricks blog, James Bartlett shares Business Ops: New and Updated External Tools

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• Bernat Agulló (@AgulloBernat) describes Building arbitrary tables with 2-level column headers
• Business Intelligist (@bizintelligist) describes How to Display Multiple Rows in a Single Cell of a Matrix or a Table
• Mara Pereira (@datapears) discusses Power BI query reduction - Add an Apply all filters button to your report
• On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes how to Highlight lowest and highest periods dynamically on Power BI Chart
• Also on the Power BI community blog, Icey Zhang explains How to return forecasted values as a table in a R visual
• Bas Dohmen (@HowToPowerBI) provides Multiple KPIs with line breaks on hover in Power BI
• Ruth Pozuelo Martinez (@CurbalEN) describes How to keep your charts on PowerPoint and MS Word reports automatically updated!! | Power BI, Excel
• On the MSSQLTips site, Scott Murray writes about Power BI Report Automation
• Felix Gemander shares a Quick Tipp - Power BI - Diagramm erstellen und formatieren | Dashboard Heroes [German]

Deployment, Security and Operations

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling

• On the Power BI blog, Miquella de Boer shares that the On-premises data gateway October 2021 update is now available
• On the Power GI blog, Cyrus Christian writes about the Power BI Premium Gen 2 Metrics App for GCC
• Gilbert Quevauvilliers (@GilbertQue) describes How to resolve error when deploying changes to Power BI Premium Per User for Incremental partitions

General

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• On the Power BI blog, Yarden Albeck writes that Microsoft Power BI and Azure Purview better together – now Generally Available
• Adam Saxton (@GuyInACube) highlights the Power BI tips from the Pros – LIVE w/ Paul Turley (October 23, 2021)
• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 208 - Power BI October 2021 Feature Summary
• Reid Havens (@HavensBI) blogs about The Skills Your Power BI Team Needs to Succeed with Ed Hansberry
• Matt Allington (@ExceleratorBI) writes about 5 New Features I Love – Coming Soon to Power BI

Useful Links

• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
• Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
• Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.