Power BI Weekly

Issue #82 - 27th October 2020

The main news this week is the Power BI October 2020 Feature Summary, which includes numerous exciting announcements (primarily around visuals). One very nice addition is the introduction of canvas watermarks, which many of you will have seen on your travels already. These will be very useful for those new to Power BI. The Personalize Visuals feature is now Generally Available (GA) and the 'new look' of the Power BI Service is being rolled out this week and will be available to all tenants by early November. Finally, there have been a bunch of Updates to Power BI Publish to web for better public reporting all geared towards providing UX enhancements for the end users.

Elsewhere this week, Chris Webb has described Why I'm Excited About Dynamic M Parameters In Power BI, Parker Stevens has show how to Export Report and Email to Current User Power Automate, and Krešimir Ledinski has written about List.Generate and Looping in PowerQuery.

🛠️ Data Prep

Chris Webb (@cwebb_bi) writes about Why Im Excited About Dynamic M Parameters In Power BI
Mimoune Djouallah (@mim_djo) describes how to Change Dimension Dynamically using Parameter in PowerBI
On the Power BI community blog, artemus describes how to Unlock the power of dynamic parameter binding for Direct Query
On the Prologika blog, Teo Lachev (@tlachev) talks about Power BI Dynamic M Query Parameters – Another Opportunity Missed for DirectQuery Users
Soheil Bakhshi (@biinsightnz) provides A Power Query Custom Function to Rename all Columns at Once in a Table
On the Enterprise DNA blog, Melissa de Korte explains how to Create A Delimited List In Power Query and writes about Delimited Data – Extracting Records Using Power BI
Also on the Power BI community blog, Allan Qin writes about Substring with DAX and Power Query
Erik Svensen (@donsvensen) discusses some Tips to limit the number of steps in PowerQuery
Kreimir Ledinski talks about List.Generate and Looping in PowerQuery
Jeff Lenning (@Exceluniversity) writes Treasure Maps 2

🧩 Data Modeling

James Serra (@JamesSerra) lists the Top Azure Synapse Analytics and Power BI questions
Darren Gosbell (@darrengosbell) highlights that DAX Studio v2.13 released
Gilbert Quevauvilliers (@GilbertQue) explains how to Get Power BI Desktop to write the DAX for you
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes creating Dynamic format strings with calculation groups
Matt Allington (@ExceleratorBI) blogs about Custom Format Strings in Power BI
On the SQL Server Central blog, Bill Pearson provides an Introduction to DAX Financial Functions – Part 1
On the Enterprise DNA blog, Nick Mone writes about a Currency Rates Table – Accounting For Missing Data With DAX
Jarret Moore compares TREATAS vs USERELATIONSHIP in Power BI and talks about Creating Measures Table & Organizing Measure in Subfolders In Power BI
Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about Simple Aggregations In Power BI and talks about Power BI Formula Syntax, Comments, And Variables
On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) writes about Syntax Sugar – SUM Is SUMX In Disguise
On the Excelguru blog, Ken Puls (@kpuls) intoduces the Measure Monkey
Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #189: Which function is faster to count rows: COUNT OR COUNTROWS?
Chandeep Chhabra (@chandeep2786) describes a Running Total in Power BI
On the DataAP blog, Hariharan Rajendran (@imhariharanr) describes how to Display Zero When No Rows in Dataset – Power BI Paginated Report Tip -1
Also on the Power BI Community blog, Yingjie Li writes about Ranking in 3 different items

📊 Report Authoring and Interactivity

On the Power BI blog, Sujata Narayana announces the Personalize Visuals General Availability (GA)
Reid Havens (@HavensBI) describes Using the Smart Narrative Visual in Report Tooltips
On the Business Intelligist blog, Business Intelligist (@bizintelligist) explains how to Build an Ultimate KPI Using a Smart Narrative (Power BI Tutorial)
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about a Chic look in Power BI with Chiclet Slicer and discusses Magic tables in Power BI
On the Power BI Tips and Tricks blog, Daniel Marsh-Patrick (@the_d_mp) covers the HTML Content Custom Visual
Also on the Power BI community blog, V-lianl-msft explains how to Make a clock visual with DAX
Ulrik B. Carlsson (@crmchartguy) describes how to Use Icons from Power Apps Unified Interface in Power BI
Mike Allen (@MikeAinOz) provides some Guidance for Adaptive Cards Custom Visual 1.0.2 - Repeating Column Set
On the Power BI community blog, Varun Jain describes how to Display custom textbox based on the slicer selection using IF condition
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How To Use Natural Language Query (Q&A) In Power BI

🚀 Deployment, Security and Operations

On the Power BI blog, Lukasz Pawlowski (@lukasztweets) shares the Updates to Power BI Publish to web for better public reporting
Also on the Power BI blog, Dustin Askins provides a Heads up: The new look of the Power BI service begins rolling out soon
Martin Schoombee (@MartinSchoombee) blogs about Automating Power BI deployments: Change data source credentials
Adam Saxton (@GuyInACube) writes about Why and how to use data protection in Power BI
Parker Stevens (@PowerBIElite) describes how to Export Report and Email to Current User Power Automate
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How To Share Reports In Power BI Online Service
On the Power BI community blog, michaelsh describes My experience working with Virtual Machine
Patrick Leblanc (@GuyInACube) explains how to Deploy Power BI dataset schema changes WITHOUT refreshing!

🌐 General

On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI October 2020 Feature Summary
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 164 - A Fall Cornucopia
The Knee-Deep in Tech team (@KneeDeepinTech) shares Podcast episode 136
The Power BI team (@MSPowerBI) talks about Power BI: Amazing exploration experiences
David Eldersveld (@dataveld) writes about the New Financial Sample Dataset Included with Power BI Desktop
Also on the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) explains how to Customize the Default Dataset
Ruth Pozuelo Martinez (@CurbalEN) describes how to Download sample datasets and reports for Power BI and Excel and shares All Power BI desktop updates for October 2020 in 7 minutes!
Adam Saxton (@GuyInACube) talks about New Gateway, Power BI data source management and more… (Roundup | October 19, 2020)
On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) presents MVPs React October 2020
Also on the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) writes that Power BI is part of the greater data solution
Matthew Roche (@SQLAllFather) talks about Data Culture: Measuring Success
Alex J. Garcia (@SmartpowerB) writes Scoping a Power BI Centre of Excellence – Part 3 of PBI CoE Series.
Spencer Baucke (@JSBaucke) writes about Power BI for Tableau Developers: Introduction
Dhruvin Shah (@DhruvinShah16) writes about New Power BI Experience in Microsoft Teams