power bi
1202 TopicsPartner Know Before You Go to the 2025 European Microsoft Fabric Community Conference!
We can’t wait to see you at FabCon Europe 2025, taking place 15-18 September at the Austria Center Vienna in Vienna, Austria! With more than 130 expert-led sessions over three days, plus workshops 15 September, this is the largest Microsoft tech conference in Europe! Our team has been hard at work planning several partner-exclusive activities throughout the event, to help ensure the best experience possible for you, our valued partners. This Know Before You Go guide will provide all the details on how to participate in: Partner Day Partner Happy Hour 1:1 Meetings Partner Booth at Ask the Experts Partner AMA Partner Photo Scavenger Hunt Cvent Event App If you have any questions, please feel free to reach out to our team at mailto:FabricPartnersTeam@microsoft.com or through the Cvent app. See you very soon! Complete details and entry form are available at https://aka.ms/FabConEuropePartnerPhotoHunt.295Views2likes1CommentJoin the Fabric Partner Community for an AMA with Arun Ulag!
🚨 Mark your calendars now! 📅 New this year in the Fabric Partner Community, an AMA (Ask Me Anything) call series with members of the Fabric Leadership Team! 🥳 Arun Ulag, CVP of Azure Data, will kick of this new call series Thursday, September 25, from 8-9 am PT. You will not want to miss this opportunity to ask all your questions, including those related to the announcements made at #FabConEurope, provide your feedback, and more! 👏 To join theses calls, you must be a member of the Fabric Partner Community Teams Channel. Not yet part of the Fabric Partner Community? Join now by submitting the form at https://aka.ms/JoinFabricPartnerCommunity.12Views1like0CommentsJoin the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft partner that is interested in data and analytics? Be sure to join us for this week's Fabric Engineering Connection calls! 🎉 Jia Ma will be providing a deep dive on Real-Time Hub and Jenny Jiang will be sharing the latest monitoring updates for Spark jobs. The Americas & EMEA call will take place Wednesday, September 10, from 8-9 am PT and the APAC call is Thursday, September 11, from 1-2 am UTC/Wednesday, September 10, from 5-6 pm PT. This is your opportunity to learn more, ask questions, and provide feedback. To join the call, you must be a member of the Fabric Partner Community Teams channel. To join, complete the participation form at https://aka.ms/JoinFabricPartnerCommunity. We look forward to seeing you next week!11Views1like0CommentsUnderstanding the Microsoft MVP Program: Seeking Clear Guidance
Hello everyone, I’d like to start a discussion about the Microsoft Most Valuable Professional (MVP) Program. My main concern is understanding the process of becoming an MVP and the specific requirements involved. I know the program recognizes exceptional community leaders and experts who share their knowledge and support others, but the actual path to nomination and selection seems a bit unclear. Could anyone share clear guidance on the eligibility criteria, the nomination process, the types of contributions that are most valued, and practical tips to strengthen an application? Your insights and experiences would be highly valuable, not just to me but also to others in the community who may be interested in pursuing this recognition. Thank you so much for your attention and participation.Microsoft In a Day (XIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD)
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. ✨ Why Attend? Hands-On Experience: Participate in labs and demos just like customers will. Expert Guidance: Learn from experienced trainers and get your questions answered. Comprehensive Resources: Access all the content and support you need to succeed. 📅 Upcoming Events: Dashboard in a Day This is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. Currently available on-demand. Inquire at xiadevents@microsoft.com 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. August 22, 2025 (CET - EMEA) : Fabric Analyst in a Day August 29, 2025 (CET - EMEA) : Fabric Analyst in a Day September 22, 2025 (CST - AMERICAS) : Fabric Analyst in a Day 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. August 15, 2025 (CET - EMEA) : Real-Time Intelligence in a Day September 12, 2025 (CST - AMERICAS): Real-Time Intelligence in a Day Once registered, look for your registration confirmation email from notification@msftevents.microsoft.com that contains your unique Teams meeting link to join the virtual event. Be sure to check spam and junk folders, and mark as a safe sender. If you are unable to locate your registration confirmation, email pappspartnerevents@microsoft.com. We look forward to seeing you at an upcoming event! 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/PartnerEvents2.8KViews4likes3CommentsOLAP connection Open XML adds x: namespace which is preventing slicer to work
I serialise the excel workbook with C# OpenXml to dynamically change the connection.xml file so users can connect to olap cube tabular in pbi. So I programmatically set a connection string for the user this way. All was working fine until the user started to insert slicers to the pivot table. I noticed in the connection.xml the connections xml tag has x: namespace added by OpenXml. eg <x:connection></x:connection> According to doco "When the object is serialized out as xml, it's qualified name is x:connection." https://learn.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.connection?view=openxml-3.0.1 Once I removed these x: namespace from the connection xml tag slicers worked. <connections><connection></connection></connections> Is this a bug in excel ? Are there plans to fix this? OpenXml is a lib provided by Microsoft and adds the x: namespace and excel cant handle the namespace, Reporting this bug and to see when a bug fix will be release for excel to use slicers when you dynamically change the connection string using openxml. Thanks339Views0likes1CommentDownloading multiple files from excel hyperlinks
Dear experts, Could you please share any Excel formula or PQ solution to download multiple files from excel hyperlinks. Each cell have one hyperlink and there are total > 100 hyperlinks, it's difficult to download each file one-by-one. Thanks in Advance, Br, Anupam2.2KViews0likes11CommentsPower BI DAX measurements
Hello Power BI users. I am trying to create a measurement that gives me the top 10 providers experiencing patient's leaving against staff advice (ASA). The date that I am trying to create this measure lives in two separate tables from two different sources. I've connected these two tables using a date table to connect the two tables. In the ASA_Ali_1 table there are multiple programs with dates listed within each row. These dates include program capacity which will need to be used in the calculation. (of note, the ASA_Ali_1 table does not contain case by case basis information but a summation of ASAs that have occurred for each date corresponding to a specific program). In the CLEAN_ASA table, contains case by case i.e., client leaving ASA and the provider that was working with said client at the time of their departure. I need to use the program capacity to generate a relative number of ASAs of a specific provider (contained in CLEAN_ASA) against the average program capacity (contained in ASA_Ali_1). I would like the output to show me the top 10 providers experiencing ASAs for the most recent month. Here is an image of the two data sources being used so you can get an idea of the structure. To summarize, my outputs columns in report view should show the provider, the number of ASAs they have experienced in the most recent month, the number of ASAs in the most recent month, and the percentage of ASAs relative to that program that provider was working in relative to their respective program's capacity for the most recent month. (please note that the providers program they are assigned to work [within the CLEAN_ASA table] in is titled , "Housing location," and in Ali_ASA_1 this is identified as "Program"). Please let me know if I can create DAX measurements within both tables to generate this output. Any help would be greatly appreciated 🙂363Views0likes1Comment