Cloudfide’s Business Intelligence Newsletter – JUNE 2026

1️⃣ Dataset Refresh Capacity Errors - "Exceeded Limit" Error and How to Fix It 

• Why is it interesting? Explains exactly what triggers this confusing error (too many semantic models refreshing concurrently on a capacity) and provides practical steps to diagnose and resolve it. 

• Audience: Intermediate → Advanced 

• Area: Maintenance / Capacity Management / Refresh / Troubleshooting 

2️⃣ Power Apps or Translytical Task Flows - Choose the Right Write-Back Approach 

• Why is it interesting? Now that Translytical Task Flows have reached GA, this post definitively answers when to use each approach for write-back in Power BI - with honest trade-offs for both options. 

• Audience: Intermediate → Advanced 

• Area: Power Apps / Translytical / Write-back / Architecture 

️3️⃣ User-Aware Calculated Columns in Power BI - How the New Property Works 

• Why is it interesting? A brand-new Power BI feature introduces an Expression Context property for calculated columns, enabling them to evaluate differently per user - opening new possibilities beyond standard RLS. 

• Audience: Advanced 

• Area: DAX / Calculated Columns / Security / New Features 

4️⃣ Filtering Measures Through Slicers - Why It Doesn't Work and How to Work Around It 

• Why is it interesting? Comprehensive guide to implementing proper calendar tables and time intelligence functions. Essential foundation for accurate financial and operational reporting. 

• Audience: Beginner → Intermediate 

• Area: Time intelligence / Calendars / DAX 

5️⃣ DAX UDF Measures vs. Calculation Groups - The Best Approach for Time Intelligence 

• Why is it interesting? DAX UDF measures centralize time-intelligence logic while avoiding filter-context leaks that silently break tooltips, titles, and table visuals - a compelling alternative worth understanding. 

• Audience: Intermediate → Advanced 

• Area: DAX / Time Intelligence / Calculation Groups / UDF 

6️⃣ The Optimal Shape for Power BI Data - Why Star Schema Still Wins in the Age of AI 

• Why is it interesting? A refreshed, thorough argument for why star schema remains the gold standard for Power BI models - now with additional relevance in the context of AI-assisted analytics. 

• Audience: Intermediate → Advanced 

• Area: Modeling / Star Schema / Architecture / Performance 

7️⃣ Naming Conventions for Semantic Models - Why Consistency Pays Off 

• Why is it interesting? Clear, consistent naming for tables, columns, and measures makes your model easier to use for developers, end users, and AI tools alike - a foundational governance practice that's often overlooked. 

• Audience: Beginner → Intermediate 

• Area: Modeling / Governance / Best Practices / Naming 

8️⃣ Visual Formatting: How to Highlight Data Effectively (here & here) 

• Why is it interesting? Learn how to visually highlight important data points and time periods to improve trend analysis and guide users' attention to the most relevant insights. 

• Audience: Beginner → Intermediate 

• Area: Report Design / Visualizations / UX 

9️⃣ DAX Formatting Tricks - Dynamic Strings, Month Sorting, and DAX Patterns 

• Why is it interesting?  

• Three underused Power BI techniques (dynamic format strings, sort-without-a-column, and MAXX patterns) that meaningfully improve how reports look and behave with minimal effort. 

• Audience: Intermediate → Advanced 

• Area: DAX / Formatting / Reporting / Iterator functions 

🔟 Distinct in Power Query vs. DAX - The Difference Can Break Your Relationships 

• Why is it interesting? Power Query is case-sensitive, DAX is not. Tis mismatch can turn a clean, distinct table into one with duplicates after loading, breaking 1:n relationships in unexpected ways. 

• Audience: Intermediate → Advanced 

• Area: Power Query / DAX / Data Integrity / Relationships