Amal BEN REBAI’s Post

🚀 Power BI Desktop Has New Refresh Options!!! We now have extra options when refreshing with Power BI Desktop: ✅Data + Schema ✅Schema alone ✅Data only 👉 A schema sync always comes first in a refresh by default, and then the data refresh. 👉 You now have the option to update the data alone, leaving the schema unchanged. This comes in quite handy when you want the most recent data and don't want to incorporate a newly introduced column from the source into your model just yet. For Power BI developers, a minor adjustment that greatly increases flexibility and efficiency! 💡 Thank you for sharing, Sandeep Pawar #Microsoft_fabric #powerbi #dax #semanticmodel #dataanalytics

🚀 Power BI Desktop September 2025 Update is here! 🎉 Two major features are redefining how we build and manage datasets: 🔹 Schema Evolution 🏗️ Your model now adapts intelligently to source changes! Whether columns are added, renamed, or dropped, Power BI handles it seamlessly, reducing broken visuals and manual rework. True schema evolution is now part of the BI developer experience. 🔹 Data Refresh in Desktop 🔄 Refresh your data locally inside Power BI Desktop with the same robustness as the Service. Validate transformations, test incremental refresh, and ensure reports are ready before publishing. ✨ Together, the new features brings resilience + productivity to Power BI authors and modelers. 💡 My Take: Schema Evolution 🏗️ → less firefighting when sources change Data Refresh 🔄 → faster iteration, better confidence before sharing This is a game changer for enterprise BI teams! 🚀 #PowerBI #MicrosoftFabric #DataAnalytics #PowerBIDesktop #DataEngineering #SchemaEvolution #DataRefresh

🚀 Power BI Optimization: Power Query vs DAX (Measure vs Calculated Column) When working with Power BI, one common question is: Where should we perform calculations — Power Query, DAX Measures, or DAX Calculated Columns? 🤔 Here’s a quick comparison based on file size, memory consumption, developer waiting time, and required skill level. 🔹 Power Query → Great for data shaping & preprocessing, but may slow down refresh. 🔹 DAX Measures → Best practice for performance & flexibility, keeps file size low. 🔹 DAX Calculated Columns → Useful in certain cases, but increases file size & memory load. ⚡ Key Takeaway: 👉 Use DAX Measures wherever possible for efficiency. 👉 Use Power Query for transformations before loading data. 👉 Use Calculated Columns only when absolutely needed. #PowerBI #DAX #PowerQuery #DataAnalytics #BusinessIntelligence #DataModeling #DataScience #MicrosoftPowerBI

Big news for Power BI developers! The September update introduces a long-awaited feature: user-defined DAX functions (UDFs). This is a game-changer for building cleaner, more maintainable, and reusable Power BI models. Instead of copy-pasting complex logic, you can now define a function once and use it anywhere in your model, complete with input parameters. This is a massive step forward for modular reporting and advanced DAX. #DataAnalysis #PowerBI

Big news in the September Power BI update - we can now create user-defined DAX functions! Why this matters: Reuse logic across multiple measures without rewriting the same code Keep DAX cleaner, modular, and easier to maintain Define input parameters and calculations just like custom functions in Power Query How it works (currently in preview): 1 Go to DAX Query View and use DEFINE FUNCTION to create your custom function 2 Call that function anywhere in your model, just like a built-in DAX function This feels like a big step forward for modular reporting and advanced modeling in Power BI. #PowerBI #DAX #DataAnalytics #Userdefinedfunction

New Power BI Desktop Feature: “Refresh Data Only” and “Sync Schema Only” Power BI continues to evolve — and the latest update brings a game-changing improvement to how we manage dataset refreshes! Until now, clicking Refresh in Power BI Desktop always triggered both a schema sync and a data refresh. But now, you can expand the Refresh button (in the Home ribbon or Data pane) and choose from: 1) Sync schema only – Update your semantic model to match structural changes in your data source (like new columns or type changes) without loading data. 2) Refresh data only – Pull in the latest data while keeping your current model schema intact. This flexibility is especially useful when working with Direct Lake semantic models or large datasets — where you may want to refresh data frequently without altering the model structure. This small but powerful update gives Power BI developers and analysts finer control over refresh operations and helps avoid unwanted schema changes during daily refreshes. Try it out in the latest version of Power BI Desktop and experience a smoother, more intentional workflow! #PowerBI #DataAnalytics #Microsoft #BusinessIntelligence #DataModeling #PowerBIDesktop #DataRefresh #DirectLake #PowerBIUpdates

🚨 Power BI September 2025 Update: Schema & Data Refresh — Now in Desktop! Power BI just made life easier for data modelers and developers. With the new “Refresh Schema & Data” option in Power BI Desktop, you can now: 🔄 Detect and apply schema changes from your source without breaking your model 📊 Refresh both metadata and data in one go — no need to reimport or rebuild 🧠 Maintain semantic model integrity with fewer manual steps 🌐 Achieve modelling parity between Desktop and Web — edit, transform, and manage models anywhere! Whether you're working with Direct Lake, Import, or hybrid models, this feature ensures your reports stay robust and up-to-date — even when your source evolves. 💡 Perfect for BI teams that need to stay responsive to schema changes without compromising data integrity. #PowerBI #MicrosoftFabric #DataModeling #BICommunity #Analytics #DataRefresh #SemanticModels #PowerBIDesktop #DataOps

Power BI Desktop Refresh - September 2025 Update! New "Schema & Data" refresh options in Power BI Desktop makes modeling easier! What's New: You now get separate control over refresh operations instead of the all-or-nothing approach . 3 Refresh Options: 📊 Data Only: Updates values but keeps same table structure 🔧 Schema Only: Adds/removes columns without refreshing data 📋 Schema + Data: Full refresh - structure changes AND latest data together! 💡 Why This Matters: Previously, Desktop always did schema + data together. Now you can choose based on what changed in your source! Perfect for: Teams working with evolving databases where you want control over when new columns appear in your model . No more unexpected schema changes breaking your reports! 🚀 #PowerBI #DataAnalytics #BusinessIntelligence #MicrosoftFabric #DataModeling #Analytics #DataVisualization #BI #DataRefresh #MicrosoftPowerBI #Dashboard

How often do you hear this from your stakeholders? "Can I see that in Millions or Thousands?" As Power BI developers, we know the pain of creating separate visuals or complicated measures just to satisfy different formatting requests. I have developed a robust technique for Dynamic Unit and Currency Sign Switching directly within a Power BI report. The result is a clean, user-friendly interface that lets anyone adjust the displayed sales units and currency on the fly. This is a huge win for report adoption and global data consumption. #PowerBI #BI #DataViz #DAXTips #ReportDesign