Power BI Weekly Newsletter Issue #129

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) writes about Multi-Value Parameters In Power Query Online
• Ben Gribaudo (@bgribaudo) writes about Resilient Relative Column Reordering
• On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) explains How To Use Power Query Row And Column Selection and writes about Nested Expressions: Power Query Environments
• On the Towards Data Science blog, Nikola Ilic (@DataMozart) shares 3 reasons to use views instead of tables in Power BI
• Reid Havens (@HavensBI) describes Creating Date Calendar Hierarchy Columns in Power Query
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Power BI Date or Calendar Table Best Method | DAX or Power Query and discusses a Power Query Transformation Pattern | Convert Status Log Dates Table to Start and End Date Table
• Rick de Groot (@Rickmaurinus) explains how to Perform a Case Insensitive Replace Values in Power Query
• Ruth Pozuelo Martinez (@CurbalEN) describes How to do Pagination without knowing the number of pages (Part 2) in Power Query | List.Generate
• Chandeep Chhabra (@chandeep2786) describes how to Remove Top Rows and Combine Data from Multiple Excel Files
• Antriksh Sharma (@AntrikshShar) wonders What If I Use Table.RemoveColumns in Power Query? | Power BI
• Lars Schreiber (@SchreiberLars) writes Aus kumulierten Werten Tageswerte zurückrechnen – mit gruppierten Daten [German]
• On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Dos formas de obtener .parquet combinados [Spanish]
• Also on the Towards Data Science blog, Salvatore Cagliari describes how to Change your approach with large datasets in Power BI
• Jeff Lenning (@Exceluniversity) shares a PivotTable with Multiple Text Values Alternative

Data Modeling

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

• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Header/Detail vs Star Schema models in Tabular and Power BI, and shares Integer – DAX Guide, Decimal – DAX Guide and Currency – DAX Guide
• Phil Seamark (@PhilSeamark) talks about Power BI Storage Modes for Aggregations
• On the Power BI community blog, Greg Deckler (@GregDeckler) describes Microsoft Hates Greg's Quick Measures
• Antriksh Sharma (@AntrikshShar) shares a few videos: How to Create Running Total in DAX in Power BI with FILTER and ALL DAX Tutorial for beginners, How to Stop Running Total in Current Year with DAX in Power BI and How to Create Running Total for Previous Year with DAX in Power BI
• Also on the Power BI community blog, Jay Wang explains how to Calculate the Distance between Two Locations
• Matthew Peterson (@mattpetersonbi) describes how to Group Values From Column For Visuals - No DAX Needed
• Gilbert Quevauvilliers (@GilbertQue) describes Using PowerShell to run Power BI DAX queries and extract data to CSV
• Hima Bindu Marri (@sivahimabindu) delves into RANKX in Power BI
• Dhruvin Shah (@DhruvinShah16) covers COUNT, COUNTA, COUNTX, COUNTAX, COUNTBLANK, DISTICTCOUNT, COUNTROWS and AVERAGE, AVERAGEA, AVERAGEX
• Bas Dohmen (@HowToPowerBI) talks about TopN Filter Confusion in Power BI
• On the SQL Shack blog, Aveek Das (@avikoleum) shares an Overview of Power BI Time calculations
• Also on the Power BI Community blog, Amit Chandak (@amitchandak78) writes Customer Retention Part 5: LTD and PeriodYoY Retention is only focused on Year vs Year
• Pat Mahoney (@mahoneypa) shares Let's Get It Sorted - Part Two

Report Authoring and Interactivity

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

• Sam McKay (@_EnterpriseDNA) shares that The Key Influencers Visual In Power BI Is Incredible & We Should Use It More
• Patrick Leblanc (@GuyInACube) describes How to show 5 minute intervals in Power BI
• Rick de Groot (@Rickmaurinus) describes how to Set Default Slicer Value to Current Month in Power BI
• On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) talks about Buttons in Power BI
• Daniel Marsh-Patrick (@the_d_mp) writes about the Violin Plot: Custom Visual for Power BI
• The Power BI team (@MSPowerBI) explains how to Create quick reports in Microsoft Power BI on the web
• Bas Dohmen (@HowToPowerBI) talks about Page Navigation Hover Effect in Power BI
• David Abu talks about the AI Visuals: Decomposition Tree and explains how to AI Visual in Power BI: Increase and Decrease in Line Chart

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, David Magar highlights the General Availability of next-gen Premium Platform
• The Power BI team (@MSPowerBI) covers the Power BI New Premium Platform - Features breakdown and walkthrough
• On the Blue Granite blog, Dawn Clement writes about Power BI Premium Gen2: The Next Generation
• Also on the Power BI blog, Kay Unkroth writes that the New authentication option facilitates AAS migrations to Power BI Premium at a low price point
• Also on the Power BI blog, Derek Jaeger blogs about the Power BI Unused Artifacts API (preview)
• On the Power BI Tips and Tricks blog, Tommy Puglia (@tommypuglia) describes Using the Power BI Scanner API to Manage a Tenant's Entire Metadata
• On the Power BI community blog, Ted Pattison (@TedPattison) highlights the Power BI Dev Camp: Oct. 28th 11a PST | Learn ALM in Power BI with Deployment Pipelines
• Alex J. Garcia (@AlexG_SmartPBI) discusses Resourcing and Structuring a Power BI Centre of Excellence – Part 4 of PBI CoE Series
• On the MSSQLTips site, Kenneth A. Omorodion describes how to Use Power Automate to Export and Email Power BI Reports with Row Level Security

General

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

• Kasper de Jonge (@kjonge) covers The rise of self-service BI, PowerPivot and Power BI and how it changed the world with Rob Collie
• Adam Saxton and Patrick Leblanc (@GuyInACube) share Power BI tips from the Pros – LIVE w/ Alberto Ferrari
• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 207 - Power BI News Update
• Scott Sewell (@ScottSewell) presents Power BI Dev Camp Session 14 Developing Power BI for Dataverse + Power Apps and Dynamics 365 CE

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.