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
How many Vision Pro headsets has Apple sold?
Monday, April 29, 2024
The Morning After It's Monday, April 29, 2024. Apple Vision Pro headset production is reportedly being cut, sales are reportedly “way down.” But but but wait: Wasn't the Vision Pro meant to
Okta Warns of Unprecedented Surge in Proxy-Driven Credential Stuffing Attacks
Monday, April 29, 2024
THN Daily Updates Newsletter cover Webinar -- Uncovering Contemporary DDoS Attack Tactics -- and How to Fight Back Stop DDoS Attacks Before They Stop Your Business... and Make You Headline News.
Import AI 370: 213 AI safety challenges; everything becomes a game; Tesla's big cluster
Monday, April 29, 2024
Are AI systems more like religious artifacts or disposable entertainment? ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Apple renews OpenAI talks 🧠, Google fires Python team 👨💻, React 19 beta ⚛️
Monday, April 29, 2024
Apple has renewed discussions with OpenAI to use its generative AI technology to power new features coming to the iPhone Sign Up |Advertise|View Online TLDR Together With QA Wolf TLDR 2024-04-29 😘 Kiss
Architecture Weekly #177 - 29nd April 2024
Monday, April 29, 2024
How do you make predictions about tech without the magical crystal ball? We did that today by example. We analysed what Redis and Terraform license changes relate to the new Typescript framework Effect
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