Power BI Weekly Newsletter Issue #123

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

• Ben Gribaudo (@bgribaudo) writes about Dynamic, Lazy Records
• Antriksh Sharma (@AntrikshShar) explains How To Create Ranking in Power Query with Table.Selectrows & Table.AddIndexColumn Power BI Excel and explains How to Import Data From Google Sheets In Power Query in Power BI and Excel
• Mimoune Djouallah (@mim_djo) talks about the Multi select parameter support in BigQuery when using Power BI and covers Using PowerBI M Parameter for Geospatial calculation
• On the CSG Pro blog, Brian Grant (@BrianGrantBI) talks about Dynamic Rounding in Power Query: Easy Method
• Marcus Wegener (@PowerBIler) writes about Zoom im Power Query Editor [German]

Data Modeling

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

• Chris Webb (@cwebb_bi) explains How Defining Too Many Measures In A Live Connection Report Can Affect Power BI Query Performance
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: TOPN – DAX Guide, ROLLUPGROUP – DAX Guide and GENERATE, GENERATEALL – DAX Guide
• Antriksh Sharma (@AntrikshShar) shares a few videos: How To Create a Date Table in Power BI with DAX CALENDAR function Power BI, Show Previous Year's Months in Current Year with DAX Power BI and How to extract unique values in Excel with VBA VBA Scripting Dictionary Tutorial Excel VBA
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Explicit Vs Implicit DAX Measures in Power BI and shares a Book Overview - Power BI DAX Simplified
• Bas Dohmen (@HowToPowerBI) describes Dynamic Benchmark Range in Power BI and discusses a Time Intelligence Trick in Power BI
• On the Towards Data Science blog, Nikola Ilic (@DataMozart) walks through Building an End-To-End Analytic solution in Power BI: Part 3—Level Up with Data Modeling
• Soheil Bakhshi (@biinsightnz) blogs about The Story of my Book, Expert Data Modeling with Power BI
• Hima Bindu Marri (@sivahimabindu) explains how to Compare any 2 years data Power BI
• Ramon Bello describes Calculating Percentage Growth Rate with Negative and Positive Numbers with DAX

Report Authoring and Interactivity

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

• On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) highlights the Power BI August 2021 Feature Summary
• Ruth Pozuelo Martinez (@CurbalEN) talks about the Power BI August 2021 update
• Also on the Power BI blog, Ranin Salameh highlights the Enhanced experience for browsing visuals
• Patrick Leblanc (@GuyInACube) explores Exploring the Visio visual in Power BI
• On the Burningsuit blog, Alison Box shares Charticulator In Power BI #13 – Polar Scaffolds. Pies, Peacocks & Nightingales and Charticulator In Power BI #14 – The Line Plot Segment
• On the Enterprise DNA blog, Mudassir Ali talks about Scatter Chart Visualizations With Charticulator and talks about Line Charts – A Common Yet Great Visualization
• Also on the Enterprise DNA blog, Jarrett Moore (@BuckeyeJarrett) writes about Anomaly Detection In Power BI, Zoom Sliders, and Smart Narrative Functionality
• On the Towards Data Science blog, Patrick Pichler covers Comparing Selected Categories in Power BI
• On the CSG Pro blog, Brian Grant (@BrianGrantBI) blogs about The Very Basics of Great Power BI Report Design
• On the SQL Shack blog, Aveek Das (@avikoleum) discusses Embedding Power BI reports in Jupyter notebooks
• Bas Dohmen (@HowToPowerBI) describes how to Label Line Chart Series in Power BI
• On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Take Your Power BI Visualization to the Next Level using Small Multiples
• Reid Havens (@HavensBI) talks about Using Small Multiples with Independent & Non-Additive Categories and discusses Deneb: Bringing the Vega Languages to Power BI Visuals! (with Daniel Marsh-Patrick)
• Dhruvin Shah (@DhruvinShah16) explains how to Get Best Result from Q&A Visual in Power BI
• Greg Philps blogs about Custom Theming In Power BI
• Sam McKay (@_EnterpriseDNA) shares a Compilation Of The Best Power BI Reporting Applications We've Seen
• Marcus Wegener (@PowerBIler) writes about Power BI Filter Panel mit mehr als zwei Bedingungen [German]

Deployment, Security and Operations

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

• Marc Lelijveld (@MarcLelijveld) explains how to Transform a local into a global Power BI solution – Information protection
• Adam Saxton (@GuyInACube) explains how to Refresh your data in Power BI without a user???
• Gilbert Quevauvilliers (@GilbertQue) blogs about Row Level Security – Part 9 | Migrating AAS to PPU

General

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

• On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 202 - Power BI News update
• On the Power BI community blog, Ted Pattison (@TedPattison) highlights the Power BI Dev Camp Developing in Salesforce with Power BI Embedding - August 26th at 11am PDT

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.