Power BI Weekly #144 - 15th February 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 availability of Export Power BI report to file API (so you can put those Power Automate flows into production), and there's been a case-study into the Inforiver visual - No-Code Partner Innovation for End-User Self-Service inside Power BI which has cropped up a few times in this newsletter.
Elsewhere this week, Paul Waller has described How to Create Custom Buttons in Power BI to make your reports look & feel extra slick, Salvatore Cagliari has described a nice way to achieve Dynamic Time Intelligence in DAX, Alberto Ferrari has described how to Analyze related geography attributes in different tables in Power BI when utilizing conformed dimensions, and Patrick Leblanc tells us How do I get my Excel users to use 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
- Gašper Kamenšek (@ExcelUnplugged) writes about Why You Should Know Power Query – Part 1: Fill
- Pat Mahoney (@mahoneypa) describes An easy way to handle Daylight Savings Time in Power Query
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) describes YTD Flags in Power Query
- Kreimir Ledinski (@Exceed_ltd) writes about Dynamic Coalesce in PowerQuery
- On the MSSQLTips site, John Miner (@JohnMiner3) covers Leveraging the Power Query activity within Azure Data Factory
- Also on the MSSQLTips site, Scott Murray describes Power BI Designing with Diagrams
- Delia Fernandez (@datachant) provides an Introduction to Power BI Dataflows
- On the Enterprise DNA blog, George Mount (@_EnterpriseDNA) writes about Three Ways To Use R Script In Power BI and covers Using R In Power BI - An Exploration
- David Abu (@DavidAbu_) discusses Cleaning Multiple Files in Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) shares [Updated] Best practices using SUMMARIZE and ADDCOLUMNS
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) covers Analyzing related geography attributes in different tables in Power BI – Unplugged 42, describes ISEMPTY – DAX Guide and delves into ROUND, ROUNDDOWN, ROUNDUP, TRUNC – DAX Guide
- Nazarena Tossolini writes about Cohort Análisis [Spanish]
- Bas Dohmen (@HowToPowerBI) shares Understand how to analyze by week in Power BI
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about Dynamic Time Intelligence in DAX made easy
- Brian Julius (@_EnterpriseDNA) talks about Addressing Troublesome Time Intelligence Issues In Power BI and explains How To Dynamically Select Starting Period For Any Chart In Power BI
- Fowmy Abdulmuttalib (@ExcelFort) presents a webinar: Why Do My DAX Formulas Return Wrong Results?
- Bernat Agulló (@AgulloBernat) shares some One-click calculation groups for your toolbelt
- Edward Pollack (@EdwardPollack) describes Vertipaq optimization and its impact on columnstore compression
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Ranin Salameh (@rsalameh) writes about Inforiver – No-Code Partner Innovation for End-User Self-Service inside Power BI
- On the endjin blog, Paul Waller (@Crashbangwaller) describes How to Create Custom Buttons in Power BI
- Allison Kennedy (@ExcelAllison) writes about Power BI Formatting
- Pat Mahoney (@mahoneypa) presents Getting Started With the Deneb Visual in Power BI and talks about Getting Help With the Deneb Visual in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) shares Powerful storytelling technique in Power BI from storytelling by data book
- Reid Havens (@HavensBI) presents Faster Reporting and Insights Using InfoRiver with Matt Allington
- On the Learning Science YouTube channel, Learning Science talks about Designing Power BI Report for Mobile Devices
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) blogs about Introduction to the latest features of Power BI Desktop
- Hima Bindu Marri (@sivahimabindu) talks about Key Performance Indicators in Power BI
- Patrick Leblanc (@GuyInACube) describes How to get Secure Images in Power BI Reports
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Alon Baram announces General availability of Export Power BI report to file API
- On the Power BI Tips and Tricks blog, the Explicit Measures podcast team (@PowerBITips) discusses Certified vs. Promoted Dataset?
- Dhruvin Shah (@DhruvinShah16) talks about Power BI Goals - Create connected goals in Power BI
- Chris Webb (@cwebb_bi) describes how to Speed Up Power BI Refresh By Increasing The Amount Of Memory On Your On-Premises Data Gateway Machine
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Feb 12, 2022)
- Reid Havens (@HavensBI) presents Starting your journey with Power BI with Gaston Cruz
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) writes about 8 Mistakes I made to Start Learning Power BI
- Patrick Leblanc (@GuyInACube) presents How do I get my Excel users to use 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
☁️ 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
Power BI Weekly #139 - 11th January 2022
Tuesday, January 11, 2022
Power BI Weekly Newsletter Issue #139 powered by endjin Welcome back for the 139th edition of Power BI Weekly! There's been tumbleweed over on the Power BI blog this week, so if you're after
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