Power BI Weekly

Issue #110 - 18th May 2021

Lots of announcements this week:

Not only that, but we've been given the Power BI May 2021 Feature Summary. Main features this month are the new visual tooltip with added drill actions, additions to DQ over Power BI Datasets functionality (lineage view, Q&A support), and a few features reaching GA.

Elsewhere this week, Carmel Eve has described How to use Azure Synapse SQL Serverless to connect Data Lake and Power BI, and Seth Bauer has written a comprehensive blog about How to Represent Your Power BI Skills, giving some sound advice for those thinking about or applying for a role requiring Power BI skills, but really the advice can be applied more generally for any technical skillset.

🛠️ Data Prep

On the endjin blog, Carmel Eve (@carmel_eve) explains How to use Azure Synapse SQL Serverless to connect Data Lake and Power BI
Yousry Mohamed writes about Azure Synapse Analytics & Power BI
On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) describes how to Split Amount Across Months Using Power Query
Gil Raviv (@gilra) shares a New Recording: Low-Code Data Quality Automation
Ruth Pozuelo Martinez (@CurbalEN) explains how to Get Power BI data in Excel without Pivot Tables | Excel Data Types
Asanka Padmakumara (@asanka_e) writes Struggling to work with large models in your PC? This could help you
On the MSSQLTips site, Kenneth A. Omorodion explains How to Create Date Dimension Tables in Power BI from Text Columns
Philipp Lenz (@lenz_philipp) covers Stream Analytics and Power BI
On the Power BI Community blog, Dedmon Dai writes about the Refresh error: The xxxx column does not exist in the rowset

🧩 Data Modeling

Phil Seamark (@PhilSeamark) writes about DAX : Count number of last known state
On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: KEEPFILTERS – DAX Guide, LOOKUPVALUE – DAX Guide, ALLCROSSFILTERED – DAX Guide and describes how to Show previous 6 months of data from single slicer selection
Marco Russo (@marcorus) talks about Displaying the distribution of distance between transactions – Unplugged #19
Rick de Groot (@ExcelGorilla) writes about 5 ways to calculate last 12 months in DAX for Power BI
Patrick Leblanc (@GuyInACube) describes how to Test your Power BI DAX measures in DAX Studio
Adam Saxton (@GuyInACube) talks about some Tools to take Power BI to the NEXT LEVEL
Matthew Peterson (@mattpetersonbi) shares DAX Function USERELATIONSHIP Explained
On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shares an Advanced Sales Analytical Dashboard in POWER BI - Advanced DAX | Time Intelligence & KPIs | Measures
Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays #208: Open orders in DAX | Events in progress & Time intelligence
Reid Havens (@HavensBI) talks about the ALM Toolkit External Tool with Christian Wade
Hima Bindu Marri (@sivahimabindu) explains how to Calculate LTD in Power BI
On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes How to use AddColumns function in DAX and Power BI and blogs about Power BI & Excel - with Tristan Malherbe
On Qiita, Yugo Shimizu (@yugoes1021) writes [Power BI Tips] デフォルトで「今月」を表示するには？[Japanese]
Chandeep Chhabra (@chandeep2786) discusses Summing Visible Values of a Table in Power BI

📊 Report Authoring and Interactivity

On the Power BI blog, Rien Hu shares the Small Multiples (Preview) – Roadmap Updates
Matthew Peterson (@mattpetersonbi) talks about the Small Multiples Preview Feature
Belinda Allen (@MsBelindaAllen) describes Using Small Multiples in Microsoft Power BI
Brian Julius writes about the New Modern Visual Tooltips For Power BI
Chris Webb (@cwebb_bi) shares a Video: Advanced Analytics Features In Power BI
On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) discusses Microsoft Power Automate inside Power BI
Alex Badiu (@BadiuAlexandru) discusses The Ultimate Dynamic Menu In Power BI
On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) describes 3 façons d’utiliser les cartes de formes (shape maps) dans Power BI [French]

🚀 Deployment, Security and Operations

On the Power BI blog, Lukasz Pawlowski (@lukasztweets) highlights More control over when Azure Active Directory B2B guest users appear in lists of suggested people
Also on the Power BI blog, Kay Unkroth describes Using Out-Of-Line Bindings in Power BI
Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) explains how to Add and Edit Power BI data sources on Power Platform Admin Center
On the Power BI blog, Teddy Bercovitz (@Teddybbb) announces template apps one-click update
Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) shares that the On-premises data gateway May 2021 update is now available
On the DAX Pro Services blog, Jesus Gonzalez describes how to Query catalog of a Power BI workspace with Azure Functions
Chris Webb (@cwebb_bi) shares a Video: Performance Tuning Power BI Dataset Refresh
Phil Seamark (@PhilSeamark) describes how to Visualise your Power BI refresh – in real-time
Gilbert Quevauvilliers (@GilbertQue) writes about Query Performance – Part 1 Migrating Azure Analysis Services to Power BI Premium Per User
Reid Havens (@HavensBI) describes how to Dynamically Filter Page Navigation Per User With Row Level Security (RLS)
Dhruvin Shah (@DhruvinShah16) talks about the New Sharing Experience for Power BI Reports
Imke Feldmann (@TheBIccountant) describes how to Fix error “..prod.powerquery.microsoft.com refused to connect” in Power BI dataflows
Bas Dohmen (@HowToPowerBI) talks about GOALS in Power BI
On the Marquee Insights blog, Treb Gatte (@tgatte) writes Power BI Goals Introduction – Part 2
On the Prologika blog, Teo Lachev (@tlachev) takes A First Look at Power BI Goals
On the CSG Pro blog, Brian Grant (@BrianGrantBI) writes about What to Expect When You're Expecting a Power BI Implementation

🌐 General

On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) blogs about the Gartner Modern Analytics and BI Platforms Bake-off 2021: Analysis of impact of COVID-19 with Power BI
Also on the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI May 2021 Feature Summary
Will Thompson (@Will_MI77) talks about the Gartner Modern Analytics and BI Platforms Bake-off 2021: Analysis of impact of COVID-19
On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 191 - Interview with Miguel Llopis
On the Enterprise DNA blog, Paul Lucassen writes about Huff Gravity Model Analysis in Power BI
Adam Saxton (@GuyInACube) shares Power BI tips from the Pros – LIVE (May 15, 2021)
On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) explains How to Represent Your Power BI Skills
Ruth Pozuelo Martinez (@CurbalEN) talks about Power BI Desktop Update May 2021 and MBAS