Power BI Weekly

Issue #69 - 28th July 2020

If React is part of your toolkit, then you're in luck this week - there's a new Power BI component for React to more easily embed your reports into React applications. The other couple of updates this week regard the new On-premises data gateway July 2020 update in which there's been added support for OAuth authentication via the gateway, and then there's the Power BI Service and Mobile May and June 2020 feature summary rounding up the last couple of months' worth of updates.

Elsewhere this week, Ruth Pozuelo Martinez has demonstrated 20 tricks to finally master the Matrix visualization in Power BI, and David Eldersveld has written a three part series about using Python as an External Tool for Power BI Desktop - here's Part 1.

🛠️ Data Prep

Chris Webb (@cwebb_bi) discusses Returning Annotations From OData Sources In Power BI/Power Query
On the Power BI community blog, spgvizcube describes ETL Through Multiple Pages of a Website in Power BI
On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) discusses Getting Started with APIs in Power Query
Chandeep Chhabra (@chandeep2786) explains how to Create Dynamic File Path in Power Query
On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) writes about Animated Scroll Bar / Scroller Visual in POWER BI, Get data from Pakistan Stock Exchange Website PSX and describes how to Extract Dates from Text - Column from Examples POWER QUERY - Microsoft Excel
Melissa de Korte explains how to Create A Perpetually Updated Practice Dataset in Power BI
On the Power BI Community blog, lbendlin writes It's the weekend! Or is it?
Marcus Wegener (@PowerBIler) posts Hey Peter! In Power BI Spalten entpivotieren [German]

🧩 Data Modeling

Also on the Power BI community blog, Greg Deckler (@GregDeckler) discusses CALCUHATE - Why I Don't Use DAX's CALCULATE Function
Patrick Leblanc (@GuyInACube) writes about the NEW way to create measures in Power BI
Gilbert Quevauvilliers (@GilbertQue) describes Validating Power BI DAX measures when using Tabular Editor
On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes TIQ Part 3—Ultimate Guide to Date dimension creation
Parker Stevens (@PowerBIElite) blogs about Power BI - Filter by a Measure in a Slicer
Ruth Pozuelo Martinez (@ruthpozuelo) shares DAX Fridays #182: Virtual relationships with CONTAINS DAX function
On the Power BI community blog, DavisBI talks about Iteration in DAX
Also on the Power BI community blog, Mounika Narayana Reddy writes about the Redundant 'IF(Divide)' Statement and Power BI Report Performance Issues
On the CSG Pro blog, Rachel Dyer (@rachelrdyer) shares a DAX Tutorial: The Most Important Practice For New DAX Developers
Lars Schreiber (@SchreiberLars) writes about Die Herausforderung sich ändernder Dimensionen in Power BI [German]
On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of posts: Dynamic Segmentation With Dynamic Parameters – Advanced Power BI & DAX Technique, Common Time Intelligence Patterns Used In Power BI, Top Customer Per Product – Power BI Analysis, Using The MAXX DAX Function In Power BI To Calculate Recent Values In Your Data, Creating A Pareto Chart In Power BI – Advanced DAX, Calculate A Year-To-Date YTD Monthly Moving Average In Power BI, Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique, Using AVERAGEX In Power BI – A DAX Tutorial & Examples and Five Strategies to Enhance Your DAX Toolbox
On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) explains how to Analyze in Excel – the Advanced Method

📊 Report Authoring and Interactivity

David Eldersveld (@dataveld) writes about Python as an External Tool for Power BI Desktop: Part 1, Part 2 – Create a PBITool.json File and Part 3 – Virtual Environments and TOM Connection
Matt Allington (@ExceleratorBI) writes about External Tools in Power BI Desktop
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a DAX 101: Mark as Date table
On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) describes Power BI Report Guides
Vivek Ranjan (@imvivran) describes how to Show or Hide measures using Slicer: Power BI
Ruth Pozuelo Martinez (@ruthpozuelo) writes about 20 tricks to finally master the Matrix visualization in Power BI
Reid Havens (@HavensBI) talks about the Color Gradient Legend for Native Visuals in Power BI
Laura Graham-Brown (@Laura_GB) covers Power BI – Gradient Legends
Dhruvin Shah (@DhruvinShah16) writes about Getting Started with Azure Maps visual in Power BI and describes how to Change Header Text for Power BI Slicer Value
Mike Allen (@MikeAinOz) writes about Starability - An Active BI Story
On the xViz blog, Bhupinder Singh writes about the xViz Linear Gauge – Progress Bar for MS Power BI and blogs about xViz Adv Pie and Donut for Power BI
Also on the xViz blog, Marisharannath Chandran Soundarnath writes about Conditional formatting in xViz Gauges for MS Power BI
On LaDataWeb, Bruno Zurita writes Leyes de UX aplicadas a Power Bi - Episodio 1 [Spanish]

🚀 Deployment, Security and Operations

On the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) announces that the On-premises data gateway July 2020 update is now available
On the Power BI community blog, Srishti Sharma writes Unable to Connect to Power BI Through XMLA Endpoint Using SQL Profiler
Also on the Power BI community blog, Sumana Biswas writes Unable to Open a Paginated Report in PBI Service
Also on the Power BI community blog, Anamika Goswami shares some PowerShell Scripts to Export Power BI Reports to PBIX/PDF/PPT
Olivier Travers (@otravers) writes about Row Level Security in Business Intelligence Applications: A Practical Overview
On the Power GI blog, Cyrus Christian highlights that Deployment Pipelines in Premium government cloud
On the Blue Granite blog, Kirtis Carpenter blogs about Power BI for Government Agencies - Auditing Logins
On the Prologika blog, Teo Lachev (@tlachev) writes about Why You Need a Trusted Advisor

🌐 General

On the Power BI blog, Amit Shuster (@ShusterAmit) announces React Power BI
Also on the Power BI blog, Nikhil Gaekwad (@NikhilGaekwad) describes the Power BI Service and Mobile May and June 2020 feature summary
Adam Saxton (@GuyInACube) discusses the Power BI Desktop update and more... (Roundup | July 20, 2020)
Adam Saxton and Patrick Leblanc (@GuyInACube) share the REPLAY Power BI tips from the Pros – LIVE (July 25, 2020)
Matt Allington (@ExceleratorBI) blogs about Power BI Birthday Number 5
Spencer Baucke (@JSBaucke) covers Analyzing Tableau and Power BI: A Conversation with Sekou Tyler
BI Polar shares 5've Got All The Swords and provides A Brief History of Business Intelligence
Avi Singh (@powerbipro) shares the Talk Power BI LIVE Q&A (July 24, 2020)
Reza Rad (@Rad_Reza) talks about Power BI Design Patterns