Power BI Weekly

Issue #77 - 22nd September 2020

Has everyone remembered that the Microsoft Ignite virtual conference starts today? If you haven't, don't worry - there's still time to sign-up. I'm sure there'll be plenty of exciting announcements/updates/roadmpas, both in Power BI and in the wider Microsoft ecosystem. Learn more over here.

Otherwise, some pre-Ignite good news: there are now Power Automate actions for exporting Power BI and paginated reports which is perfect for those of you automating the exporting/distributing of Power BI content. However, you won't be surprised to hear of the requirement for a dedicated capacity. Humph. We've also been told about the Updates to the 'new look' experience and release plangoing forward, including more admin settings for those determining what Power BI users view in their organization.

Elsewhere, Matthew Roche has answered a few thus-far unanswered questions in the blog Dataflows enhanced compute engine - will it fold?, Chris Webb has described the importance of reducing the number of visuals on a page of a Power BI report, and Imke Feldmann has described how to Split up an existing Power BI report into a Golden Dataset and a thin report.

🛠️ Data Prep

Matt Allington (@ExceleratorBI) writes about Power BI and SharePoint – Terrible Together
Matthew Roche (@SQLAllFather) writes about Dataflows enhanced compute engine – will it fold? and gives a Lazy Dataflows Overview
Gilbert Quevauvilliers (@GilbertQue) blogs about Using Power Query to get data from an API that uses a Username and Password combination
Imke Feldmann (@TheBIccountant) explains how to Retrieve header fields like response status from Web.Contents in Power BI and Power Query
On the Towards Data Science blog, Peter Hui discusses Functions in Power BI
Belinda Allen (@MsBelindaAllen) talks about Creating data source parameters for SQL Server in Microsoft Power BI
On the Enterprise DNA blog, Melissa de Korte walks through Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables and covers Creating Values For Each Date Using Power Query Formula
On the Business Intelligist blog, Business Intelligist (@bizintelligist) explains How to Make a Copy of a Power BI DataFlow
Jon Acampora (@excelcampus) explains How to Count Unique Rows with Power Query
Jeff Lenning (@Exceluniversity) explains how to Create Calculated Columns without Writing Formulas
On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains how to Get the Nth Records via VLOOKUP or Solve via POWER QUERY (Group By, Pivot Columns & M Code) in Excel and describes how to Split Columns Text or Numbers by Formula or POWER QUERY in Microsoft Excel
Dhruvin Shah (@DhruvinShah16) explains how to Get Help with Spellings and Group text values using Table.AddFuzzyClusterColumn Function in Power BI
On the DataAP blog, Hariharan Rajendran (@imhariharanr) writes about Power BI with Teradata Report Considerations
Avi Singh (@powerbipro) writes about Power BI: Select Top Row in Each Category?! #PowerBIPuzzle 🤔

🧩 Data Modeling

Patrick Leblanc (@GuyInACube) discusses Working with Time Periods in Power BI
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about Role-playing dimensions in Power BI and explains How I speed up my Power BI report 5x!
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses Understanding the difference between LASTDATE and MAX in DAX
Ruth Pozuelo Martinez (@CurbalEN) explains how to Create a link to a Power BI report with External tools functionality and writes about My beginner's DAX mistakes, ......what are yours? 😈
On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes how to Supercharge KPIs with Rankings (When Trend And Target Are Not Enough) (Plus a RANKX() DAX Function Tutorial)
On the Forsight BI blog, Ahmed Oyelowo (@AhmedOyelowo) provides a Practical Introduction to DAX (Intro to Calculated Tables)
Vivek Ranjan (@imvivran) covers Moving Average using DAX, p2 and blogs about DAX: KEEPFILTERS
Amit Chandak (@amitchandak78) writes Customer Retention Part 2: Period over Period Retention
On the Enterprise DNA blog, Brian Julius describes Using IsAfterToday for Power BI Time Intelligence Scenarios
Also on the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a few posts: Techniques To Manage Your Data Model In Power BI, Quickly Discover When The Last Date Something Occurred Was Using DAX - MAXX Tutorial, Highlight Growth Trajectory Of A Customer Through Time - Analysis Tip For Power BI, The Importance Of Date Tables In Power BI and Power BI Dynamic Visuals Using SWITCH TRUE Logic – Visualization Technique
Lars Schreiber (@SchreiberLars) describes Power BI User Group Hamburg: Relationships in Power BI (Alberto Ferrari)
On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Filtro que cambia unidades de visualizaciones [Spanish]

📊 Report Authoring and Interactivity

Chris Webb (@cwebb_bi) discusses Power BI Report Performance And The Number Of Visuals On A Page
Meagan Longoria (@mmarie) tells us to Stop Letting Accessibility Be Optional In Your Power BI Reports
On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) talks about Creating Power BI Dashboard with Custom Images & Icons
On the CSG Pro blog, Alice Drummond and Christian Borovac talks about The Power BI Designers Workflow: From Canvas to Creation
Reid Havens (@HavensBI) talks about Selecting Data Points with a Lasso Tool as a Time Scrubber in Power BI
On the Towards Data Science blog, Thiago Candido (@ogaihtcandido) writes about Truly Customizing Power BI with React, Angular, or any web framework
Paul Turley (@paul_turley) writes Doing Power BI the Right Way: 9. Choosing the right report type: analytic or paginated
Sam McKay (@_EnterpriseDNA) shares a few videos: Creating A Visual Tooltip In Power BI - Make Your Consumers Really Go Wow, Using Drillthrough Navigation Techniques Within Your Power BI Reports, Placing Dynamic Maps In Tooltips In Power BI - Ultimate Data Viz Technique and Why Using Good Colours Across Your Reports Is Essential In Power BI
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Create Ribbon Chart Using Charticulator inside Power BI
On the Data Bear blog, Edward Van Der Merwe blogs about Power BI’s Q&A
Ruth Pozuelo Martinez (@CurbalEN) talks about Making some things transparent in Power BI
On the Visual BI blog, Padmasaran Sathiakumar delves into the Power Apps visual for Power BI

🚀 Deployment, Security and Operations

Imke Feldmann (@TheBIccountant) describes how to Split up an existing Power BI report into a Golden Dataset and a thin report
Kasper de Jonge (@kjonge) describes how to Refresh the table fully after setting up incremental refresh with TMSL
Magnus Lander describes Reverse engineering Power BI templates for a complete source control solution
On the BlueGranite YouTube channel, Angela Henry (@SQLSwimmer) writes about Unauthorized Gateways Power BI
Adam Saxton (@GuyInACube) talks about Why is my Power BI refresh so SLOW?!? 3 Bottlenecks for refresh performance
On the Power BI community blog, Ted Pattison (@TedPattison) provides the Power BI Dev Camp Session 2: September 24th Details
Olivier Travers (@otravers) discusses Refreshing Power BI Datasets & Dataflows with APIs and Power Automate

🌐 General

On the Power BI blog, Christopher Finlan (@cmfinlan) highlights that Power Automate actions for exporting Power BI and paginated reports now available
Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) shares the Updates to the ‘new look’ experience and release plan
Also on the Power BI blog, Justyna Lucznik (@JustynaLucznik) writes about the Gartner Analytics and BI Virtual Bake-Off 2020: world population health analysis with Power BI
Marc Lelijveld (@MarcLelijveld) discusses Driving a data culture with Power BI – Part 1 – What is a data culture? and highlights the Power BI icon library for Diagrams.net (draw.io)
Matthew Roche (@SQLAllFather) writes about Data Culture: Now you’re thinking with portal
Adam Saxton (@GuyInACube) explains how to Standardize Power BI, Power BI report design and more… (Roundup | Sept 14, 2020)
Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE (Sept 19, 2020)
Spencer Baucke (@JSBaucke) provides a Price Point Comparison: Tableau v Power BI
Gregory Petrossian (@gregpetrossian) writes about the DA-100 Microsoft Exam: How to Prep and Pass
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes 5 interactions possibles entre Excel et Power BI [French]
Neil Hambly (@Neil_Hambly) talks about the Power BI DIAD 'Dashboard-in-a-Day' (28 Sept 2020) - FREE Virtual Workshop