Power BI Weekly

Issue #86 - 24th November 2020

In the last week, Arthi Ramasubramanian Iyer has told us that that the On-premises data gateway November 2020 update is now available, including a new Hive LLAP connector, software updates and deprecation notices, and Chris Finlan has taken us on a tour about the new Power BI Premium Per User Administrative Settings, which include the now-more-granular (and therefore flexible!) export settings, allowing an admin to toggle exporting on and off on a file-format basis. Elsewhere this week, Spencer Baucke has continued the 'Power BI for Tableau Developers' series, this time talking about Slicers & Filters, and Colby Ford has written about ingesting and analyzing Bioinformatics and Genomics file in Power BI.

🛠️ Data Prep

On the Blue Granite blog, Colby Ford talks about Reading Bioinformatics and Genomics Files in Power BI
On the Power BI community blog, Chris Mendoza explains how to Create a Custom Period Calendar in Power Query
Also on the Power BI community blog, Dedmon Dai describes how to Use Column as Parameter for Custom Function in Power Query
Andy Cutler (@MrAndyCutler) blogs about Creating a Power BI Solution using Dataflows for Aggregations
Laura Graham-Brown (@Laura_GB) covers Power BI Dataflow – New Diagram View and Power BI Dataflows – Endorsement as Promoted and Certified
Ruth Pozuelo Martinez (@CurbalEN) talks about Dataflows and power query - November 2020 update and provides a Quick guide to create new Dataflows in Power BI
Imke Feldmann (@TheBIccountant) explains How to refresh Power Queries on protected sheets in Excel
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) discusses the Power BI Query Editor: Row & Column Transformations, talks about Power Query Editor: Staging Queries, describes How To Append Power Queries In Power BI and explains How To Unpivot Columns In Power BI
Chandeep Chhabra (@chandeep2786) explains how to Expand All Columns Dynamically in Power Query

🧩 Data Modeling

Phil Seamark (@PhilSeamark) talks about the DAX Formatter tool for Power BI Desktop
Matt Allington (@ExceleratorBI) writes about Which Columns are Not Used in my Power BI Data Model
On the Power BI Tips and Tricks blog, Stephanie Bruno (@StephTBruno) releases Power BI Field Finder V2
On the CSG Pro blog, Gregory Petrossian (@gregpetrossian) shares the recording: Tabular Editor in an Hour by Alex Powers
On the Business Intelligist blog, Business Intelligist (@bizintelligist) shares Part I – The Definitive Guide to Price Volume Mix Calculation PVM in Power BI – Theory and Part II – The Definitive Guide to Price Volume Mix Calculation PVM in Power BI – The Perfect Mix
Parker Stevens (@PowerBIElite) talks about DAX for Power BI - Easy Cohort Analysis
On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) walks through Switching Metrics in Power BI
On the Power BI Community blog, Amit Chandak (@amitchandak78) describes How to divide/distribute values between start date or end date or count days across months/days
On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) shares 3 hidden tricks in Power BI

📊 Report Authoring and Interactivity

Spencer Baucke (@JSBaucke) shares Power BI for Tableau Developers: Slicers/Filters
Patrick Leblanc (@GuyInACube) describes Using Images from a Database in Power BI
Brent Allen (@MacrordinaryCA) explains how to Make a KPI Card like Power BI – In Excel
Matthew Peterson (@mattpetersonbi) writes about a Unique Ask For Drill Through
Dhruvin Shah (@DhruvinShah16) explains how to Add Zoom Sliders on Axis in Power BI Visual and talks about Anomaly Detection in Power BI
Reid Havens (@HavensBI) talks about Automatic Anomaly Detection for Line Charts in Power BI
On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) talks about Time series Anomaly Detection in Power BI (Part One)
On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] 折れ線グラフって色を条件によって変えられないんですけど、偶然変える方法を見つけました🥳 [Japanese]
On LaDataWeb, Bruno Zurita writes Leyes de UX aplicadas a Power Bi - Episodio 3 [Spanish]

🚀 Deployment, Security and Operations

On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway November 2020 update is now available
Michal Foster Heldy describes How to auto play slideshows for the Power BI mobile app
Christopher Finlan (@cmfinlan) shares a Power BI Premium Per User Administrative Settings Update
On the Power BI Tips and Tricks blog, Parker Stevens (@PowerBIElite) talks about Building a Power BI Admin View using Power BI APIs
Chris Webb (@cwebb_bi) writes about Delaying Power BI Dataset Refresh Until The Source Data Is Ready

🌐 General

Adam Saxton (@GuyInACube) covers Tons of Power BI updates last week… (Roundup | Nov 16, 2020) and says that Sometimes you just need guidance
Paul Turley (@paul_turley) writes about Doing Power BI the Right Way: 8. Planning for separation – data models & reports
Gilbert Quevauvilliers (@GilbertQue) writes about the Updated Look for External Guest Users in Power BI And a way to see the Navigation Pane
Adam Saxton and Patrick Leblanc (@GuyInACube) present 🔴 Power BI tips from the Pros – LIVE (Nov 21, 2020) (Member Chat 2nd Half)
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes Power BI & Synapse Part 2—What Synapse brings to Power BI table
Ted Pattison (@TedPattison) presents Power BI Dev Camp: Deep dive into Power BI JavaScript API
Brett Powell (@BrettPowell76) describes Larry Bird vs. Lebron James - Power BI Report
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 169 - Power BI November 2020 Feature Summary
Devin Knight (@knight_devin) shares the Power BI Monthly Digest – November 2020 with Matt Peterson