Power BI Weekly #184 - 29th November 2022
Power BI Weekly Newsletter Issue #184
powered by endjin
Welcome to the 184th edition of Power BI Weekly! Absolutely no word from the Power BI team this week, so we'll jump straight into the community content. Last week Paul Turley began a series of articles regarding Developing Large Power BI Datasets, and has now followed up the first article with two more great articles related to Partitioning and Detail Tables. Bas Dohmen has shown how we can use the dynamic Y axis functionality to achieve 100% Axis Control in Power BI, and Greg Deckler has taken a step back discussing the topic of Planning Power BI Projects.
Finally, we've published our Accessible Data Storytelling: World Bank Heath and Wealth Report to the Power BI Data Stories Gallery, which has been an internal project to highlight how to create compelling data stories with an accessible colour palette to assist users with Colour Vision Deficiency. If you're creating a Power BI report that has an audience larger than 12 people, statistically you need to take into account Colour Vision Deficiency. We've also produced two videos which provide A walkthrough of the World Health and Wealth Data Story and Custom Report Design: An Array of Design Concepts and Accessible Colours for 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
- Chris Webb (@cwebb_bi) writes about How Much Data Can You Load Into Power BI?
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Power Query Optimization: Reducing Decimal Numbers
- Chandeep Chhabra (@chandeep2786) explains how to Remove Change Type Errors in Power Query
- Marcus Wegener (@PowerBIler) explains how to Calculate ISO 8601 Calendar Week in Power Query with SQL Query Folding
- James Andrew (@MatadorSoftware) talks about Fixing a Common Issue with Dates in Power BI | Add Leading Zero in Power Query
- Purna (Chandoo) Duggirala (@r1c1) describes How to connect to a single file on SharePoint from Power Query (Fix Unable to Connect Error)
- Laura Graham-Brown (@Laura_GB) writes about Power BI Connecting to Google Analytics
- Gaelim Holland (@_EnterpriseDNA) describes How To Create A Forecast Model In Power BI With Python
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into Filters based on content of other tables in Power BI – Unplugged #44
- Sam McKay (@_EnterpriseDNA) describes When To Use The CALCULATETABLE Function - DAX Function Techniques [2022 Update]
- Pat Mahoney (@mahoneypa) covers Handling Ties with TOPN
- Paul Turley (@paul_turley) writes Developing Large Power BI Datasets – Part 2 – Partitioning and Part 3 – Detail Tables
- Marc Lelijveld (@MarcLelijveld) explains how to Connect the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services
- Jason Cockington (@JasonCockington) describes Five Essential Power Tools for Power BI Desktop
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) talks about 100% Axis Control in Power BI and describes Smart Data Labels
- Greg Deckler (@GregDeckler) talks about Dueling Tooltips In Power BI
- Leila Gharani (@LeilaGharani) explains how to Rename Clunky Fields in Power BI
- Darren Gosbell (@darrengosbell) blogs about Power BI – Using Field Parameters in Paginated Reports
- James Andrew (@MatadorSoftware) describes how to Use Python to Create a Correlation Heatmap Visual in Power BI
- Sam McKay (@_EnterpriseDNA) describes Creating P&L Statements In Power BI - Financial Reporting Example [2022 Update]
- Daniel Marsh-Patrick (@the_d_mp) writes about Happy 1st birthday, Deneb!
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) writes about 4 + 2 Security features in Power BI
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Row Level Security & Object Level Security In Power BI DAX Studio
- Shabnam Watson (@ShbWatson) describes Exploring Automatic Partition Maintenance in Power BI datasets with Incremental Refresh, using EffectiveDate parameter
- Gilbert Quevauvilliers (@GilbertQue) blogs about Testing Power BI REST APIs with Try it
- Also on the Towards Data Science blog, Nikola Ilic (@DataMozart) explains how to Identify Data Loading Bottlenecks in Power BI
- Laura Graham-Brown (@Laura_GB) describes how to Power BI – Take over a Dataset
- On the phData, Gavin Pedersen (@gavin_PD) describes How to Create a Power BI App
- Ignacio Barrau (@ignacho_07) covers Power BI Apps contenido por audiencia [Spanish]
- Audrée Pellerin covers La sécurité des applications Power BI [French]
- On Acuity Training, Ben Richardson (@AcuityTraining) describes Sharing Reports & Dashboards In Power BI
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Enterprise DNA blog, Greg Deckler (@GregDeckler) writes about Power BI Project Planning: Discovery & Ingestion and walks through Planning Power BI Projects
- Rahim Zulfiqar Ali (@rahimzulfiqar) covers 15 Microsoft Power BI Tips for Better Dashboards
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 211
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
Key phrases
Older messages
☁️ Azure Weekly #395 - 13th November 2022
Sunday, November 13, 2022
Azure Weekly Newsletter Issue #395 powered by endjin Welcome to issue 395 of Azure Weekly. This week saw the release of .NET 7.0 and day zero support across Azure PaaS services, including App Service,
Power BI Weekly #182 - 8th November 2022
Tuesday, November 8, 2022
Power BI Weekly Newsletter Issue #182 powered by endjin Welcome to the 182nd version of Power BI Weekly! Only a single announcement this week, which is that you can now Save a copy of a report &
☁️ Azure Weekly #394 - 6th November 2022
Sunday, November 6, 2022
Azure Weekly Newsletter Issue #394 powered by endjin Welcome to issue 394 of Azure Weekly. There's a mixed bag of interesting content this week. Firstly there's an article about Data mesh: A
👻 Azure Weekly #393 - 30th October 2022
Sunday, October 30, 2022
Azure Weekly Newsletter Issue #393 powered by endjin Welcome to issue 393 of Azure Weekly! To start with, there's a podcast featuring Isaac Abraham talking about Farmer for Azure Deployments. We
Power BI Weekly #180 - 24th October 2022
Tuesday, October 25, 2022
Power BI Weekly Newsletter Issue #180 powered by endjin Welcome to the 180th edition of Power BI Weekly! We've been given the Power BI October 2022 Feature Summary this week, and there are a few
You Might Also Like
Tesla Autopilot investigation closed
Friday, April 26, 2024
Inside the IBM-HashiCorp deal and Thoma Bravo takes another company private View this email online in your browser By Christine Hall Friday, April 26, 2024 Good afternoon, and welcome to TechCrunch PM.
Microsoft's and Google's bet on AI is paying off - Weekly News Roundup - Issue #464
Friday, April 26, 2024
Plus: AI-controlled F-16 has been dogfighting with humans; Grok-1.5 Vision; BionicBee; Microsoft's AI generates realistic deepfakes from a single photo; and more! ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
🤓 The Meta Quest Might Be the VR Steam Deck Soon — Games to Play After Finishing Wordle
Friday, April 26, 2024
Also: Why a Cheap Soundbar Is Better Than Nothing, and More! How-To Geek Logo April 26, 2024 Did You Know TMI: Rhinotillexomania is the medical term for obsessive nose picking. 🖥️ Get Those Updates
JSK Daily for Apr 26, 2024
Friday, April 26, 2024
JSK Daily for Apr 26, 2024 View this email in your browser A community curated daily e-mail of JavaScript news A Solid primer on Signals with Ryan Carniato (JS Party #320) Ryan Carniato joins Amal
So are we banning TikTok or what?
Friday, April 26, 2024
Also: Can an influencer really tank an $800M company? View this email online in your browser By Haje Jan Kamps Friday, April 26, 2024 Image Credits: Jonathan Raa/NurPhoto / Getty Images Welcome to
[AI Incubator] 300+ people are already in. Enrollment closes tonight at 11:59pm PT.
Friday, April 26, 2024
How to decide if you're ready.
Daily Coding Problem: Problem #1423 [Medium]
Friday, April 26, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. You are given an array of nonnegative integers. Let's say you start at the
Data science for Product Managers
Friday, April 26, 2024
Crucial resources to empower you with data that matters.
Inner Thoughts
Friday, April 26, 2024
'The Inner Circle' Comes Around... Inner Thoughts By MG Siegler • 26 Apr 2024 View in browser View in browser If you'll allow me a brief meta blurb this week (not a Meta blurb, plenty of
Digest #135: Kubernetes Hacks, Terraform CI/CD, HashiCorp Acquisition, AWS Data Transfer Monitoring
Friday, April 26, 2024
Explore Advanced Kubernetes Techniques, Dive Into Terraform CI/CD Frameworks, Monitor AWS Data Transfer, and Explore Cloud Security with Gitleaks! ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏