Azure Weekly - Power BI Weekly #267 - 16th July 2024
Power BI Weekly Newsletter Issue #267
powered by endjin
Welcome to the 267th edition of Power BI Weekly! We'll start with the July 2024 Feature Summary this week which is pretty light on the feature updates - the main highlight being the DAX Query View updates, which includes Live Connect support and the ability to add/update multiple measures. Over on the Fabric side, we've been given a couple of updates over the last couple of weeks, the most recent being that there is now GitHub integration for source control (Preview) (enabled via the admin portal), and the other relevant announcement being the Semantic Link Updates June 2024, which incorporates the new Semantic Link Labs toolkit (formerly Fabric CAT Tools) to provide even more options of programmatically accessing and modifying elements of your Power BI semantic model. In fact, Gilbert Quevauvilliers has written about this, describing how to Automate updating your Incremental Refresh Policy for your Semantic Model using the toolkit.
There are a handful of great articles in the Report Authoring and Interactivity section this week, with David Johnston discussing the art of not overcomplicating things in his blog It is ok to keep it simple, Erik Svensen has demonstrated an interesting way of utilizing Visual Calculations to Build a bar chart in one visual with multiple measures, and Adam Saxton has described How to seamlessly switch between levels of a hierarchy using Bookmarks.
Finally, for those in the south of the UK, on Thursday I'll be presenting the session Developing a Modern Data Platform in Microsoft Fabric at the Developer South Coast user group in Southampton. We'll be discussing DataOps principles along with Lakehouses and Medallion architectures, while using a real-world use case to drive the demos. I'd love to see you there!
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
- Matt Allington (@ExceleratorBI) blogs about Finding the Date of the Next Record in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Reid Havens (@HavensBI) talks about Ultimate DAX Dynamic Formatting Combo Package
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Prima blog, David Johnston (@PCUK_BI) delves into Power BI Reports - It is ok to keep it simple
- Chris Webb (@cwebb_bi) writes about Why Power BI Table Visuals With Scrollbars Can Cause Problems
- Erik Svensen (@donsvensen) writes about Building a bar chart in one visual with multiple measures using visual calculations
- Adam Saxton (@GuyInACube) explains How to create a slick way to adjust your Power BI visual
- Chandeep Chhabra (@chandeep2786) explains how to Create an Insightful and Stunning Pareto Table in Power BI
- On the Learning Science YouTube channel, Learning Science explains how to Convert Column Chart to a Line Chart and Line to column chart dynamically in Power BI
- On the edureka blog, Neelam Jyoti (@edurekaIN) explains How to Use Drill Down in Power BI: A Comprehensive Guide
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Fabric blog, Nimrod Shalit announces GitHub integration for source control (Preview)
- Also on the Fabric blog, Ruixin Xu shares some Semantic Link Updates June 2024
- Gilbert Quevauvilliers (@GilbertQue) blogs about Semantic-Link-Labs – Automate updating your Incremental Refresh Policy for your Semantic Model
- On the Power BI community blog, Tharun Kumar Ravikrindhi writes about Mastering Power BI Developer Mode
- On the Purple Frog Systems blog, Tom Owen (@PurpleFrogSys) explains how to Integrate Power BI with Microsoft Teams
- Kim Leblanc (@lecfomasque) covers Combiner des requêtes dans un Flux de données Power BI avec une licence PRO [French]
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, Jason Himmelstein (@jasehimm) announces Power BI July 2024 Feature Summary
- Reid Havens (@HavensBI) talks about Best Practices for Team or Self-Service BI (with Eiki Sui)
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
☁️ Azure Weekly #474 - 7th July 2024
Sunday, July 7, 2024
Azure Weekly Newsletter Issue #474 powered by endjin Welcome to issue 474 of the Azure Weekly Newsletter. First off two Microsoft Fabric posts from the community: Choosing Between the Lakehouse and
Power BI Weekly #265 - 2nd July 2024
Tuesday, July 2, 2024
Power BI Weekly Newsletter Issue #265 powered by endjin Welcome to the 265th edition of Power BI Weekly! A very short edition this week. The only announcement is that of the Power BI Admin portal Usage
Power BI Weekly #264 - 25th June 2024
Tuesday, June 25, 2024
Power BI Weekly Newsletter Issue #264 powered by endjin Welcome to the 264th edition of Power BI Weekly! No technical announcements this week, but Microsoft has yet again (unsurprisingly) been named a
Power BI Weekly #261 - 4th June 2024
Tuesday, June 4, 2024
Power BI Weekly Newsletter Issue #261 powered by endjin Welcome to the 261st edition of Power BI Weekly! I'll quickly mention the updates this week: we've been told that the general
Power BI Weekly #259 - 22nd May 2024
Wednesday, May 22, 2024
Power BI Weekly Newsletter Issue #259 powered by endjin Welcome to the 259th edition of Power BI Weekly! A handful of announcements and updates have been presented to us in preparation for Microsoft
You Might Also Like
Caught In The Middle 💸
Thursday, October 31, 2024
On rich guys, collateral damage, and The Washington Post. Here's a version for your browser. Hunting for the end of the long tail • October 30, 2024 Caught In The Middle The mess with Bezos and The
Powering public sector resilience on Elastic Search AI Platform
Thursday, October 31, 2024
Developing observability capabilities with Elasticㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ elastic | Search. Observe. Protect Driving public sector innovation Elastic AI-
Tuesday Triage #224
Wednesday, October 30, 2024
Your weekly crème de la crème of the Internet is here! The 224th edition featuring PayPal mafia, Modern Martyrs, and awnings. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
📝 You Probably Don't Need to Compile a Linux Kernel Anymore — Adding Sticky Notes to Your iPhone Home Screen
Wednesday, October 30, 2024
Also: Gaming GPUs Used to Be Fun, Not Anymore, and More! How-To Geek Logo October 30, 2024 Did You Know Ancient Romans divided daylight and darkness into 12 increments each. In Rome, this meant an hour
JSK Daily for Oct 30, 2024
Wednesday, October 30, 2024
JSK Daily for Oct 30, 2024 View this email in your browser A community curated daily e-mail of JavaScript news Three.js : BatchedMesh and Post processing with WebGPURenderer An exploration of Three.js
Daily Coding Problem: Problem #1594 [Easy]
Wednesday, October 30, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. You are given given a list of rectangles represented by min and max x- and y-
Ranked | Tech Companies by R&D Investment Change in 2023 📊
Wednesday, October 30, 2024
Most tech companies were born disruptors. So who's prioritizing their next innovation? We track R&D investment changes to find out. View Online | Subscribe | Download Our App Presented by:
JSK Weekly - 30th October, 2024
Wednesday, October 30, 2024
JavaScript powers many modern websites' dynamic and interactive elements. As the complexity of JavaScript apps increases, so does the need for robust testing frameworks to ensure their reliability
Top Tech Deals 👀 MacBook Air, Harman Kardon BT Speaker, Echo Show, and More
Wednesday, October 30, 2024
Score a MacBook, headphones, or PC accessories on sale this week. How-To Geek Logo October 30, 2024 Top Tech Deals: MacBook Air, Harman Kardon BT Speaker, Echo Show, and More Score a MacBook,
We Need More Layer 1s, Please
Wednesday, October 30, 2024
Top Tech Content sent at Noon! How the world collects web data Read this email in your browser How are you, @newsletterest1? 🪐 What's happening in tech today, October 30, 2024? The HackerNoon