Power BI Weekly
Issue #147 - 8th March 2022
It's a pretty short edition this week, with no announcements. I wonder whether that's because lots of people have been preparing for their SQLBits sessions, which is taking place in London (starting today). I'm attending on Thursday, Friday and Saturday, so if anyone's around and wants to meet, feel free to drop me a message! Remember that the event is also taking place virtually, so (I believe) there's still time to sign yourself up - Saturday is a free Community event which anyone can join.
In the newsletter this week, we have a great Power Query Masterclass presented by Melissa de Korte (with content to cover all proficiency levels), Xiaoxin Sheng has described how to replicate SWITCH functionality in Power Query in the blog Custom function with multiple condition logic, and on the "Admin" side, Adam Saxton has written about how to most efficiently Deal with orphaned Power BI workspaces to avoid the "click-tax" of doing this manually in the Power BI Service.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) writes about Why Not All SQL Queries Can Be Used As A Source In Power BI DirectQuery Mode
- On the Power BI community blog, Xiaoxin Sheng describes Custom function with multiple condition logic to achieve switch in Power Query
- On the CSG Pro blog, Krrish Dholakia talks about Enabling Near Real-Time Experiences with Streaming Dataflows
- On the Purple Frog Systems blog, Joe Billingham (@PurpleFrogSys) walks through Combining Queries from Multiple Sources in Power BI using Merge and Append
- Melissa de Korte (@_EnterpriseDNA) presents Power Query Masterclass For Power BI
- Allison Kennedy (@ExcelAllison) explains how to Remove Duplicates - Power Query vs Data Model
- Chandeep Chhabra (@chandeep2786) describes IFERROR In Power Query – Try And Otherwise
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes How to create Calendar Table in Power BI?
- James Andrew explains how to Create a Last Refreshed Timestamp within Power BI using Power Query & DAX
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Understanding the IN operator in DAX, and talks about SQRTPI, PI – DAX Guide and ISFILTERED, ISCROSSFILTERED – DAX Guide
- Patrick Leblanc (@GuyInACube) explains how to Create Hybrid Tables with Tabular Editor for Power BI
- Daniil Maslyuk (@DMaslyuk) describes Power BI Antipatterns #4: YEAR + MONTH
- On the Enterprise DNA blog, Greg Philps (@_EnterpriseDNA) writes about the Power BI Data Model: A Comprehensive Overview
- James Andrew talks about Filtering Blanks Correctly When Using DAX within Power BI
- Reid Havens (@HavensBI) presents Microsoft hates Greg Deckler
- Hafeez Jimoh (@jimohhafeezco) talks about Understanding the versatile DATEADD Function in DAX
📊 Report Authoring and Interactivity
- Pat Mahoney (@mahoneypa) talks about Deneb Visual in Power BI - Easier to Modify Than Create
- On the MSSQLTips site, Bhavesh Patel describes a Power BI Toggle Button to Navigate Between Charts
- On the Learning Science YouTube channel, Learning Science describes How To Add Target Constant, Average, Median, Percentile, Min & Max Line for Power BI Charts
- Gilbert Quevauvilliers (@GilbertQue) wonders Where has the conditional formatting gone with the new Power BI Desktop formatting pane?
- Ruth Pozuelo Martinez (@CurbalEN) describes How to create stunning multicards in Power BI with a little bit of DAX
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) walks through Analyzing report performance of Power BI Desktop reports
- Hossein Seyedagha (@_EnterpriseDNA) describes How To Import R Scatter Plots To Power BI
🚀 Deployment, Security and Operations
- Adam Saxton (@GuyInACube) walks through Dealing with orphaned Power BI workspaces
- Philipp Lenz (@lenz_philipp) describes How to check if a Power BI report contains Custom Visuals
🌐 General
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 220 - Power BI February 2022 Feature Summary
- Matt Allington (@ExceleratorBI) writes about Real Life Power BI Demo – What Size Water Tank Do I Need?
- Bas Dohmen (@HowToPowerBI) explains How to Build a Financial Report in Power BI