Microsoft Fabric Schedule Inventory
A Microsoft Fabric app that answers one question: what is scheduled to run in my Fabric tenant, and when? It scans every workspace the app identity can access, keeps only the items that have at least one schedule (notebooks, pipelines, datagflows, copy jobs, semantic models...) and shows them as a searchable inventory and a 24-hour Gantt timeline so you can spot overlaps and capacity peaks. Features Tenant-wide scan of every workspace the app identity can see, with live sync progress. Inventory of scheduled items with search, capacity / workspace / item-type filters, sorting, paging and direct links to the Fabric portal. Gantt timeline of a "typical day", with bars sized by the average duration of recent runs, grouped by capacity or workspace, plus a per-group load strip and peak concurrency. Run history: the last 20 job rund of every scheduled item are stored at sync time. Keyboard accessible, works inside the Fabric portal or standalone, and follows the host's light or dark appearance (light by default). 🔗 Source code GitHub: https://github.com/kilianbs/fabric-schedule-inventoryData Quality Monitor – A practical data-quality validation app for Microsoft Fabric
Overview Data Quality Monitor is a Microsoft Fabric application prototype developed for Data Days: AI Work. It provides a practical workspace for assessing data quality, identifying failed checks, managing validation rules, and tracking issues through resolution. What the app does ✅ Quality rules management Seven configurable validation rules. Covers completeness, validity, uniqueness, and approved-value checks. Enable or disable individual rules. ✅ Data validation Executes enabled rules against a 12-record synthetic retail operations dataset. Calculates a quality score. Records passed and failed checks. Each validation run evaluates 84 checks across the 12 synthetic records. The demonstration currently records a 92% quality score, with 77 passed checks and 7 failed checks per run. ✅ Issue investigation Identifies problematic records and fields. Classifies findings by severity: Critical, High, and Medium. Displays the failed value and validation message. Allows users to mark identified issues as resolved. ✅ Validation history Records individual validation runs. Displays quality scores, passed checks, and failed checks. Maintains validation-run history for comparison. ✅ Technology and implementation Built with React, TypeScript, Tailwind CSS, and Lucide icons, using Microsoft's Rayfin-based architecture for Fabric applications. The current demonstration uses synthetic data and local validation logic. Live Fabric data-source integration is not yet implemented. ✅ Why I built it Data quality problems can undermine analytics and reporting before they become visible to business users. The goal was to build a practical tool that makes data-quality results visible, actionable, and easier to investigate. This project is my contribution to Data Days: AI Work. ✅ Try the application Live application: https://legal-flame-e535066b79-southafricanorth.webapp.fabricapps.net Built by: Olufemi Olamoyegun Project: Data Quality Monitor Version: 1.0.0
Excel in Fabric
Hey Fabric and Power BI folks! I'm sure many of you have heard the same words that bring me despair after working on a beautiful report "Can we export that to Excel?" There are even songs about it. To learn how Fabric Apps work, I decided to stop fighting my stakeholders and instead build Excel functionality directly in Fabric. Introducing Excel in Fabric. In the video below you can see a standard Power BI report in the service. Clicking on the "Export to Excel" button opens a Fabric App that loads an Excel-like experience. What's cool is that clicking the button doesn't just load the app, it also brings in the data, as filtered on the report! Interacting with the data allows for many of the quick features people know and love about Excel: AutoSum, formulas like SUM, AVERAGE, MIN, COUNT. Naturally, from my app you can still... Export to Excel, complete with the formulas! To be clear, I built this Fabric App as an inside joke for the community but I was blown away with how easy it was for me (and Claude Code) to bring my idea to life. A couple practical learnings for me in this fun project: Learning I could pass the page's filters into the Fabric App as a base64-encoded URL, built in a DAX measure. Fabric Apps query the semantic model as the signed-in user, meaning their permissions still apply. (probably applies to RLS too - but I did not test yet) Don't be afraid to try! With the Fabric Apps platform and AI nearly anything is in the realm of possible. If anyone wants to dig around, the URL to the repo: https://github.com/jon-M-M/excel-in-fabric
Building a Microsoft Fabric Rayfin App for Excel & CSV Ingestion Using OneLake Open Mirroring
I'm excited to share my latest Microsoft Fabric community solution: OneLake Open Mirroring – Fabric App, built using Rayfin, Microsoft Fabric, OneLake, and Open Mirroring. 💡 The Challenge Many organizations still rely on Excel and CSV files for operational data. Bringing these files into an analytics-ready platform often requires additional ingestion pipelines, transformations, and manual effort. 🎯 The Solution I developed a custom application that enables users to upload Excel and CSV files directly into Microsoft Fabric, archive the original files in OneLake, and automatically publish worksheets as tables using Fabric Open Mirroring. ✨ Key Features ✅ Excel & CSV Upload – Supports XLSX, XLS, and CSV formats. ✅ OneLake Integration – Archives original files in a Fabric Lakehouse. ✅ Open Mirroring – Publishes individual worksheets as tables in a Fabric mirrored database. ✅ Smart Data Handling – Supports append-only and key-based upsert operations. ✅ Interactive Experience – Preview worksheets, select tables, and configure key columns before publishing. ✅ Replication Monitoring – Track table replication status directly from the application. ✅ Secure Authentication – Uses Microsoft Entra ID and delegated OneLake access without server-side client secrets. ✅ Native Fabric Experience – Built with Rayfin to deliver an integrated application experience within Microsoft Fabric. 🏗️ Solution Architecture Excel / CSV → Rayfin Fabric App → OneLake → Open Mirroring → Fabric Mirrored Database 🌟 Why This Matters This solution demonstrates how Microsoft Fabric can extend beyond traditional analytics into interactive, user-driven data ingestion applications. It provides a practical approach to simplifying spreadsheet ingestion, reducing manual effort, and making operational data available for downstream analytics. 🔗 GitHub Repository Explore the source code, architecture, prerequisites, and step-by-step deployment guide: https://github.com/nikunj11itdhm/Onelake-OpenMirroring-fabric-app 💬 I'd love to hear your feedback! Let's connect, collaborate, and learn together! #MicrosoftFabric #OneLake #OpenMirroring #FabricCommunity #DataEngineering #Rayfin #MicrosoftDataPlatform #Analytics #DataIntegrationCapacity Command
Capacity Command is a tower defense game with a theme of Fabric Capacities. Upgrade your capacity to increase the number of towers you can place, and defend against capacity consuming enemies (Pipeline Runs, Report Refreshes, Spark Jobs, and ad-hoc queries) Give it a try yourself: Capacity SiegeCert Champ
Cert Champ is a Kahoot inspired quiz style game to help people practice for Fabric certifications! A host can enter new questions or use questions from the question bank, and then participants race against each other to see who can solve the questions the fastest! Cert Champ https://github.com/taylorsamy/CertChampExploring Fabric Apps: Delivery Service Example
Delivery Service App with Microsoft Fabric This sample application is built around the Delivery Service scenario, demonstrating how Microsoft Fabric Apps can bring data and application experiences together. The app provides an interface where users can explore delivery operations, navigate through information, and interact with data through a more application-oriented experience, going beyond the traditional report format. This approach also opens up opportunities to incorporate other Fabric capabilities, such as Real-Time Intelligence, streaming data, and AI-powered functionality, bringing operational workflows and data interactions into a single application experience. What kind of business scenarios would you explore with Fabric Apps? I'd love to hear your ideas!
Fabric Arcade – six retro games (and an emulator lounge) running inside Microsoft Fabric
Hi everyone! 👋 I wanted to see how far a Fabric App could go beyond dashboards, so I built Fabric Arcade: a small arcade with classic-style games you can play right inside the Fabric portal. Single-player runs post to a shared leaderboard for everyone in the workspace. 🕹️ What's in the arcade Bolt Rush – a high-speed platformer with slopes, springs, boost pads and a charge dash, starring an original mascot. Steel Raid – a '90s-style run-and-gun mission. You free prisoners to get heavy weapons and grenades, and the mission ends with a boss tank. Bug Invasion – a fixed shooter against a marching alien fleet that speeds up as it thins out, with bunkers that crumble and a bonus mystery ship. Snake – the classic, with a leaderboard. Snake Versus – two snakes on one board; the last one moving wins the round. Duel Cup – head-to-head football on one keyboard, or against the CPU. All graphics are drawn in code (Canvas and SVG) and every sound is synthesized with WebAudio, so the app ships no third-party art or audio. 🏆 Shared leaderboard Every finished single-player run is saved as a Score row through the Rayfin data API. Row-level security means everyone in the workspace can read every score, but you can only create or delete your own. The ownership check runs server side against your sign-in, so nobody can post a score under someone else's name. 💾 Emulator lounge There's also a corner for Game Boy Advance and PlayStation games, powered by the open-source EmulatorJS. You load a game file you own from your own disk. It's read locally in the browser and never uploaded, and the app itself contains no emulator code, BIOS files or games. 🌐 Coming next: online multiplayer I'm working on online play for Duel Cup and Snake Versus. One player creates a room and gets a 4-character code, and the other joins with it. The Fabric data API is only used for the initial WebRTC handshake. After that, the two browsers talk to each other directly, peer to peer, with the host running the match and streaming its state about 60 times a second. 🛠️ How it's built Fabric Apps (preview) with the Rayfin SDK: authentication, the data API on MSSQL, and static hosting. React, TypeScript, Vite and Tailwind. Each game engine is a pure TypeScript module with unit tests. The canvas components only handle input, drawing and sound. Deployed with npx rayfin up. 🔗 Source code GitHub: https://github.com/Al3ssi03/fabric-games I'd love feedback, especially from anyone else pushing Fabric Apps in unusual directions.Building a Modern Marketing Campaign Operations App with Microsoft Fabric & Rayfin
Excited to share a new project: Fabric App – Rayfin Marketing Campaign Operations! Built using Microsoft Fabric, Rayfin, React, interactive maps, persistent workflows, and performance analytics, this application demonstrates how organizations can move beyond dashboards and create operational apps directly on top of Fabric data. ✅ Campaign workflow management ✅ Interactive geospatial visualisation ✅ Embedded analytics & KPIs ✅ Modern React-based experience A great example of how Microsoft Fabric can power both analytics and business applications on a unified platform. Marketing teams often manage campaigns across multiple regions, channels, and vendors. While analytics platforms provide visibility into campaign performance, operational actions still happen outside the analytics environment through emails, spreadsheets, and disconnected applications. This creates challenges such as: Limited operational visibility Manual campaign tracking Delayed decision-making Fragmented workflows Lack of location-based campaign insights The application combines: Microsoft Fabric as the unified data platform Rayfin for application development React for modern user interaction Geospatial Maps for regional campaign visibility Persistent Workflows for campaign management Analytics Dashboards for performance monitoring The solution demonstrates how organizations can: Business Need Solution Campaign Tracking Persistent workflow management Regional Insights Interactive maps Performance Monitoring Embedded analytics Faster Decisions Real-time data access Operational Efficiency Unified application experience Conclusion: This project demonstrates how Microsoft Fabric and Rayfin can be combined to create modern, data-driven operational applications that move beyond traditional dashboards. By integrating interactive maps, persistent workflows, React-based experiences, and analytics, organizations can empower business users to both understand and act on their data from a single application. If you are exploring how to operationalize your Fabric investments beyond reporting, this project provides a practical example of what's possible. ref: https://github.com/nikunj11itdhm/Fabric-App-Rayfin-MarketingCampaignBuilding Energy Dashboard
Building Energy Dashboard is a React and TypeScript web app, built as a Microsoft Fabric App with the Rayfin CLI. It shows live building energy data from Power BI semantic models. A mockup file in the repo (energy-dashboard.html) was the starting point. - Content: KPIs such as self-sufficiency and peak demand, an energy-by-source stacked chart, a source-breakdown card, a solar-produced card with a 7-day trend, and a ranked device list. Selecting a house drills the views down. - Data: it comes from DAX queries run against the models, shown as Vega-Lite charts and a data grid. Light and dark themes are supported, and there is a 3D stage
