Power BI Weekly #275 - 10th September 2024
Power BI Weekly Newsletter Issue #275
powered by endjin
Welcome to the 275th edition of Power BI Weekly! This week we've been told about the new TMDL support for the ALM Toolkit, bringing a rich diff experience and deployment functionality on models using the TMDL format. Elsewhere this week, Jess Hill has followed up with the second in her blog series, explaining Why Power BI developers should care about the Power BI enhanced report format (PBIR) (to add to her first about the PBIP format), Kurt Buhler has written a detailed blog titled Myths, Magic, and Copilot for Power BI, and Jon Stjernegaard Vöge has written a step-by-step guide about How to share Fabric / Power BI Semantic Models with External Users.
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
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) talks about Duplicate VS Reference in Power Query in Power BI and Fabric Dataflows and and Power Query Basics of M Scripting in Power BI and Fabric
- On the Learning Science YouTube channel, Learning Science (@learn_scitech) describes How to remove special characters from a text column in Power Query?
- Gilbert Quevauvilliers (@GilbertQue) writes Did you know external Guest users can connect to your Semantic Model using Excel
- Rick de Groot (@Rickmaurinus) writes Understanding Semi Joins in Power Query M
- Shivanshu Bisht describes Wildcard Filtering by PQ + DAX or Custom Visual
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the RADACAD blog, Reza Rad (@RADACAD_COM) discusses REFRAME in Power BI Direct Lake
- Chris Webb (@cwebb_bi) explores Advanced Relationship Properties In Power BI Copilot
- On the Business Intelligist blog, Andre Fomin (@AndreFomin) talks about DAX for Time Series Forecasting in Power BI
- Darren Gosbell (@darrengosbell) highlights the DAX Studio v3.2.1 Release
- Adam Saxton (@GuyInACube) covers The Surprising Enhancements for DAX Query View in Power BI with Zoe Douglas
- Laura Graham-Brown (@Laura_GB) talks about a DevOps Parent Child Hierarchy in Power BI
- Reid Havens (@HavensBI) hosts Awesome Use-Cases with DAX Query View with Zoe Douglas
- Jon Stjernegaard Vöge writes about Mastering Power BI Hierarchies: Conditional Drill Through and returning values only for specific hierarchy levels
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the endjin blog, Jessica Hill (@JessRoseHill_) writes about Why Power BI developers should care about the Power BI enhanced report format (PBIR)
- On the SQLBI blog, Marco Russo (@marcorus) covers Context transition in DAX explained visually
- Bas Dohmen (@HowToPowerBI) describes A Game-Changer for Map Visuals in Power BI Distance Filtering
- Sunil Mathew (@_sunil_mathew_) explains how to Build an Interactive Sales Dashboard in Power BI and describes how to Highlight Min/Max Values Across Multiple Years
- Kurt Buhler (@kurtbuhler) covers Myths, Magic, and Copilot for Power BI
- On the RADACAD YouTube channel, Reza Rad (@RADACAD_COM) covers Timesaving Tips to Create Polished Power BI Reports by Allison Kennedy Auckland Power BI & Fabric
- Roland Szirmai (@BILAnalytics) explains how to Transform Your Power BI Reports with Conditional Slicers
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Nandan Hegde (@nandan_hegde15) shares an Automated Way for PBIX to PBIP file Conversion
- Jon Stjernegaard Vöge describes How to share Fabric / Power BI Semantic Models with External Users, describes Exploring the new Dynamic Subscriptions for Power BI Reports and writes about Row Level Security in Microsoft Fabric — Update: No need for Tabular Editor!
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, Sid Vemuri announces TMDL support for the ALM Toolkit
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 #272 - 20th August 2024
Tuesday, August 20, 2024
Power BI Weekly Newsletter Issue #272 powered by endjin Welcome to the 272nd edition of Power BI Weekly! Just a single announcement this week, which is that the Admin monitoring workspace is now
Power BI Weekly #271 - 13th August 2024
Tuesday, August 13, 2024
Power BI Weekly Newsletter Issue #271 powered by endjin Welcome to the 271st edition of Power BI Weekly! It's been a very quiet week this week, so we'll move straight onto the highlighted
☁️ Azure Weekly #478 - 4th August 2024
Sunday, August 4, 2024
Fabric & Data Mesh, Windows 365 GPU-enabled Cloud PCs, Azure Container Storage
Power BI Weekly #269 - 31st July 2024
Wednesday, July 31, 2024
Power BI Weekly Newsletter Issue #269 powered by endjin Welcome to the 269th edition of Power BI Weekly! No announcements this week. On the community front, here are my highlighted bits of content:
☁️ Azure Weekly #477 - 28th July 2024
Sunday, July 28, 2024
Llama 3.1 405B, Fabric July Updates, Sign Language as a Service
You Might Also Like
Moore’s Flinch 💾
Saturday, September 21, 2024
Qualcomm reportedly makes a bold play for Intel. Here's a version for your browser. Hunting for the end of the long tail • September 20, 2024 Moore's Flinch The rumor mill is picking up steam
Power BI Weekly #276 - 20th September 2024
Friday, September 20, 2024
Power BI Weekly Newsletter Issue #276 powered by endjin Welcome to the (belated) 276th edition of Power BI Weekly! Sorry for the delay for this edition - a combination of vacation and general busyness
👆 Is Swiping Faster Than Typing on a Phone Keyboard? — Google Home Features You Gotta Try
Friday, September 20, 2024
Also: What the iPhone 16 Colors Really Look Like, and More! How-To Geek Logo September 20, 2024 Did You Know Thorny dragons, a species of small lizard native to Australia, appear to be able to drink
I recorded a video for you
Friday, September 20, 2024
if you prefer to watch this email instead of reading it, then…
JSK Daily for Sep 20, 2024
Friday, September 20, 2024
JSK Daily for Sep 20, 2024 View this email in your browser A community curated daily e-mail of JavaScript news Attention JavaScript Developers: New Certification Program Hey there p> Bob Senoff Read
The Heat Is On
Friday, September 20, 2024
Nike Ouster, iPhone Transfer Pain, Small Strawberry Models, China AI, iPhone Licenses, Shohei the Money, Disney's Unfreeze The Heat Is On Nike Ouster, iPhone Transfer Pain, Small Strawberry Models,
How to Get More Eyes on Your Stories: Social Media Promotion Tips 💡
Friday, September 20, 2024
Hello again, Hacker💚 Have you ever written an amazing, near-perfect article only for the views to not reflect your hard work? We know what that feels like, so here are some quick tips on how to promote
Ranked | The Most Reliable Car Brands, According to Consumer Reports 🚗
Friday, September 20, 2024
Consumer Reports ranked the most reliable car brands using surveys and analysis of over 330000 vehicles. Which cars are most reliable? View Online | Subscribe | Download Our App Presented by: Get more
Daily Coding Problem: Problem #1562 [Easy]
Friday, September 20, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Amazon. Consider the following scenario: there are N mice and N holes placed at integer
iOS Dev Weekly - Issue 679
Friday, September 20, 2024
Did you get a box with a shiny new device in it today? 📱 View on the Web Archives ISSUE 679 September 20th 2024 Comment Happy New Device Day to those who are celebrating! I hope you'll forgive me a