Power BI Weekly

Issue #68 - 21st July 2020

Some very exciting announcements this week. As part of the Power BI Desktop July 2020 Feature Summary, we've been told about the new (preview) external tools in Power BI Desktop, allowing you to launch your favourite tools right from within the application. Are you wondering why some of the tools aren't showing? Adam Saxton goes through how to fix that. Elsewhere, we've been told that the Azure Maps Power BI visual now in preview, including bubble layers, 3D bar chart layers, amongst other cool features. Finally, the Power BI team is saying Thank You for 5 Years as Power BI reaches its fifth official anniversary. I'm sure you'll all join me in thanking the Power BI team for building such a wonderful product thus far, and wishing them the best for the next five years!

🛠️ Data Prep

Ben Gribaudo (@bgribaudo) talks about Editing Report/Spreadsheet Mashups in VSCode
Chris Webb (@cwebb_bi) describes Adding Tooltips To Column Headers In The Power Query Editor In Power BI And Excel
On the Power BI community blog, Shinjini Ghosh describes Custom Connector in Power Automate/Microsoft Flow for Power BI Data Flow Refresh
Gil Raviv (@gilra) describes how to Import WHO COVID-19 data from PDF
Rick de Groot (@ExcelGorilla) describes The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
On the Prologika blog, Teo Lachev (@tlachev) covers Conquering Time Zones
Jeff Lenning (@Exceluniversity) describes how to Insert X Rows to Expand Table
Imke Feldmann (@TheBIccountant) explains how to Transform a query into a function in Power Query and Power BI
On the Excel Basement YouTube channel, Oz du Soleil (@OzExcel) explains how to Transpose, Unpivot and Normalize Data - POWER QUERY
Also on the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) explains how to Create a Unique List from multiple data lists, Append Data, Remove Duplicates - POWER QUERY
Ruth Pozuelo Martinez (@ruthpozuelo) describes how to Insert blank rows at each category in Power Query
Leila Gharani (@LeilaGharani) explains how to Unpivot Data with Multiple Headers Multiple Row levels into Columns with Power Query
Sam McKay (@_EnterpriseDNA) talks about Real-World HR Analysis Development - Power BI Challenge 3 Submission and talks about Adding Parameter in Data Table M Function - Query Editor Tutorial

🧩 Data Modeling

On the SQLBI blog, Marco Russo (@marcorus) describes Creating calculation groups in Power BI Desktop using Tabular Editor and walks through Creating Calculation Groups in Power BI Desktop
Kasper de Jonge (@kjonge) shares a few blogs: Adding Calculation Groups using the Tabular Object Model., Creating a Time intelligence External Tools app for Power BI Desktop and ,, Calculation group TMSL example
Darren Gosbell (@darrengosbell) highlights that DAX Studio 2.11.2 Released
Zach Renwick (@zachrenwick) writes about Incremental Refresh in Power BI: How to Make Dataset Refreshes 95% Faster
Matt Allington (@ExceleratorBI) explains how to Replace GUIDs with a Surrogate Key for Better Performance
Patrick Leblanc (@GuyInACube) wonders Do you need a date table for time intelligence in Power BI? Nope! (Quick Measures)
On the Towards Data Science blog, Nikola Ilic (@DataMozart) discusses TIQ Part 2—Your Majesty: Date Dimension
On the CSG Pro blog, Brian Grant (@BrianGrantBI) describes how to Understand the Elements to Demystify DAX
Chandeep Chhabra (@chandeep2786) shares a Calculate New Subscribers Added – DAX Challenge
Ruth Pozuelo Martinez (@ruthpozuelo) shares DAX Fridays 180: Find text in columns using DAX
Reid Havens (@HavensBI) posts a QUICK TIP: Best Practice When Creating New DAX Measures
Sam McKay (@_EnterpriseDNA) discusses HR Consultation Insights - Power BI Speed Build
Also on the Power BI Community blog, Mounika Narayana Reddy describes Different Ranking Scores for Identical Sales Amount with RANKX Function

📊 Report Authoring and Interactivity

Also on the Power BI blog, Christian Wade (@_christianWade) announces the public preview of external tools in Power BI Desktop
Adam Saxton (@GuyInACube) talks about EXTERNAL TOOLS in Power BI Desktop... are MISSING???
Olivier Travers (@otravers) writes about Third-Party Tools to Ease Power BI Development and Increase Analyst Productivity
Paul Turley (@paul_turley) writes about Power BI External Tools: Reading the Tea Leaves
On the Azure blog, Ricky Brundritt (@rbrundritt) shares that Azure Maps Power BI visual now in preview
On the Power BI community blog, James Raddock writes about Power BI Export Limitations: Part 3 & 4
Also on the Power BI community blog, Paul Brown writes about Power BI Tips and Tricks: Reversing the Y-Axis in a Line Chart Visual
Laura Graham-Brown (@Laura_GB) introduces Sync Slicers
On the Enhansoft blog, Leonard Suares (@SuaresLeonard) writes about What Are the Differences Between a Power BI Slicer and a Filter
Gilbert Quevauvilliers (@GilbertQue) blogs about Showing Dates in reverse order for Tables/Matrix with dates, so that the latest is always shown first in a Power BI Matrix
On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) describes Adding Up and Down Arrows to KPIs in Power BI
Vivek Ranjan (@imvivran) discusses Power BI Q&A: July 2020 Update and talks about Power BI QuickBytes: Explaining change with Insights
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes how to Change the Column or Measure Value in a Power BI Visual by Selection of the Slicer Parameter Tabl, describes Using SVG in Power BI with Laura Graham-Brown and writes about One Dimension Filters Another Dimension in Power BI
Dhruvin Shah (@DhruvinShah16) explains how to Add Gradient Legend to Power BI Visual
On the Power BI Community blog, Mounika Narayana Reddy solves an issue: Pre-Selected Value Appears in the Slicer for a Report with RLS

🚀 Deployment, Security and Operations

Richard Tkachuk (@richardtkachuk) describes How to Cancel a Power BI Refresh
On the MSSQLTips site, Scott Murray covers Power BI Workspace Permissions and Roles
Dhruvin Shah (@DhruvinShah16) describes the Difference between Member and Contributor Role in Power BI
On the Power BI Community blog, Chandrika Ravuri describes Querying Premium Capacity Health Metrics Using XMLA End Point
Also on the Power BI Community blog, lbendlin writes about Incremental Refresh with Slow-Changing Source Data
On the SQL Shack blog, Aveek Das (@avikoleum) explains how to Migrate Power BI reports between multiple workspaces

🌐 General

On the Power BI blog, Kelly Kaye (@MS_KellyKaye) writes Thank You for 5 Years
Also on the Power BI blog, Sujata Narayana blogs about Power BI Desktop July 2020 Feature Summary
Also on the Power BI blog, Sandy Rivas (@SandyRivas) shares the June 2020 Community Highlights
Also on the Power BI blog, Lauren Faber explains How Metro BankUses Power BI to Improve the UK Banking Experience
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 153 - 2020 Release Wave 2 Plan for the Power BI Service review
Just Blindbæk (@justblindbaek) writes Power BI Quiz. Who, What, When, Where, Why, How
The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 127
Devin Knight (@knight_devin) covers Power BI Monthly Digest – July 2020 with Matt Peterson
Adam Saxton (@GuyInACube) shares the REPLAY Power BI tips from the Pros – LIVE (July 18, 2020)
Ruth Pozuelo Martinez (@ruthpozuelo) shares a Review of Power BI Desktop update July 2020 features in 6 minutes
On the Burningsuit blog, Stuart Box (@StuartBox) describes Sentiment Analysis in Power BI, analyse text reviews and a Premium tip.
On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] Qiita の投稿記事を API でデータを取得して Power BI で可視化＆分析したい [Japanese]