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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
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.