In a Day (xIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD/CDIAD/SQLAIAD)
We invite you to attend an upcoming Train the Trainer session for Microsoft Partners to learn more about the Microsoft In a Day (XIAD) Partner Events Programand how to lead workshops that empower customers to use and adopt Microsoft products. Our Train the Trainer events are designed to provide you with the knowledge and tools necessary to deliver successful Microsoft In a Day (XIAD) sessions. *Please note, participation is restricted to individuals representing a Microsoft Partner organization. You must register using your corporate email address that is associated with your Partner ID. Personal emails will not be approved. ✨ Why Attend? Expert Guidance: Learn from experienced trainers and get your questions answered. Comprehensive Resources: Access all the content and support you need to succeed. Learn more at https://aka.ms/attendTTT 📅 Upcoming Events: Dashboard in a Day This is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. September 10 - Americas - Central Time September 18 - APAC - SGT September 25 - EMEA - CEST Fabric Analyst in a Day This is an intermediate-level training designed for Power BI Data Analysts who have at least one year of experience on Power BI but are new to Microsoft Fabric. September 10 - Americas - Central Time September 18 - APAC - SGT September 25 - EMEA - CEST Real-Time Intelligence in a Day This is an intermediate-level training designed for Power BI developers looking to extract insights and visualize streaming and time sensitive data. September 10 - Americas - Central Time September 18 - APAC - SGT September 25 - EMEA - CEST Chat with your Data in a Day This is an intermediate-level training designed for Power BI data analysts and developers to help get their models chat-ready and unlock instant insights using natural language. September 10 - Americas - Central Time September 18 - APAC - SGT September 25 - EMA - CEST New Offer Type: SQL AI App in a Day This is an intermediate-level, one‑day, hands‑on workshop showing SQL Developers and DBAs how to build the database backbone for modern AI apps using Azure SQL. Coming soon! Partner with us! Are you a Microsoft Partner interested in the opportunity to join the program and deliver Microsoft In a Day (XIAD) events? 🔍 Learn more about the program and review partner eligibility criteria: https://aka.ms/xiadpartneropportunity. 📧 Contact the XIAD Program team: xiadevents@microsoft.com 📤 Submit requests to deliver events: https://aka.ms/xIAD/PartnerEvents🚀 Join the FY27 Fabric Engineering Connection Kickoff Call
We're excited to kick off FY27 with the first Fabric Engineering Connection call of the year! Join Tamer Farag, Global Partner Ecosystem Lead for Microsoft Fabric & SQL, as he shares the latest strategy, priorities, and opportunities for partners in the year ahead. What we'll cover ✅ Fabric Partner Community updates and upcoming changes ✅ Analytics on Azure Specialization updates ✅ Frontier Accelerate program highlights ✅ Partner enablement plans and resources ✅ Fabric Feature Partner program updates ✅ FabCon and SQLCon insights and opportunities ✅ Open Q&A with the community 🎁 Bonus: Attend live for a chance to win Fabric swag during the call! Event Details Americas & EMEA 📅 Wednesday, September 9, 2026 🕗 8:00 AM – 9:00 AM PT APAC 📅 Thursday, September 10, 2026 🕐 1:00 PM – 2:00 PM UTC (Wednesday, September 9, 5:00 PM – 6:00 PM PT) How to Join To participate, join the Fabric Partner Community Teams channel: 🔗 https://aka.ms/JoinFabricPartnerCommunity Whether you're a long-time community member or just beginning your Microsoft Fabric journey, this is a great opportunity to hear directly from the team, get aligned on FY27 priorities, and connect with fellow partners around the world. We look forward to seeing you there!✨ FabCon + SQLCon Europe 2026: Partner Know Before You Go Guide is Now Live!
Barcelona is just around the corner, and we're excited to welcome our partner community to the first-ever co-located FabCon + SQLCon Europe experience! To help you make the most of your time onsite, the Partner Know Before You Go Guide is now available. This guide brings together everything partners need to know before arriving, including exclusive partner programming, networking opportunities, important deadlines, and event resources. What You'll Find Inside ✅ Partner Day agenda and key sessions ✅ Partner Happy Hour details ✅ Partner Elevator Pitch Challenge information ✅ Executive Meetings with Fabric & SQL Leadership Team ✅ 1:1 Meetings with the Partner Success Team ✅ AMA Session with the Fabric Partner Success Team ✅ Fabric Certification Recognition opportunities ✅ Testimonial Video nominations ✅ Fabric in the Wild Partner Photo Scavenger Hunt ✅ Cvent Event App guidance and Partner Community information Important Partner Deadlines 📅 September 13, 2026 (11:59 PM PT) Submit your Partner Elevator Pitch entry Request an Executive Meeting with Fabric Leadership Request a 1:1 Meeting with the Partner Success Team Nominate yourself or your customer for a testimonial video opportunity Event Details 📍 Centre de Convencions Internacional de Barcelona (CCIB) 📅 September 28 - October 1, 2026 🌍 Barcelona, Spain Whether you're attending Partner Day, meeting with Microsoft leaders, showcasing your expertise, or connecting with peers from around the world, we've built partner-exclusive experiences to help you learn, connect, and accelerate your Microsoft Fabric business. 📘 Download the Partner Know Before You Go Guide below. ⬇️ We can't wait to see you in Barcelona! #FabConEurope #SQLConEurope #MicrosoftFabric #MicrosoftPartners #DataAndAI #FabCon2026 #PartnerCommunity2026 FabCon + SQLCon Europe Fabric in the Wild: Photo Scavenger Hunt
📸 Fabric in the Wild: Photo Scavenger Hunt at FabCon + SQLCon Europe Heading to FabCon + SQLCon Europe in Barcelona? Get ready to explore, connect, and have some fun with the Fabric community! We're excited to launch the Fabric in the Wild: Photo Scavenger Hunt, an exclusive experience for Microsoft partners attending the event. Whether you're networking at Partner Day, taking in the keynotes, meeting fellow partners, or discovering Barcelona, you'll have the opportunity to capture your adventure and win some exclusive Fabric swag. 🏆 Win Fabric Kicks Complete the challenge by sharing photos from any five scavenger hunt moments and you'll be entered for a chance to win 1 of 3 pairs of Fabric Kicks. 📷 How It Works ✅ Complete any 5 photo challenges from the hunt ✅ Share all 5 photos in a single LinkedIn post or carousel ✅ Include: #FabConEurope #MicrosoftPartner #FabricInTheWildSweepstakes ✅ Tag @Stephanie Chimeziri That's it. You're in! The scavenger hunt is all about celebrating the people, experiences, and energy that make the Microsoft Fabric partner community special. From Partner Day and keynotes to new connections and iconic Barcelona landmarks, we can't wait to see Fabric in the wild through your lens. Drop your photos, showcase your creativity, and share your FabCon story with the community! 🌍 See you in Barcelona. For more information about FabCon + SQLCon Europe, visit aka.ms/fabconeu #MicrosoftFabric #FabConEurope #SQLConEurope #MicrosoftPartner #FabricCommunity #DataAnalytics #FabricInTheWildSweepstakes #PartnerDay #MicrosoftPartnersGLSU Excel add-in fails to load after Office update from Version 2607 to 2608
Our Excel add-in, Process Runner GLSU , fails to load after Microsoft Office updates from Version 2607 to Version 2608. This started August 17, 2026 and is actively growing in scope. Error messages: Excel: Cannot run the macro 'onLoad' VBA: System Error &H80004005 (-2147467259). Unspecified error VBA: Compile error in hidden module: ThisWorkbook Has anyone encountered similar issue with their own custom add-on. If yes, any pointers to fix it. We are seeking help on priority. Thanks, Vrushali Pawale, Sr. Manager, Insightsoftware.
Office Scripts does not refresh Power BI Query live connections in Excel Online
Hello everyone, I've got the following problem and am nearly going insane because it's causing so much problems 🥲 Summary The Office Scripts method workbook.refreshAllDataConnections() no longer refreshes a live connection to a Power BI Semantic Model in Excel Online. Environment Excel Online Office Scripts Power Automate ("Recurrence" + "Run Office Script") Live connection to a Power BI Semantic Model (Analyze in Excel) Expected behavior Calling workbook.refreshAllDataConnections(); should trigger the same refresh as manually selecting Data → Refresh All in Excel Online. Actual behavior The script completes successfully without any error, but the workbook does not requery the Power BI Semantic Model. Additional observations The same workbook worked correctly for approximately two years. The issue started around mid-July 2026. Manual Data → Refresh All in Excel Online refreshes successfully. Refreshing in Excel Desktop also works correctly. The problem occurs both: when running the Office Script manually from the Automate tab in Excel Online when running the same Office Script from Power Automate ("Run Office Script") This suggests the issue is specific to the Office Scripts implementation of refreshAllDataConnections() rather than the workbook, authentication, or the Power BI connection itself. Steps to reproduce Create an Excel workbook with a live connection to a Power BI Semantic Model. Confirm that manual Data → Refresh All refreshes the data successfully. Create an Office Script containing only: function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); } Run the script. Result The script finishes successfully but no refresh is performed. Expected result The workbook should requery the Power BI Semantic Model exactly as when using the manual Refresh All button in Excel Online.Storage Accounts - Networking
Hi All, Seems like a basic issue, however, I cannot seem to resolve the issue. In a nutshell, a number of storage accounts (and other resources) were created with the Public Network Access set as below: I would like to change them all to them all to Enabled from selected virtual networks and IP addresses or even Disabled. However, when I change to Enabled from selected virtual networks and IP addresses, connectivity from, for example, Power Bi to the Storage Account fails. I have added the VPN IP's my local IP etc. But all continue to fail connection or authentication. Once it is changed back to Enabled for All networks everything works, i.e. Power Bi can access the Azure Blob Storage and refresh successfully. I have also enabled 'Allow Azure services on the trusted services list to access this storage account'. But PBI fails to have access to the data. data Source Credentials error, whether using Key, Service Principal etc, it fails. As soon as I switch it back to Enable From All Networks, it authenticates straight away. One more idea I had was to add ALL of the Resource Instances, as this would white list more Azure services, although PBI should be covered by enabling 'Allow Azure services on the trusted services list to access this storage account'. I thought I might give it a try. Also, I created an NSG and used the ServiceTags file to create an inbound rule to allow Power BI from UK South. Also, I have created a Private Endpoint. This should all have worked but still can’t set it to restricted networks. I must be missing something fundamental or there is something fundamentally off with this tenant. When any of the two restrictive options are selected, do they also block various Microsoft services? Any help would be gratefully appreciated.Turning Nonprofit Data Into Action: A Technical Guide to Power BI
Nonprofits generate data constantly — but it’s often scattered across Excel files, CRMs, survey tools, and program systems. Power BI provides a unified analytics layer that connects, cleans, models, and visualizes this data in a secure, scalable environment. It is part of Microsoft’s broader analytics stack designed to turn raw data into actionable insight. This guide dives deeper into the technical foundations required to build nonprofit‑ready analytics solutions. Power BI Architecture for Nonprofits Power BI consists of three core components: 1. Power BI Desktop Power BI Desktop is the primary authoring tool used to create data models and interactive reports. These reports are then published to the Power BI Service for sharing and collaboration. Used for: Data modeling (building semantic models) DAX calculations (measures and calculated columns) Visual design (interactive reports) Data transformation using Power Query 👉 Power BI Desktop overview 2. Power BI Service (Cloud) The Power BI Service is the cloud-based platform for collaboration, distribution, and consumption of analytics, enabling teams and stakeholders to securely access and interact with data insights Used for: Publishing reports from Power BI Desktop Sharing dashboards and reports Scheduled data refresh Row-Level Security (RLS) Workspaces, apps, and governance 👉 Get Started Creating in the Power BI Service - Power BI | Microsoft Learn 3. Power BI Gateway (Optional) The gateway ensures secure data transfer between on‑premises systems and Power BI cloud services. Used when connecting to on‑premises data sources (SQL Server, local Excel files, etc.). Acts as a secure bridge between cloud services and on‑premises data Enables scheduled data refresh and live (DirectQuery) connections Keeps sensitive data within your local network while enabling cloud-based analytics 👉 On-premises data gateway - Power BI | Microsoft Learn Core Data Preparation: Power Query Power Query is the data preparation and ETL (Extract, Transform, Load) engine behind Power BI. Capabilities: Connects to multiple data sources Cleans and reshapes data Creates repeatable transformation pipelines Supports hundreds of data transformations 👉 Power Query overview Power Query standardizes data and automates preparation workflows, reducing manual effort. Advanced Nonprofit Use Cases 1. Multi‑Program Outcome Dashboards Nonprofits often manage multiple programs with different metrics. Power BI enables unified reporting through: Star schema modeling Fact tables (attendance, outcomes, surveys) Dimension tables (participants, programs, locations) 👉 Star schema guidance: Understand star schema and the importance for Power BI - Power BI | Microsoft Learn 2. Donor Analytics With Predictive Insights DAX (Data Analysis Expressions) is a formula language used to create dynamic calculations and measures inside Power BI data models. Using DAX, AI visuals, and advanced analytics features, nonprofits can: Identify donor churn Analyze giving trends and likelihood Segment donors by behavior Calculate and track lifetime value 👉 DAX reference 3. Volunteer Workforce Analytics Track and optimize: Volunteer hours by skill Retention trends Training completion and effectiveness Event staffing gaps and workforce allocation 👉 Power BI HR analytics sample (workforce trends & attrition): Human Resources sample – Power BI 4. Grant Reporting Automation Power BI enables nonprofits to automate and standardize grant reporting processes, reducing manual effort and improving accuracy. Capabilities: Automatically refresh data using scheduled refresh in the Power BI Service Standardize reporting through reusable dashboards and report templates Automated export and distribution 👉 Configure scheduled refresh – Power BI 👉 Export and automate report delivery with Power Automate How to Build a Nonprofit Impact Dashboard (Advanced) Step 1: Build a Data Model Import data (Excel, SharePoint, SQL) Create core tables: FactOutcomes DimParticipant DimProgram DimDate Define one‑to‑many relationships between dimension and fact tables This follows a star schema approach, which improves performance, scalability, and reporting clarity. 👉 Power BI data modeling guidance Step 2: Create DAX Measures Example measures: Total Participants = COUNT(DimParticipant[ParticipantID]) Total Outcomes = SUM(FactOutcomes[OutcomeValue]) Outcome Rate = DIVIDE( [Total Outcomes], [Total Participants], 0 ) Active Participants = CALCULATE( DISTINCTCOUNT(DimParticipant[ParticipantID]), FactOutcomes[Status] = "Active" ) 👉 DAX reference Step 3: Build Visuals Use report visuals to present key metrics and patterns, then pin selected visuals to dashboards in the Power BI Service for executive-level monitoring. Cards → KPIs (total participants, outcomes) Line charts → trends over time Maps → geographic impact Matrix tables → structured reporting for funders 👉 Intro to dashboards for Power BI designers - Power BI | Microsoft Learn and Overview of Power BI reports - Power BI | Microsoft Learn Step 4: Publish and Automate Publish to Power BI Service Configure scheduled refresh Apply Row-Level Security Share dashboards with leadership, funders, and board members 👉 Configure scheduled refresh - Power BI | Microsoft Learn and Tutorial: Get Started Creating in the Power BI Service - Power BI | Microsoft Learn Final Thought Power BI gives nonprofits a modern, enterprise-grade analytics platform without requiring a full data engineering team. By combining: Structured data modeling Automated data preparation Strong governance practices nonprofits can transform fragmented data into clear, actionable insight that drives mission impact.
