Power BI Weekly #145 - 22nd February 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. First of all we have the new mobile visual formatting pane (preview) which is a very welcome addition for those of us who create mobile versions of our reports. Next, the Dynamic M Query Parameters feature now supports SQL Server and more relational data sources (e.g. most flavours of SQL Server, Oracle, Teradata), which is awesome - you'll see a couple of blogs about this below and learn about how it can help you. We've also been told that the Power BI Windows app now has a dark mode, which is great, but most of you are probably waiting for the Power BI Desktop dark mode, which unfortunately still doesn't exist. Sorry.
Elsewhere this week, Imke Feldmann has described how to Transform multiple columns at once with reference to existing column in Power Query, Brian Julius has described How to Create And Debug Custom Functions In Power BI, and Chandeep Chhabra has show how to use buttons and bookmarks to Turn On / Off Tooltips In Power BI.
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
- On the Prologika blog, Teo Lachev (@tlachev) discusses Power BI Dynamic M Query Parameters Reloaded
- Chris Webb (@cwebb_bi) covers TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQuery
- Imke Feldmann (@TheBIccountant) covers Transforming multiple columns at once with reference to existing column in Power Query
- Brian Julius (@_EnterpriseDNA) describes How To Handle Stacked Data In Power BI and describes How to Create And Debug Custom Functions In Power BI
- Ben Gribaudo (@bgribaudo) discusses Custom Connectors: Components & Packaging Formats
- Gašper Kamenšek (@ExcelUnplugged) writes about Why You Should Know Power Query – Part 2: Split
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) describes the Differences between INT and CONVERT in DAX
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares a few tutorials: RADIANS, DEGREES – DAX Guide, ISBLANK – DAX Guide and SIN, COS, ASIN, ACOS, TAN, ATAN, COT, ACOT – DAX Guide
- Daniil Maslyuk (@DMaslyuk) talks about Power BI Antipatterns #3: Table functions
- On the SQL Server Central blog, Adam Aspin describes DAX table functions for paginated reports: Part 1
- Ruth Pozuelo Martinez (@CurbalEN) talks about Nearest location based on Lat/Long in Power BI and talks about Sorting the Y-axis in Power BI
- Ilgar Zarbaliyev (@IlgarZ) talks about What-If Parameters (Enterprise Analytics Summit)
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Michal Foster Heldy (@Michal36040600) explains how to Create stunning, mobile-optimized Power BI reports with mobile layout’s new visual formatting pane (Preview)
- Fowmy Abdulmuttalib (@ExcelFort) describes How to Make Elegant In Page Navigation with Power BI Bookmark Navigator
- Reid Havens (@HavensBI) talks about Effective use of Bookmarks and Buttons (with Ben Ferry - Power BI Guy)
- James Andrew explains how to Create Powerful Custom Power BI KPI Cards
- Chandeep Chhabra (@chandeep2786) describes how to Turn On / Off Tooltips In Power BI
- Sam McKay (@_EnterpriseDNA) presents Application-Like Report Development Techniques (Enterprise Analytics Summit)
- Arnaud Gastelblum (@LazySna1l) writes about Power BI: Duplicate of Duplicate – The best way to test your reports and measures
- Pat Mahoney (@mahoneypa) talks about Deneb - Unpivot your data... inside the visual!
- Jason Cockington (@JasonCockington) writes about Plotting 2 Columns on the Legend of a Chart
- On the Learning Science YouTube channel, Learning Science talks about Dynamic Image in Power BI
- Dhruvin Shah (@DhruvinShah16) talks about the Scorecard Visual in Power BI
- Carl de Souza (@carldesouza) blogs about Embedding Power Automate Flows Inside 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) discusses Do we need more Power BI Premium Capacity?
- Hafeez Jimoh (@jimohhafeezco) explains How to Share and Publish to the Web in Power BI
- Dhruvin Shah (@DhruvinShah16) discusses Power BI Goals - Goal Level Permissions
- Reid Havens (@HavensBI) presents Uncovering Secrets and Mysteries in your Power BI Tenant (with Benni De Jagere)
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) highlights the Power BI February 2022 Feature Summary
- Kelly Kaye (@MS_KellyKaye) presents The Power BI Community Show
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 #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
☁️ Azure Weekly #355 - 16th January 2022
Sunday, January 16, 2022
Azure Weekly Newsletter Issue #355 powered by endjin Welcome to issue 355 of the Azure Weekly Newsletter. I want to start this issue talking about Azure API Management; in my opinion, it's one of
You Might Also Like
Software Testing Weekly - Issue 217
Monday, April 29, 2024
How do you deal with conflicts in QA? ⚔️ View on the Web Archives ISSUE 217 April 29th 2024 COMMENT Welcome to the 217th issue! How do you deal with conflicts in QA? Ideally, you'd like to know how
📧 Did you watch the free MMA chapters? (1+ hours of content)
Monday, April 29, 2024
Did you watch the free MMA chapters? Hey there! 👋 I wish you a fantastic start to the week. Last week, I launched Modular Monolith Architecture. More than 300+ students are already deep into the MMA
WP Weekly 191 - Essentials - Duplicate in Core, White Label Kadence, Studio for Mac
Monday, April 29, 2024
Read on Website WP Weekly 191 / Essentials It seems many essential features are being covered in-house, be it the upcoming duplicate posts/pages feature in the WordPress core or the launch of Studio
SRE Weekly Issue #422
Monday, April 29, 2024
View on sreweekly.com A message from our sponsor, FireHydrant: FireHydrant is now AI-powered for faster, smarter incidents! Power up your incidents with auto-generated real-time summaries,
Quick question
Sunday, April 28, 2024
I want to learn how I can better serve you
Kotlin Weekly #404 (NOT FOUND)
Sunday, April 28, 2024
ISSUE #404 28st of April 2024 Announcements Kotlin Multiplatform State of the Art Survey 2024 Help to shape and understand the Kotlin Multiplatform Ecosystem! It takes 4 minutes to fill this survey.
📲 Why Is It Called Bluetooth? — Check Out This AI Text to Song Generator
Sunday, April 28, 2024
Also: What to Know About Emulating Games on iPhone, and More! How-To Geek Logo April 28, 2024 📩 Get expert reviews, the hottest deals, how-to's, breaking news, and more delivered directly to your
Daily Coding Problem: Problem #1425 [Easy]
Sunday, April 28, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Microsoft. Suppose an arithmetic expression is given as a binary tree. Each leaf is an
PD#571 Software Design Principles I Learned the Hard Way
Sunday, April 28, 2024
If there's two sources of truth, one is probably wrong. And yes, please repeat yourself.
When Procrastination is Productive & Ghost integrating with ActivityPub
Sunday, April 28, 2024
Automattic, Texts, and Beeper join forces to build world's best inbox, Reflect launches its iOS app, how to start small rituals, and a lot more in this week's issue of Creativerly. Creativerly