A Year in Review, Fabric Community Update - December 2024
A Year in Review, Fabric Community Update - December 2024 Thank you to all our Fabric Community members! The Fabric community team would like to take the opportunity to say thank you for your contributions over the 2024 year. Providing solutions, posting in galleries, writing blogs, and participating in user groups are some of the ways you have helped make the Fabric community a great place to be. Join us at the 2025 Microsoft Fabric Community Conference 2024 introduced #FabCon, the Fabric Community Conferences that attracted over 8,000 Fabric fans across 2 sold out conferences in Las Vegas and Stockholm. FabCon 2025 in Las Vegas from March 31 to April 2 will be the biggest-ever FabCon. With 4 keynotes, 215 sessions, and 20 full-day Workshops covering Power BI, Fabric, SQL and AI, it’s the ultimate learning event for BI professionals, database professionals, and developers. Here are 5 more reasons to join us at FabCon in 2025: The extremely popular Ask the Experts enclave with 12+ dedicated booths to answer your trickiest technical, capacity, and billing questions. The much-anticipated FREE Partner Pre-Day for systems integrators to help grow their Fabric practice. The buzzing Community Lounge to connect and collaborate with like-minded professionals, stalwarts (and celebrities) in the data community. The ever-popular Power Hour where you are guaranteed to learn NOTHING but may luck out with cool swag. And brand new at FabCon 2025, a Power BI visualization showdown where you get to watch and vote on the best of the best competing for our world title! Snag the early bird discount before Dec 31 and use the code MSCUST to get another $150 off, this is the lowest it’s ever going to be! Need help convincing your boss, use this letter! The Fabric community has grown so much in 2024! If you haven't seen all the updates that have been made to the Fabric community this year, now is the time. Get started with the Fabric community landing page and explore the Career Hub, expanded forum experiences and community blogs. Career Hub Expanded forum experiences Data Engineering Data Warehouse Data Science Databases Fabric platform Fabric community blogs Fabric community support Be one of the first to start using Fabric Databases Ready to build reliable, highly scalable applications where cloud authentication and encryption are secured by default? Watch on-demand SQL database in Fabric session with database experts and the Microsoft product team and see just how easy it is to get started. View all the sessions here. Popular blogs Here are some community blogs from the past year, that are getting attention and that you might be interested in! [Power BI] Measure Killer - external tool to clean model by @ibarrau Power BI Dynamic Date Filters: Automatically Updating Filters with Each Refresh by @ Fowmy Page Level Security in Power BI by @truptis Utilize Power BI Semantic Model within Power BI Reports Builder by @SamInogic Refresh Power BI Semantic Model from MSFT Fabric Data Pipeline by @NandanHegde Blogs from the Fabric team Announcing SQL database in Microsoft Fabric (Preview) Store and access your Iceberg data in OneLake using Snowflake and shortcuts Announcing preview of Workspace Monitoring The Microsoft Fabric Community Conference is coming back to Las Vegas! Announcing New Recruitment for the Private Preview of Microsoft Fabric SKU Estimator Community Spotlight Members Each month a member of the Fabric community is chosen to be showcased for their exemplary community contributions. Community Spotlight Members answer questions, provide solutions and share their expert knowledge. They are valued community members that go above and beyond to support the Fabric community. Meet @Brunner_BI, November Spotlight member. Super User Power BI Community Member since 2020 80+ Kudos 40 Solutions authored 260+ Replies Creator of the Measure Killer tool Thank you to all the 2024 Community Spotlight members. @bhanu_gautam @DoherDrizzle @jennratten @Ashish_Mathur @rubayatyasmin @lbendlin @Jihwan_Kim @aj1973 @technolog People are finding solutions These are the most popular questions about Fabric that got answered in the past year. Power BI: Add a table to a semantic model - using Power BI desktop or online services Fabric Platform: How to access Fabric Warehouse from Fabric Notebooks? Data Factory: Execute Data Pipeline Via API Real-Time Intelligence: Data Activator Power BI Report Alert Refresh Rate Popular discussions These are the trending discussions in the forums. Power BI: Connecting Power BI Desktop to Stored Procedures: Feasibility and Best Practices Fabric Platform: Fabric compute capacity exceeded its limits. How to know how much CU each dataflowgen2 consumes Data Factory: Truncate Warehouse SQL table Real-Time Intelligence: Fabric workspace item events - alert creation failed Trending Data Stories for Power BI Visit the Data Stories Gallery for more inspiration and ideas. Global Supermarket by @AjitPadole_ Operational Overview for Quick Service Restaurants by @RapidaSolutions To stay up-to-date with Fabric, visit Fabric Community News and select Subscribe from the Options menu.Week 2 | Tourism in the UK: Office of National Statistics
This week's report is from the UK's very own Office of National Statistics. I wanted to show some of the amazing things Power BI can do - from shape maps to the rarely used treemap (does this count as a horizontal Mikko chart maybe?) to enhanced data labels and even some overlapping columns. I wanted the design to be intuitive - the user starts by looking at a regional comparison, and they can drill down by hovering on any of the cards to a specific region - and seeing which countries send them the most visitors - by spending, nights spent, or by # of visits. I'm also very proud of the vertical SVG you can see in the Matrix in the details tab - this is an SVG I made for this entry. It combines each SVG from each row to create a cohesive visual inside the matrix. Hope you like this one! Data Source: Office for National Statistics. (n.d.). Overseas travel and tourism: Quarterly estimates of overseas residents’ visits and spending [Data set]. Retrieved February 22, 2025, from https://www.ons.gov.uk/peoplepopulationandcommunity/leisureandtourism/datasets/overseastravelandtourism Topojson file used for Shape Map: https://github.com/ONSvisual/topojson_boundaries/blob/master/geogUKregion.json eyJrIjoiNzU3YmNhZTAtMzlmZS00ZDY4LTg3NjktNzhhZTU3YTAzYzBhIiwidCI6IjM0YTk4Yzk0LWI1M2MtNGU0My1iNzlkLWUxMGNhYjIwYWY5NiIsImMiOjl9&pageName=d3fdc3376804a8422f84World Champion Winner - Live Finale Build - Europe's Flavor Story
Europe's Flavor Story – A vivid painting os life across Coffee, Chocolate and Life Satisfaction The report is structured into two main pages, each designed to present data in a clear and interactive way. Page 1 - Home Page – Interactive Map Overview Displays a dynamic map of Europe, highlighting countries based on selected indicators. Users can filter by region (Eastern, Northern, Southern, Western) to explore specific areas. Color palettes adjust automatically based on the selected type of color blindness, ensuring accessibility. The introduction outlines the three key themes: coffee consumption, chocolate consumption, and life satisfaction. Page 2 – Main Page - Fully Responsive Visuals The entire page adapts to the selected parameter (Coffee, Chocolate, or Wellbeing). Each selection changes: The overall color scheme Titles and explanatory texts Tooltips and chart content Key indicators, such as average consumption and historical variation Charts and tables update to reflect the most relevant data for the chosen theme. The “Shifting Pulse” table presents a dynamic Top/Bottom N view, showing how countries have moved over time—highlighting which ones are gaining or losing relevance in the selected indicator. Interactivity as a Core Focus A key goal was to ensure the user could actively explore the data, not just read it. Every visual element responds to user input, creating a context-aware experience. Navigation is guided by simple interactions, with visuals that shift to match the selected topic. The intent is to bring the data to life, allowing users to observe patterns, compare regions, and follow trends in a way that feels intuitive and engaging. eyJrIjoiNjFlNDFmNDMtYzc2My00YjYwLWI5MTItODU3OWQ1ZTg5MjAxIiwidCI6IjE2Njk5MjVkLTJlNTItNDMzZC1hM2U1LTQwNGEzYWU5ZTZhNiJ9Please read before posting to this gallery!
Community Sticker Challenge Barcelona 2026! Any registered Fabric community members, including all Microsoft team members, may submit a unique design for a new sticker in one of four label categories: "Inside joke" – for developers/data Certified & Proud - Flaunt your achievements! This sticker is for everyone who’s earned a new certification and wants to celebrate their success. AI- Powered- Celebrate how you use AI with Fabric & SQL Community Enthusiasm: Barcelona Edition - celebrate the energy of Barcelona data community! Before you get started we recommend that you read the blog post here: https://aka.ms/CommunityStickerBCN2026 , which outlines important information like rules, design criteria, how finalist are chosen and more. We can't wait to see what you come up with!Fabric Community Update - August 2025
Fabric Community Update - August 2025 Could you be the next Power BI Dataviz World Champion? There’s only one way to find out! Enter the preliminary round now through August 18th to compete for your spot as a finalist in the world championships - live on stage at FabCon in Vienna! We’re including community voting this time, so even if you don’t want to enter, you can still participate. View all the details for the Power BI Dataviz World Championships, community sticker challenge and two other contests happening this happening this month on the Fabric Community contest page. The Microsoft Fabric Community Conference is back x2! Join us in Vienna! With 10 full day Tutorials, a Partner pre-day, more than 120 sessions from Product Teams and the Community, AND the Power BI Dataviz World Championships our swag filled Power Hour, FabCon Europe will be landing in Vienna, Austria on September 15 – 18, 2025. Register for FabCon Vienna and use code FABCOMM to save €200! Can’t make it to Europe this year? FabCon is happening again in the United States in Atlanta. Mark your calendars for March 16-20, 2026. Register for FabCon Atlanta and use code MSCATL for a $200 discount on top of current Super Early Bird pricing! Celebrate our new and returning Super Users Congratulations to all of our new and returning Super Users. Thank you for all of your valuable contributions. Learn more about becoming a Super User and view all the new and returning Super Users. Popular blogs Here are some community blogs from the past month that are getting attention: Field Parameters in Power BI by Ilgar_Zarbali How to Use Notebooks in Microsoft Fabric: A Quick Start Guide by bhanu_gautam A Cost-Effective Fabric Solution Driven by Azure Automation by charlyS Comparing JSON in Eventhouse Without Defining Schema by kustortininja Send Customized Emails Using Fabric Data Pipelines by tharunkumarRTK Top blogs from the Fabric team Announcing Shortcut Transformations: from files to Delta tables. Always in sync, no pipelines required. Fabric Data Agents + Microsoft Copilot Studio: A New Era of Multi-Agent Orchestration (Preview) Sunsetting Default Semantic Models – Microsoft Fabric New in OneLake: Access your Delta Lake tables as Iceberg automatically (Preview) Community Spotlight member Each month a member of the Fabric community is chosen to be showcased for their exemplary community contributions. Community Spotlight members answer questions, provide solutions and share their expert knowledge. They are valued community members that go above and beyond to support the Fabric community. This month, we would like to spotlight ArwaAldoud. In addition to the following community contributions, Arwa is one of the user group leaders for the Sudan Microsoft Fabric User Group, one of our extraordinary Super Users, and blog author. • Solutions Authored: 25+ • Kudos received: 80+ • Replies: 90+ When asked a fun fact about herself, Arwa said “I love turning complex data into simple, relatable stories—and I’m passionate about making data concepts easier to understand for everyone, especially in regions with limited access to resources. I believe technology and learning should be accessible to everyone, everywhere. Despite the challenges, I’m proud to lead the first community in Sudan dedicated to Microsoft Fabric and Power BI. As part of the Microsoft Super User program, I stay inspired by helping others grow their skills and confidence. My idea of fun? Turning messy data into something so clean, it could be art.” Congratulations, Arwa! Check out our article on contributing to the community and you may be chosen as the spotlight member in the future. https://community.fabric.microsoft.com/t5/Using-the-Community/Contributing-to-the-Community/ta-p/324... People are finding solutions The following are some popular questions about Fabric that got answered in the past month: Power BI: Card Visual not showing correct values after excluding dimension column Data Engineering: FnO-812: Need to enable additional Data Warehouse: Best Practice for Organizing Multiple Fact and Dimension Tables in Fabric Lakehouse for Power BI Rep Data Science: Execute DAX via. app registration and Power BI Rest API Data Factory: Copy job orchestration and error handling Real-Time Intelligence: How implementing a data activator to monitor the execution of a data pipeline Databases: Fabric SQL database is stopped working while calling from WebApi Fabric platform: 1 Fabric licence - 2 subscriptions Popular discussions Some trending discussions in the forums: Power BI: connection to dataflows Data Engineering: Upsert data to Lakehouse Table using copy data Data Warehouse: RLS using EntraId groups on Warehouse Data Science: Connecting Fabric Data Agent via Service Principal or Managed Identities Data Factory: Fabric copy job CDC fail Real-Time Intelligence: Power BI Alert – “Creating item” Hangs When Creating New Activator Item via Alert Dialog Databases: Cosmos DB is not available as an option Fabric platform: The created On Premise gateway is not showing up as an connection option in copy activity Trending Data Stories for Power BI Visit the Data Stories Gallery for more inspiration and ideas. Hospital Emergency Room| Dashboard by mizan2390 Student Admission Tracker by Anonymous To stay up-to-date with Fabric, visit Fabric Community News and select Subscribe from the Options menu.
Week 2: Climate Change - Unequal Responsibility, Shared Impact
The Narrative: From Human Habit to Planetary Impact This report tracks the journey from how we live (individual emissions) to what we have built (historical legacy), ending with the physical bill the planet is currently paying. The narrative structure moves from individual carbon intensity (per capita) to the cumulative historical burden, concluding with the observable impact on the global climate system. The Challenge: Making a Logical Jump The biggest challenge was connecting the dots between two very different types of data. Chapters 1 and 2 look at specific countries and regions, while Chapter 3 looks at the planet as a whole. To make this transition work, the report shifts from looking at where emissions happen to what they eventually do to the Earth. It frames the global temperature and sea level changes as the combined physical "receipt" for all that regional activity we looked at earlier. Chapter 1 - The Current State. This chapter uses a world map to visualize the wide range in per capita CO₂ emissions across nations. Chapter 2 - The Trajectory. A line chart and a continental heatmap track 174 years of emission shifts, capturing how regional trajectories have diverged over time, from the Early Industrial Era to the Paris Agreement. Chapter 3 - The Collective Impact. This final section shifts to planetary outcomes, using a 10-year lag and 0-100 normalization to align temperature anomalies with rising sea levels. Technical Notes 0–100 Normalization: Comparing degrees Celsius directly to millimeters is not mathematically sound. Normalization was used to rescale both variables to a 0–100 range, allowing for a precise visual comparison of their relative trajectories and rates of change over the 174-year timeline. 10-Year Temporal Lag: A 10-year lag was applied to the sea level data to account for the physical response time of the climate system. This adjustment aligns the atmospheric "cause" with the oceanic "effect" on a shared horizontal axis, making the coupled relationship between the two indicators visible. *Please note this entry has been previously submitted via a wrong email address. This is my official entry.
World Champs Finalist - Live Finale Build - Chocolate or Coffee?
Have you ever imagined creating a report from scratch in just 20 minutes, live on stage, in front of a large audience at a Microsoft conference event? That was exactly my experience with this report, presented as a finalist in the grand finale of the Power BI DataViz World Championships. I had the great honor of sharing the stage with three outstanding Power BI professionals (my deepest respect and admiration for them). The report is designed to provide an overview of coffee and chocolate statistics in terms of kilograms per capita available for human consumption, across different regions, many countries, and trends over time. You’ll also be able to explore key indicators and navigate through a timeline spanning more than 60 years of history. Thank you for visiting my report I truly hope you enjoyed it. Sincerely, Daniel Guevara eyJrIjoiZDBkNTFjNGEtNzJjZi00N2EwLTk5OGMtN2EyZGRkODA3YjRhIiwidCI6ImU4NTg1Zjg3LTQ0MmUtNDk1ZS1hMGRiLWQ3YzM2MDA1ODUxZCIsImMiOjJ9Week 3: 126 Years, 3 Stories.
About This Report This report explores over 125 years of Olympic Games history (1896–2022), surfacing non-obvious insights into medal dominance, Winter Games exclusivity, geopolitical shifts, and the strategies that define Olympic success. Primary Data Source Kaggle Olympic Summer & Winter Games dataset modified by Stéphane Bruno 162,000+ competition results across 53 Olympic Games 75,900 unique athletes, 238 countries, 86 disciplines License: CC BY-NC-SA 4.0 Supplemental Data Sources World Bank Population Data (SP.POP.TOTL indicator, CC BY 4.0) 204 countries with 2022 population figures Enables per-capita medal analysis — reframing Olympic dominance entirely e.g., Norway earns 104 medals per million people vs. the USA's 8.9 Milan-Cortina 2026 Winter Olympics Event List (Wikipedia, CC BY-SA 3.0) ~116 medal events across 16 disciplines Includes new events: Ski Mountaineering, Women's Large Hill, Mixed Team Skeleton, and more Connects historical trends to the upcoming Games eyJrIjoiNDEyNjEzZGYtMjU3ZS00Yzg2LTk3NGQtYjI3NTAwMzQ1ZWZhIiwidCI6IjM0YTk4Yzk0LWI1M2MtNGU0My1iNzlkLWUxMGNhYjIwYWY5NiIsImMiOjl9
Microsoft Fabric Community Conference 2025
Hear from Arun Ulag, CVP of Azure Data on his favorite part of FabCon Europe, what's new at the second FabCon in Las Vegas, and how we're making sure it's bigger and better than ever before across a variety of topics! Join us March 31-April 2 in Las Vegas to kick off our second year of the Microsoft Fabric Community Conference. Register Now at https://fabricconf.com/. Follow us on X - https://x.com/mspowerbi More questions? Try asking the Power BI forums @ https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi #Microsoft #PowerBI #FabCon watch?v=IqvDWEhozEIWorld Champs Finalist - Live Finale Build - A Coffee/Chocolate data story
Hi everyone, I’m excited to share my Power BI report created for the finals! The topic explores coffee and chocolate consumption across the world since the 1960s, with a special look at: Global trends over time – how coffee and chocolate consumption evolved. Regional contrasts – showing that producing countries are not always the biggest consumers. Nordic focus – where coffee culture meets life satisfaction (hello, Fika ☕). Final takeaway – it’s not just about the quantity consumed, but the quality of the moment shared. This report was designed with curious travelers, lifestyle enthusiasts, and everyday readers in mind, not statisticians. My goal was to keep it clear, engaging, and visually compelling while telling a story. eyJrIjoiYWVlYjhiMGMtYmU1NC00NzgyLThjN2MtMWUyNmQ5YjFhODc5IiwidCI6ImM1YTgxZjQ5LWVhYTEtNGQ5Yy1hNjg5LTg1NzJiMzgwMjlhNCJ9
