Power BI Weekly #141 - 25th January 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 new Azure DevOps extension, Dataflows and Linked entities support going GA, and my personal favourite: multiple pipelines can now be integrated with one another, in the sense that you can have one pipeline managing your shared (centralized) datasets and others managing corresponding reports, with the dev, test and prod stages of each pipeline staying aligned. This means that dev reports are bound to dev datasets, test reports to test datasets, and prod reports to prod datasets. Sounds so simple, but a huge improvement - thanks to the Power BI team for making this happen!
Elsewhere this week, Antriksh Sharma has described Working With Expanded Tables In Power BI, James Andrew has described how to change Power BI Custom Icons depending on the time using DAX and UNICHAR, and Marc Lelijveld has started a governance series about Power BI Workspace setup.
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
- Ben Gribaudo (@bgribaudo) writes about Power Query M Primer (Part 23): Query Folding I
- Adam Saxton (@GuyInACube) explains How we optimize Power Query and Power BI Dataflows
- Brian Julius (@_EnterpriseDNA) explains How To Obtain Previous Week Values In Power BI
- On the Towards Data Science blog, Peter Hui discusses Power BI—Table, Lists and Records
- Parker Stevens (@PowerBIElite) describes Scraping Amazon Product Data using Python and Power BI
- Ruth Pozuelo Martinez (@CurbalEN) explains You are getting files from folders the wrong way in Power BI: Here is how to fix it
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the endjin blog, Elisenda Gascon (@elisendagascon) discusses Evaluation Contexts in DAX - Relationships and describes Evaluation Contexts in DAX - Context Transition
- Alberto Ferrari (@FerrariAlberto) writes about Using ALLSELECTED in composite models, on the SQLBI blog, talks about SQRT, POWER – DAX Guide and covers GEOMEAN, GEOMEANX – DAX Guide
- Urish Arora (@urisharora) shares a few blogs: Main differences between SQL and DAX, Building Queries Manually In DAX Studio and In Power BI exclude slicer selection from the result with DAX
- Reid Havens (@HavensBI) describes Auto-Scaling for DAX - KPI Strings?
- James Andrew discusses Changing Power BI Custom Icons Depending on the Time (DAX | UNICHAR)
- Antriksh Sharma (@_EnterpriseDNA) talks about Working With Expanded Tables In Power BI
- Mimoune Djouallah (@mim_djo) talks about Power BI Hybrid Table, you can have your cake and eat it too
- Bas Dohmen (@HowToPowerBI) describes Hybrid Tables in Power BI
- Belinda Allen (@MsBelindaAllen) blogs about Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Pat Mahoney (@mahoneypa) describes Power BI - Scrolling with the Deneb Visual
- Brian Julius (@_EnterpriseDNA) describes How To Dynamically Control Font Properties Via DAX
- Sam McKay (@_EnterpriseDNA) covers Transformation High-Level Analytics with Power BI
- Hima Bindu Marri (@sivahimabindu) talks about Small multiples in Power BI
- On the Learning Science YouTube channel, Learning Science describes Small Multiples in Power BI
- On the SQL Server Central blog, Scott Murray discusses Power BI Zoom and Focus
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) covers Report Page Tooltips in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes How to pick stunning colors for your 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, Nimrod Shalit writes about Deployment pipelines- Azure DevOps extension, multiple pipelines working together, Dataflows GA
- Chris Webb (@cwebb_bi) describes how to Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 3: Queries
- On the Power BI community blog, Ye Tao discusses Is there a limit to the number of embed tokens?
- Marc Lelijveld (@MarcLelijveld) discusses Power BI Workspace setup – Part 1
- Adam Saxton (@GuyInACube) talks about Power BI Premium Gen2 updates (January 2022)
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 (Jan 22, 2022) (Member Chat 2nd Half)
- James Andrew explains how to Get Practice Power BI Datasets with these 5 Great Resources
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 #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
☁️ Azure Weekly #354 - 9th January 2022
Sunday, January 9, 2022
Azure Weekly Newsletter Issue #354 powered by endjin Happy New Year & welcome to issue 353 of Azure Weekly! This is an epic edition, covering most of December. I've highlighted a few articles I
Power BI Weekly #137 - 21st December 2021
Tuesday, December 21, 2021
Power BI Weekly Newsletter Issue #137 powered by endjin Welcome to the 137th edition of Power BI Weekly! Some amazing updates have landed this week, and not just from the new Power BI Desktop release.
Power BI Weekly #136 - 14th December 2021
Tuesday, December 14, 2021
Power BI Weekly Newsletter Issue #136 powered by endjin Welcome to the 136th edition of Power BI Weekly! This week: we've been shown how to use the new (preview) visualization feature within
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