Power BI Weekly
Issue #123 - 17th August 2021
Firstly, a newsletter related announcement - the next edition of Power BI Weekly will be on the 7th September as I'll be taking a break to go and climb some hills in England. I'll respond to any emails sent to me during the next few weeks upon my return. Now, enough about me...
Naturally, the main announcement from the past week has been the Power BI August 2021 Feature Summary, including nice little updates like using measures to define the values for x-axis constant lines and the new syntax for expressing Date and DateTime values in DAX. Other updates from that feature summary include various connector improvements (e.g. Databricks/BigQuery), a new Enhanced experience for browsing visuals, and just a brief note on a huge feature regarding automatic aggregations for DirectQuery datasets - though no one can seem to find any corresponding documentation for that feature yet!
Elsewhere this week, Reza Rad has reminded us about the difference between Explicit Vs Implicit DAX Measures and how it affects the "Analyze in Excel" functionality, Bas Dohmen has described how to achieve a Dynamic Benchmark Range applied to a line chart, and Patrick Leblanc has given us a walkthrough of the Visio visual in Power BI.
🛠️ Data Prep
- 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
- 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
- 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
- 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
- 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