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
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