Power BI Weekly
Issue #112 - 1st June 2021
Another year, another BUILD event with plenty of talking points for Power BI. As ever, Arun Ulag has written a debrief on the whole event: Enabling intelligent experiences with Power BI for developers, data scientists, and data engineers, discussing BUILD announcements and things to look forward to in the very near future. Creating DAX expressions from natural language text being one of them... will there be a day where we don't have to write DAX code ourselves? 😲
Here are the things that have launched in the last week:
- Automate deployments with deployment pipelines API (preview)
- Power BI in Jupyter notebooks
- Quickly create reports from SharePoint lists
- Power BI Report Server May 2021 Feature Summary
- Updated home experience in the Power BI app for Microsoft Teams
I personally find the first and second points particularly interesting - the first is a step closer to full automation of ALM scenarios for Power BI artifacts, and the second is a match made in heaven for those preferring the explorative, visual way of developing solutions.
A couple of books have been released this week that I wanted to highlight. If you've ever had to design Power BI themes from scratch, you'll appreciate how non-trivial it is (though it's a much nicer experience now than it has been in the past!) Adam Aspin's new book Power BI Theme Creation is a deep-dive into all things theming in Power BI, helping you on your styling journey. Elsewhere Daniil Maslyuk has highlighted that the Microsoft Exam Ref DA-100 is now available, a great resource for those looking to take the DA-100 exam.
🛠️ Data Prep
- Soheil Bakhshi (@biinsightnz) writes about Connecting to Excel Files Stored in SharePoint Online from Power BI Desktop
- On the Power BI community blog, Kumail covers Query Folding in PowerBI
- Also on the Power BI community blog, Yingjie Li talks about Json Transformations
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) covers Unpivot in Power Query
- Bas Dohmen (@HowToPowerBI) talks about Conditional JOIN using Power Query A different way of merging in Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Showing Ranking in a Visual in Power BI using RANKX DAX function and describes how to Document a Power BI file and report in a few clicks all DAX code visualization Power Query scripts
- Melissa de Korte (@_EnterpriseDNA) talks about a Perpetual Holiday Calendar In Power BI - Power Query Solution
- Bas Dohmen (@HowToPowerBI) describes Showing last refresh in Power BI
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Understanding eager vs. strict evaluation in DAX, describes DATE, TIME – DAX Guide and covers DATEDIFF, YEARFRAC – DAX Guide
- Marco Russo (@marcorus) talks about Optimizing the distribution of distance between transactions - #Unplugged 21
- Philipp Lenz (@lenz_philipp) writes about Why should you create explicit measures?
- Spencer Baucke (@JSBaucke) explains How to Create YTD Calculations in Power BI and covers The CALCULATE Function in Power BI
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) explains How to Create a Rating Visual in Power BI using DAX
- Chandeep Chhabra (@chandeep2786) explains how to Calculate Growth over Previous Quarter End Month – DAX Challenge
- Reid Havens (@HavensBI) describes Adding Dynamic Multi Value Data Labels to Visuals with Kane Snyder and describes How the Microsoft Power BI Team Evolves the Platform with Will Thompson
- Hima Bindu Marri (@sivahimabindu) describes How to fix Blank value in slicers in Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about the TOPN DAX Function - How it works in Power BI - Comparison against the top group
- Also on the Enterprise DNA blog, Paul Lucassen blogs about a Distance And Bearing Calculation: Power BI Geospatial Analysis and talks about Center Of Gravity Analysis In Power BI
- On the Enterprise DNA blog, Nick Mone discusses the VertiPaq Engine In Power BI – Usage & Best Practices, writes about the VertiPaq Analyzer In DAX Studio and shares a VertiPaq Analyzer Tutorial: Relationships & Referential Integrity
- Also on the Towards Data Science blog, Peter Hui writes about Power BI Modelling
📊 Report Authoring and Interactivity
- On the Power BI blog, Amanda Rivera (@MissAmandaN) describes how to Quickly create reports from SharePoint lists and provides the Power BI Report Server May 2021 Feature Summary
- Also on the Power BI blog, Amit Shuster (@ShusterAmit) announces Power BI in Jupyter notebooks
- On the Power BI community blog, David Edelman describes Creating a Visual Calendar in Power BI
- Patrick Leblanc (@GuyInACube) presents Exploring anomaly detection in Power BI and a sneak peak (with Justyna Lucznik)
- Adam Saxton (@GuyInACube) talks about 3+ approaches for Dynamic Axis in Power BI
- Jarrett Moore (@BuckeyeJarrett) describes Using Charticulator To Conditionally Highlight Bar Chart
- Chandeep Chhabra (@chandeep2786) talks about a Fiscal Year Date Table in Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes how to Export the Data of a Power BI table entirely in a few Clicks
- Matt Allington (@ExceleratorBI) explains how to Build a P&L in Power BI Without Any DAX
- Dhruvin Shah (@DhruvinShah16) talks about Quick Edit Power BI Paginated Report from Power BI Service and describes how to Quickly create Power BI Report from SharePoint List or Microsoft List
- Belinda Allen (@MsBelindaAllen) talks about More Matrix visual formatting in Microsoft Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Nimrod Shalit describes how to Automate deployments with deployment pipelines API (preview)
- Sujata Narayana demonstrates Easy report sharing using links in Microsoft Power BI
- Matthew Roche (@SQLAllFather) blogs about Data Governance and Self-Service Business Intelligence
🌐 General
- Also on the Power BI blog, Arun Ulag (@arunulag) talks about Enabling intelligent experiences with Power BI for developers, data scientists, and data engineers
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) writes Announcing: Now its easier to find Power BI reports in Microsoft Teams tabs
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays! #210: Is the end of DAX coding near? - Microsoft Build announcements for Power BI
- Dhruvin Shah (@DhruvinShah16) talks about Microsoft Build 2021 - Power BI Announcements
- Rutuja Shivraj Pawar writes about T-profile in Power BI
- Gil Raviv (@gilra) updates the Bitcoin Calculator in Power BI
- Daniil Maslyuk (@DMaslyuk) highlights that Microsoft Exam Ref DA-100 is now available
- Gregory Petrossian (@gregpetrossian) writes about Business Intelligence Tools: A Pros and Cons Comparison Chart
- Reid Havens (@HavensBI) describes How the Microsoft Power BI Team Evolves the Platform with Will Thompson
- Adam Saxton and Patrick Leblanc (@GuyInACube) share Power BI tips from the Pros – LIVE w/ Kasper de Jonge (May 29, 2021)
- Mara Pereira (@datapears) writes about My views on Power BI core skills