Power BI Weekly
Issue #111 - 25th May 2021
Quite a quiet week this week. Hardly any data preparation articles... Has everyone fallen out with Power Query? Maybe it's quiet because we're all preparing for the Microsoft Build Summit taking place today until the 27th - it's free, there are loads of great sessions scheduled, including AMA (Ask Me Anything) sessions giving you the chance to ask your questions to the powers-that-be within Microsoft. Make sure you check it out! Otherwise, there's just the one main announcement this week, and that's the support for Power BI + Denodo Single Sign-On (SSO) using the Data Gateway.
The Power BI team has also released some Best practice rules to improve your model's performance and design (v1.1) which provides some updates to those announced in an article a few months ago. Elsewhere, Mara Pereira has continued the handy Power BI Report Development 101 series, writing Report Development 101 - Part 2, covering elements including RLS and Q&A. Finally, Mihaly Kavasi has written about How to tame Power BI - Get in control before it gets out of control referring to numerous admin operations that can help administer the use of Power BI in your organization.
🛠️ Data Prep
- Mike Allen (@MikeAinOz) writes about the Improved Planner Data Model
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Extract Dates from Sentences Located anywhere in a Cell in Excel | Excel Formula OR Power Query?
🧩 Data Modeling
- On the Power BI blog, Michael Kovalsky shares some Best practice rules to improve your model’s performance and design v1.1
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a couple of tutorials: REMOVEFILTERS – DAX Guide, CALENDAR, CALENDARAUTO – DAX Guide and describes how to Show blank as zero – Unplugged 20
- Also on the SQLBI blog, Marco Russo (@marcorus) highlights the Development Tools for Power BI and Analysis Services models – Live Event
- Ted Pattison (@TedPattison) talks about Advanced Data Set Programming with Power BI
- Chris Webb (@cwebb_bi) writes about Ten Reasons Why Im Excited About The New Power BI/Excel Integration Features
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Create a subset of the table in Power BI and add calculations using SELECTCOLUMNS DAX Function
- On the Enterprise DNA blog, Nick Mone shares a few blogs: VertiPaq Engine Power BI: An Introduction, VertiPaq Compression And Storage In Power BI, VertiPaq Power BI: How Columns Are Encoded, VertiPaq Storage Engine On Multi-Threaded Environment and What Is DAX Studio In Power BI Desktop?
- Brian Julius talks about Free Power BI Resource Collection Including Dataset Builder Tool
- Ruth Pozuelo Martinez (@CurbalEN) shares DAX Fridays! #209: Allocation calculations in DAX | GENERATE
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes a Forecasting Measure in Power BI
- Hima Bindu Marri (@sivahimabindu) explains How to fix Blank value in slicers in Power BI Power BI for beginners
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes [DAX] Visualizar -N meses seleccionando uno [Spanish]
📊 Report Authoring and Interactivity
- Patrick Leblanc (@GuyInACube) provides A TWIST on dynamically filtering visuals by a slicer in Power BI
- Mara Pereira (@datapears) writes Power BI Report Development 101 - Part 2
- Reid Havens (@HavensBI) talks about Toggling Report Page Tooltips with Bookmark Buttons
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Create allocation table and visualize it in a Gantt Charts with matrix in Power Query
- On the Enterprise DNA blog, Paul Lucassen blogs about the Power BI Icon Map Visual: WKT Strings
- On the Data Bear blog, Mariska Oosthuizen discusses Key influencers – Power BI AI visuals
- Matthew Peterson (@mattpetersonbi) discusses the Personalize Visuals Feature
- Chandeep Chhabra (@chandeep2786) talks about the Waffle Chart in Power BI
- Bas Dohmen (@HowToPowerBI) writes about the Mobile Layout in Power BI
- Dhruvin Shah (@DhruvinShah16) writes about the Modern Visual Tooltip in Power BI, explains how to Maintain Tab Order for Power BI Report and writes about Quick Edit Power BI Paginated Report from Power BI Service
🚀 Deployment, Security and Operations
- On the Power BI blog, Kay Unkroth covers Power BI + Denodo = End-to-end security through Single Sign-On (SSO)
- Adam Saxton (@GuyInACube) talks about My CHECKLIST for troubleshooting Power BI Performance
- Mihaly Kavasi describes How to tame Power BI – Get in control before it gets out of control
- Cyrus Christian shares the Premium Capacity Metrics App for Gen2 for Government Cloud
- On the Data Bear blog, Edward Van Der Merwe blogs about Goals in Power BI
🌐 General
- On the Power BI blog, Miguel Martinez (@maikelson) explains how to Learn, Connect, and Code at the Microsoft Build Summit! May 25th-27th, 2021
- James Serra (@JamesSerra) discusses What's new with Power BI
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 192 - Power BI May 2021 Feature Summary
- Matt Allington (@ExceleratorBI) writes about the The Top 30 Reasons You Should Be Considering Power BI
- On the MSSQLTips site, Scott Murray discusses SSRS vs Power BI
- Adam Saxton (@GuyInACube) covers Power BI tips from the Pros – LIVE w/ Marco Russo (May 22, 2021)
- Sam McKay (@_EnterpriseDNA) explains how to Create Value With Your Power BI Analytics
- Greg Philps lists the Top 10 Power BI Best Practices
- Flavio Meneses describes How to ace the Power BI DA-100 exam