Power BI Weekly #178 - 11th October 2022
Power BI Weekly Newsletter Issue #178
powered by endjin
Welcome to the 178th edition of Power BI Weekly! Just the one announcement this week, which is about Deployment pipelines – announcing "Deployment History" feature and "Azure DevOps extension" GA. Elsewhere this week, James Broome has written another element of the Insight Discovery series, with Part 5 - Deliver insights incrementally with data pipelines, Gavin Pedersen has described Power BI Workspace Strategy for Self Service within Premium Capacities, and Andrzej Leszkiewicz has given us a bit of fun with Power BI Pacman.
Finally, I'm excited to share that my colleague Ian Griffiths and I are running a free 1-day, in-person workshop about creating a modern data lake (house) architecture with full DevOps on Azure Synapse Analytics in London (UK) on Wednesday Nov 2nd 2022. This is an in-person (not virtual) event. Full workshop agenda can be found here and to register your interest use this form. Spaces are limited, so register quickly!
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 MSSQLTips site, Kenneth A. Omorodion (@mssqltips) explains How to connect to a Power BI Datamart in Power BI Desktop
- Kevin Chant (@kevchant) writes about GitHub Actions information using the GitHub connector in Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes Power BI Real-time Streaming Dataset
- On the Tessellation Tech blog, Manikanta Gudivaka explains How to Load Large Datasets in Power BI Desktop Using Parameters
- Melissa de Korte (@_EnterpriseDNA) explains How To Use COALESCE In Power Query / M
- Adam Saxton (@GuyInACube) describes A Power Query feature you may not know about
- Jarrett Moore (@BuckeyeJarrett) describes How To Reference Tables In Power Query For Improved Refresh Time & Data Performance
- Dan English (@denglishbi) writes about Power BI using Synapse Serverless Pool with Delta Lake format
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Also on the SQLBI blog, Marco Russo (@marcorus) discusses Storage Engine (VertiPaq) – The Whiteboard #07
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses SELECTEDMEASURE – DAX Guide
- Philipp Lenz (@lenz_philipp) blogs about Power BI composite models – a underestimated feature
- Sam McKay (@_EnterpriseDNA) describes 'What If' Sensitivity Analysis In Power BI Using DAX - Advanced Technique [2022 Update]
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about DAX Query Example Using Various Keywords & Functions
- On the Learning Science YouTube channel, Learning Science describes 3 ways to add calculated or custom column in Power BI
- Matt Allington (@ExceleratorBI) covers Measure Killer for Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) describes A Single Measure for Formatting and Button Navigation
- Bas Dohmen (@HowToPowerBI) describes how to Highlight Chosen Data Points in a Line Chart
- On the Foresight BI blog, Ahmed Oyelowo (@AhmedOyelowo) explains how to Hide Total For Selected Column In Power BI Table
- Reid Havens (@HavensBI) discusses Creating a Win/Loss Spark Chart in Power BI and talks about Alternative Ways to Drillthrough with Hyperlinks
- Also on the Power BI community blog, Kumail Raza writes about Custom Visuals in Power BI
- On the Enterprise DNA blog, Gustaw Dudek (@EnterpriseDNA_) describes Dashboard Layout Design Techniques
- Andrzej Leszkiewicz (@avatorl) shares Power BI Pacman
- James Andrew (@MatadorSoftware) provides A Bumper Guide to Using Python in Power BI | Importing Data, Transformations, Python Data Viz & More
- Kelly Kaye (@MS_KellyKaye) presents Power BI Community Show Ep 10 - Amit Chandak
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, Lee Benjamin writes about Deployment pipelines – announcing "Deployment History" feature and "Azure DevOps extension" GA
- Chris Webb (@cwebb_bi) walks through Monitoring Power BI Desktop Activity Using Extended Events In SQL Server Management Studio
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 26: Modern React-JS Development with App-Owns-Data Embedding
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Incremental Refresh and Hybrid tables in Power BI: Load Changes Only
- On the Tessellation Tech blog, Gavin Pedersen (@gavin_PD) covers Power BI Workspace Strategy for Self Service within Premium Capacities
- Reid Havens (@HavensBI) walks through Sharing Power BI Content with Multiple Audiences (with Tom Martens)
- Pat Mahoney (@mahoneypa) explains how to Get Notified on Successful Power BI Dataset Refresh
- Bernat Agulló (@AgulloBernat) describes Writing Tabular Editor C# Scripts like a Boss
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the MSSQLTips site, Daniel Calbimonte (@dcalbimonte) provides a Power BI Certification FAQ for Exams PL-300 and PL-900
- Brian Julius (@_EnterpriseDNA) announces Microsoft PL-300 Certification - New Course
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 #389 - 2nd October 2022
Sunday, October 2, 2022
Azure Weekly Newsletter Issue #389 powered by endjin Welcome to issue 389 of Azure Weekly. A recurring theme over the last few months has been "trimming IT budgets", and there's another
Power BI Weekly #175 - 20th September 2022
Tuesday, September 20, 2022
Power BI Weekly Newsletter Issue #175 powered by endjin Welcome to the 175th edition of Power BI Weekly! Plenty of announcements. Let's start with the Power BI September 2022 Feature Summary, where
☁️ Azure Weekly #387 - 18th September 2022
Sunday, September 18, 2022
Azure Weekly Newsletter Issue #387 powered by endjin Welcome to issue 387 of Azure Weekly. A slight DevOps theme in the highlights this week; Bicep is in Visual Studio, and API Management DevOps
☁️ Azure Weekly #386 - 11th September 2022
Sunday, September 11, 2022
Azure Weekly Newsletter Issue #386 powered by endjin Welcome to issue 386 of Azure Weekly. Quite a packed edition, with lots of community content. An interesting announcement this week is the Generally
Power BI Weekly #172 - 30th August 2022
Tuesday, August 30, 2022
Power BI Weekly Newsletter Issue #172 powered by endjin Welcome to the 172nd edition of Power BI Weekly! A packed edition this week, and haven't we been spoilt. On the "official Power BI
You Might Also Like
Data Science Weekly - Issue 543
Friday, April 19, 2024
Curated news, articles and jobs related to Data Science, AI, & Machine Learning ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
A deal made in cloud security heaven
Thursday, April 18, 2024
Meta's Llama 3 goes public and hackers hold World-Check data for ransom View this email online in your browser By Christine Hall Thursday, April 18, 2024 Welcome to TechCrunch PM! I'm glad you
💎 Issue 413 - RubyJS-Vite
Thursday, April 18, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 413 Release Date Apr 18, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 406 - Swift for C++ Practitioners, Part 1
Thursday, April 18, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 406 Release Date Apr 18, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 413 - How to implement HLS Video Streaming in a React App
Thursday, April 18, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 413 Release Date Apr 18, 2024 Your weekly report of the most popular Node.js news, articles and
📱 Issue 407 - Textual Healing: iOS Text Editing Minutiae
Thursday, April 18, 2024
This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 407 Release Date Apr 18, 2024 Your weekly report of the most popular iOS news, articles and projects Popular
💻 Issue 413 - Interview with Senior JavaScript Developer 2024 [video]
Thursday, April 18, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 413 Release Date Apr 18, 2024 Your weekly report of the most popular JavaScript news, articles
💻 Issue 331 - 30+ app ideas with complete source code
Thursday, April 18, 2024
This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 331 Release Date Apr 18, 2024 Your weekly report of the most popular React news, articles and projects
💻 Issue 408 - Curl: Hyper, is it worth it?
Thursday, April 18, 2024
This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 408 Release Date Apr 18, 2024 Your weekly report of the most popular Rust news, articles and projects
📱 Issue 410 - Swift for C++ Practitioners, Part 1
Thursday, April 18, 2024
This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 410 Release Date Apr 18, 2024 Your weekly report of the most popular Swift news, articles and projects