Power BI Weekly
Issue #267 - 16th July 2024
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!
🛠️ Data Prep
- Matt Allington (@ExceleratorBI) blogs about Finding the Date of the Next Record in Power Query
🧩 Data Modeling
- Reid Havens (@HavensBI) talks about Ultimate DAX Dynamic Formatting Combo Package
📊 Report Authoring and Interactivity
- 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
- 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
- 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)