Azure Weekly - Power BI Weekly #251 - 26th March 2024
Power BI Weekly Newsletter Issue #251
powered by endjin
Welcome to the 251st edition of Power BI Weekly. Move aside SQLBits, it's FabCon week this week, and there have already been some huge announcements on the Fabric side to sink your teeth into. Grab a drink and take a read of Arun's all-encompassing blog here: Announcements from the Microsoft Fabric Community Conference to get an overview of all the new and updated features. A few of the bigger ones being that Mirroring is supported in Public Preview (for Cosmos DB, Azure SQL DB and Snowflake), you can now access on-premises data using the on-premises Data Gateway in Data Factory pipelines, and you can have Folders in the Workspace View! More specifically to Power BI, we've also been given the Power BI March 2024 Feature Summary, which mainly comprises a handful of incremental improvements/updates to existing features.
Elsewhere this week, Patrick Leblanc has shared a video about Decoding Direct Lake: The Truth Behind DirectQuery Fallback, Paul Turley has written a great blog around Moving from Power BI to Microsoft Fabric, and Erik Svensen has shown a clever way to Combine visual calculations and numeric parameters to create a dynamic moving average period.
Finally, Barry has written a great blog reflecting on SQLbits 2024 - The Best Bits (whereby I'm only now realising just how many photos the man takes). All in all, it was a wonderful conference, wonderfully run with wonderful people. Hope to see you there next year!
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 sibling 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
- Adam Saxton (@GuyInACube) describes How to connect to Microsoft Fabric Items from Power BI Desktop?
- Patrick Leblanc (@GuyInACube) discusses Decoding Direct Lake: The Truth Behind DirectQuery Fallback
- Chris Webb (@cwebb_bi) talks about Best Practices For Power BI On Databricks Webinar
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Vpax Obfuscator and DAX Optimizer – Unplugged #57
- On the SQL Server Central blog, Koen Verbeeck (@Ko_Ver) explains How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer
- Chandeep Chhabra (@chandeep2786) describes How to Perform VLOOKUP in Power BI and talks about Who bought A but not B? . . . (Pattern Analysis in Power BI)
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Erik Svensen (@donsvensen) delves into Power BI – Combine visual calculations and numeric parameters to create a dynamic moving average period
- Also on the Learning Science YouTube channel, Learning Science explains How to calculate moving average at visual level in Power BI without using complex DAX measure
- Andrzej Leszkiewicz (@avatorl) covers HTML/CSS in core Power BI visuals
- Reid Havens (@HavensBI) describes Turning Beast to Beauty: Removing Chart Junk in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Chris Wagner (@KratosBi) describes Everything About Power BI Security
- Philipp Lenz (@lenz_philipp) writes about Dynamic subscriptions with email in Power BI – Part 1
- Nikil Prabhakar wonders Is Data Activator ready for Prime Time?
- Ignacio Barrau (@ignacho_07) covers [Fabric] Data Activator - Triggers y alerta instantánea [Spanish]
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Saveen Reddy (@MSPowerBI) shares the Power BI March 2024 Feature Summary
- Paul Turley (@paul_turley) walks through Moving from Power BI to Microsoft Fabric
Useful Links
- Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
- 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
- PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
- 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
Tweet | Forward | Preferences | Unsubscribe
Older messages
Power BI Weekly #250 - 20th March 2024
Wednesday, March 20, 2024
Power BI Weekly Newsletter Issue #250 powered by endjin Welcome to the 250th edition of Power BI Weekly! SQLBits is upon us - I hope a good number of you have been fortunate enough to attend this year.
☁️ Azure Weekly #457 - 10th March 2024
Sunday, March 10, 2024
Azure Weekly Newsletter Issue #457 powered by endjin Welcome to issue 457 of the Azure Weekly Newsletter! In order to tackle the increasing volumes of spam and phishing emails, various email providers
☁️ Azure Weekly #456 - 3rd March 2024
Sunday, March 3, 2024
Azure Weekly Newsletter Issue #456 powered by endjin Welcome to issue 456 of the Azure Weekly Newsletter. A varied selection of articles this week. Let's start with AI; Fine Tuning with Function
Power BI Weekly #247 - 27th February 2024
Tuesday, February 27, 2024
Power BI Weekly Newsletter Issue #247 powered by endjin Welcome to the 247th edition of Power BI Weekly! A flurry of announcements came shortly after last week's edition, and it's not really
Power BI Weekly #246 - 20th February 2024
Tuesday, February 20, 2024
Power BI Weekly Newsletter Issue #246 powered by endjin Welcome to the 246th edition of Power BI Weekly! We're still awaiting the first Power BI feature summary of the year, but from what I can
You Might Also Like
📧 Simple Messaging in .NET With Redis Pub/Sub
Saturday, July 27, 2024
Simple Messaging in .NET With Redis Pub/Sub Read on: my website / Read time: 5 minutes BROUGHT TO YOU BY API Collaboration Has Never Been Easier API Collaboration has never been easier with
📳 Galaxy Z Flip 6 Review — How to Watch the 2024 Summer Olympics for Free
Friday, July 26, 2024
Also: Fixing Spotify's Repeating Ads, and More! How-To Geek Logo July 26, 2024 Did You Know The rectangular area of a flag found in the upper left corner (top hoist corner) of the flag, such as the
Your monthly update has arrived
Friday, July 26, 2024
What's new in Google Play and Android July 2024 The Collections surface engages users with content Introducing Collections, a new on-device surface for your content Collections present users with
iOS Dev Weekly - Issue 671
Friday, July 26, 2024
There are two types of apps on the visionOS App Store. Will you create an app that makes people reach for the headset? 🥽 View on the Web Archives ISSUE 671 July 26th 2024 Comment In the last two weeks
Ranked | The 10 Busiest Ports in the World, by Cargo Traffic 🚢
Friday, July 26, 2024
As critical nodes for trade and commercial activity, we show the top 10 busiest ports in the world by cargo volume. View Online | Subscribe Presented by: Is Your Portfolio Powering the Future? >>
Let the Games Begin
Friday, July 26, 2024
Week of July 22, 2024 Let the Games Begin Week of July 22, 2024 By MG Siegler • 26 Jul 2024 View in browser View in browser Mark Zuckerberg loves two things above all else right now: llamas and
Daily Coding Problem: Problem #1508 [Hard]
Friday, July 26, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Uber. Given an array of integers, return a new array such that each element at index i
OpenAI announces SearchGPT - Weekly News Roundup - Issue #477
Friday, July 26, 2024
Plus: Will billionaires live forever; a police robot dog jamming wireless networks; Alphabet to invest $5B into Waymo; warnings about “model collapse”; a new partnership for AI security; and more! ͏ ͏
Using Data as a Product Manager
Friday, July 26, 2024
If you had your choice between a little data or a lot of data on which to guide decisions, which would you pick?
Last Mile of Blockchains: RPC and Node-as-a-Service
Friday, July 26, 2024
Top Tech Content sent at Noon! Find the hottest jobs from top tech companies Read this email in your browser How are you, @newsletterest1? 🪐 What's happening in tech today, July 26, 2024? The