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
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