Azure Weekly - Power BI Weekly #147 - 8th March 2022
Power BI Weekly Newsletter Issue #147
powered by endjin
Welcome to the 147th edition of Power BI Weekly! 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.
If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.
Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news.
@edfreeman_ | @endjin
powerbiweekly.info | endjin.com
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
Useful Links
- Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
- M language reference - Official Power Query M Reference
- DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
- DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
- Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
- Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
- Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
- Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
- Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
- Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
- Power BI Events - Interactive report displaying upcoming Power BI events worldwide, built by Matt Allington, Phil Seamark and Reid Havens
- Power BI Days - Free-to-attend virtual and in-person community events, all across the world. If you're wanting to organize an event, that's possible too - it's still free, and comes with support.
Tweet | Forward | Preferences | Unsubscribe
Older messages
Power BI Weekly #145 - 22nd February 2022
Tuesday, February 22, 2022
Power BI Weekly Newsletter Issue #145 powered by endjin Welcome to the 145th edition of Power BI Weekly! It's Power BI Feature Summary time, and there are a few lovely features landing this month.
Power BI Weekly #144 - 15th February 2022
Tuesday, February 15, 2022
Power BI Weekly Newsletter Issue #144 powered by endjin Welcome to the 144th edition of Power BI Weekly! Couple of official Power BI blogs this week, one of which is the announcement of the General
☁️ Azure Weekly #359 - 13th February 2022
Sunday, February 13, 2022
Azure Weekly Newsletter Issue #359 powered by endjin Welcome to issue 359 of Azure Weekly. There's an interesting dive into DataLakehouse, Data Mesh, and Data Fabric, and a post exploring how you
Power BI Weekly #142 - 1st February 2022
Tuesday, February 1, 2022
Power BI Weekly Newsletter Issue #142 powered by endjin Welcome to the 142nd edition of Power BI Weekly! A few updates this week, the first being the Power BI Report Server January 2022 Feature Summary
Power BI Weekly #141 - 25th January 2022
Tuesday, January 25, 2022
Power BI Weekly Newsletter Issue #141 powered by endjin Welcome to the 141st edition of Power BI Weekly! A very exciting set of announcements around Deployment Pipelines this week, including a handy
You Might Also Like
15 ways AI saved me weeks of work in 2024
Monday, December 23, 2024
ZDNET's product of the year; Windows 11 24H2 bug list updated -- ZDNET ZDNET Tech Today - US December 23, 2024 AI applications on various devices. 15 surprising ways I used AI to save me weeks of
Distributed Locking: A Practical Guide
Monday, December 23, 2024
If you're wondering how and when distributed locking can be useful, here's the practical guide. I explained why distributed locking is needed in real-world scenarios. Explored how popular tools
⚡ THN Weekly Recap: Top Cybersecurity Threats, Tools and Tips
Monday, December 23, 2024
Your one-stop-source for last week's top cybersecurity headlines. The Hacker News THN Weekly Recap The online world never takes a break, and this week shows why. From ransomware creators being
⚙️ OpenA(G)I?
Monday, December 23, 2024
Plus: The Genesis Project
Post from Syncfusion Blogs on 12/23/2024
Monday, December 23, 2024
New blogs from Syncfusion Introducing the New WinUI Kanban Board By Karthick Mani This blog explains the features of the new Syncfusion WinUI Kanban Board control introduced in the 2024 Volume 4
Import AI 395: AI and energy demand; distributed training via DeMo; and Phi-4
Monday, December 23, 2024
What might fighting for freedom in an AI age look like? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
LockBit Ransomware Developer Charged for Billions in Global Damages
Monday, December 23, 2024
THN Daily Updates Newsletter cover The Data Science Handbook, 2nd Edition ($60.00 Value) FREE for a Limited Time Practical, accessible guide to becoming a data scientist, updated to include the latest
Re: How to know if your data has been exposed
Monday, December 23, 2024
Imagine getting an instant notification if your SSN, credit card, or password has been exposed on the dark web — so you can take action immediately. Surfshark Alert does just that. It helps you stay
Christmas On Repeat 🎅
Monday, December 23, 2024
Christmas nostalgia is a hell of a drug. Here's a version for your browser. Hunting for the end of the long tail • December 22, 2024 Hey all, Ernie here with a refresh of a piece from our very
SRE Weekly Issue #456
Monday, December 23, 2024
View on sreweekly.com A message from our sponsor, FireHydrant: On-call during the holidays? Spend more time taking in some R&R and less getting paged. Let alerts make their rounds fairly with our