Filter Function or TAKE-DROP Function
Dear Experts, I have a Data like this:- Column A -> Has the File Names, and Column B,C,D have their corresponding data, In Column F I have the unique File Names and from G/H/I -> I need the start of the hfn/sfn/slot and in J/K/L the end of the hfn/sfn/slot for that File Name as populated , How to achieve this? Thanks & Regards Anupam Shrivastava
In a Day (xIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD/CDIAD)
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. 📅 Upcoming Events: Dashboard in a Day This is a one-day, hands-on workshop for business analysts, covering the breadth of Power BI capabilities. April 17th, 2026 - EMEA - CEST time zone April 23rd, 2026 - Americas - PST time zone May 8th, 2026 - Americas - CST time zone June 4th, 2026 - APAC - SGT time zone Sign up here: https://aka.ms/TTTSignUp 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. April 17th, 2026 - EMEA - CEST time zone April 23rd, 2026 - Americas - PST time zone May 8th, 2026 - Americas - CST time zone June 4th, 2026 - APAC - SGT time zone Sign up here: https://aka.ms/TTTSignUp 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. April 17th, 2026 - EMEA - CEST time zone April 23rd, 2026 - Americas - PST time zone May 8th, 2026 - Americas - CST time zone June 4th, 2026 - APAC - SGT time zone Sign up here: https://aka.ms/TTTSignUp 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. April 9th, 2026 - EMEA - CEST time zone May 5th, 2026 - APAC - SGT time zone May 20th, 2026 - Americas - CST time zone June 2nd, 2026 - EMEA - CEST time zone June 8th, 2026 - APAC - SGT time zone June 26th, 2026 - Americas - CST time zone Sign up 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
Power BI Service report on SharePoint lists with multi-select relationships
Dear all, we plan to document our projects on project specific SharePoint sites with risks, decisions, changes, scope statements and status reports in dedicated lists. The idea is to also cross-reference those items, i.e. for example a weekly status report (documented as a row in the list) could reference multiple decisions, risks or changes (rows from the other lists) via lookup columns. In addition to this setup, we want to be able to report via Power BI / Power Query in Power BI Service on the data documented in the project specific SharePoint sites and their lists. Now we are facing several challenges in this setup: dynamic data sources the number of projects, and hence the number of SharePoint sites and their lists are dynamic and need to be queried using functions, to circumvent the dynamic data source problem in Power BI service, e.g. Web.Contents() with option RelativePath extraction of multi-select references using SharePoint.Tables() gives the IDs of the referenced items in the other list, but this method cannot be modified with option RelativePath to circumvent dynamic data sources issue Web.Content() is able to use RelativePath option, however output for multi-select relationships doesn't seem to be complete getting identifiers for resolving references across different list one option we identified is combination of List.Id property (GUID) and ListItem.Id (int32), however here we are not sure if these are unique identifiers another option would be the field UniqueID {32-bit Hex} coming via SharePoint Search api call data privacy levels/combination of different data sources for resolving the relations between list (and related query output) lists would need to be referenced, which is not working in the Power BI service across different queries However we think, that we can circumvent that by doing the/resolving the relations via DAX So all in all i tried to combine several approaches to adress these requirements and also restrictions, however i am not sure anymore if the above outlined approach would be feasible at all. I hope that my description is not to confuse; in case anything is unclear or should be outlined in more detail please let me know. Did anybody else try to address such requirements and succeeded? Looking forward to any input for feedback :) Kind regards PetterConditional Formatting or a Specific Filter Rule
Dear Experts , I have a data like below:- here the Column-O, txNumber can go from 1,2,3 (txNum=2 and 3 means a Retransmission), I want to filter all the pairs for all Transmissions and their corresponding Retransmissions ( either by coloring them all using a conditional formatting) or using a specific filter Rule. How to identify the Transmission and it's corresponding Retransmission for a Specific HarqId( say for dlHarqProcessIndex ==7, the blue color Row-37 is my 1st transmission(txNumber ==1) for the dlHarqProcessIndex==7 with a tbSize of 852696, and adaptRetxStatus == NOTACTIVATE, and it's corresponding 2nd transmission( Retransmission , txNumber==2) Row-45, tbSize remains same(as it's corresponding 1st transmission) in all retransmissions and adaptRetxStatus changes to "APPLY" for all retrans txNumber==2,3) and similarly for other pairs like for dlHarqProcessIndex==13. Attached is the Worksheet.🚀 FabCon + SQLCon Partner Social Sprint
A 4‑Day LinkedIn Challenge for Partners Attending FabCon + SQLCon in Atlanta If you’re joining us in Atlanta this March for FabCon + SQLCon 2026, we’ve got a new way for you to amplify your impact: the Partner Social Sprint — a daily LinkedIn challenge designed to spotlight partner voices, share real‑world insights, and have some fun along the way. Whether you’re presenting, staffing a booth, or attending sessions, this is your chance to tell your story and connect with the global Microsoft Fabric & SQL community. 🔥 What Is the Partner Social Sprint? A 4‑day LinkedIn posting challenge running during FabCon + SQLCon 2026 in Atlanta. Each day has a theme, and every post earns you entries to win exclusive Fabric SWAG, including the fan‑favorite Fabric Kicks. 🗓 Daily Themes (Conference Week) Tuesday, March 17 – Day 0 (Travel / Partner Day) Why I’m going / why I’m here Wednesday, March 18 – Day 1 One big learning Thursday, March 19 – Day 2 Build your practice Friday, March 20 – Day 3 Customer impact ✅ How It Works If you’re a partner attending FabCon + SQLCon in Atlanta: Post once per day on LinkedIn during the event, following the daily theme. Use the hashtags: #FabConSQLCon26 #PartnerSocialSprintSweepstakes #MicrosoftPartner Tag the FabCon & SQLCon – The Microsoft Fabric & SQL Community Conferences LinkedIn page. Submit all your LinkedIn post URLs via the entry form. 👉 Each post = 1 entry, and if you post all 4 days, you’ll get 1 bonus entry. 🏆 What You Can Win Fabric SWAG Fabric Kicks Recognition in the Fabric Partner Community and across our channels 🌐 Who Should Join? Microsoft partners attending FabCon + SQLCon in Atlanta Partner sellers, architects, engineers, and community champions who want to: Share key learnings in real time Highlight their Fabric & SQL practices Showcase customer success and impact 👉 Ready to Sprint With Us? Get all the details and submit your posts here: https://aka.ms/PartnerSocialSprint Let’s light up LinkedIn with the stories, insights, and innovation coming out of FabCon + SQLCon. We can’t wait to see your posts from Atlanta!🚀 This Week on the Fabric Engineering Connection!
Excited to share what’s ahead for this week’s Fabric Engineering Connection sessions — your weekly opportunity to hear directly from the Microsoft Fabric engineering teams and stay ahead of what’s coming next in the platform. 🎙️ Featured Topics & Speakers: 🔧 Updates on DBT Job Abhishek Narain, Principal PM Manager 🤖 Upcoming Capabilities in Fabric Data Agents Misha Desai, Principal Product Manager Virginia Roman, Senior Product Manager Shreyas Canchi Radhakrishna, Product Manager 🌍 Americas & EMEA 📅 Wednesday, February 25 ⏰ 8:00–9:00 AM PT 🌏 APAC 📅 Thursday, February 26 ⏰ 1:00–2:00 AM UTC (Also available Wednesday, February 25, 5:00–6:00 PM PT) Whether you're deep in deployment, scaling customer workloads, or exploring new Fabric capabilities, these sessions are packed with insights to help you accelerate your practice. 👉 Not yet part of the Fabric Partner Community? Join here: https://lnkd.in/g_PRdfjt Let’s keep learning, building, and shaping the future of Fabric—together. 💡
Organizational Account authentication problem
I have encountered a new authentication problem using an organizational account with Get Data > From Web. The data source is Dynamics 365 CE on-premises (https://ce.xxx.com/api.data/v9.1), authenticating through ADFS with MFA. This has been working without any issues until recently. When I attempt to refresh the query, I get an ADFS pop-up window for username and password, as expected. However, the window then closes without the expected MFA prompt. The "Access Web content" window does say "You are currently signed in," but does not query successfully, instead displaying the error "We couldn't authenticate with the credentials provided. Please try again." The most distinctive symptom, is that clicking the "Sign in as different user" button does not work. It just quickly opens and closes an empty window, instead of the expected ADFS username/password page. In Power BI Desktop everything works. The connection and query are successful, and the "Sign in as different user" button successfully displays both the initial ADFS username/password window and the subsequent MFA dialog. Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2512 Build 16.0.19530.20226) 64-bit✨ FabCon + SQLCon 2026: Partner Know Before You Go Now Live!
Heading to FabCon + SQLCon 2026 in Atlanta? We’ve put together your full Partner Know Before You Go Guide — everything you need to navigate the week, maximize value, and make the most of all partner‑exclusive opportunities. 🚀 Here’s what you’ll find inside: 📅 Partner Day (Mar 17) — A full day of partner‑only learning, strategy, and networking. - SOLD OUT! 🍻 Partner Happy Hour — Connect with other partners and the Microsoft team. 🎤 AMA with the Fabric Partner Success Team — Bring your biggest questions around Data & AI priorities, partner opportunities, funding, enablement, and certifications. 🤝 1:1 Meetings — Book time with Fabric LT or the Partner Success Team to accelerate your strategy and unlock customer wins. 🎤 Partner Elevator Pitch Search — Submit your 2‑min pitch to be featured live on stage! 🔥 Partner Social Media Sprint — Daily LinkedIn challenge + chances to win Fabric SWAG. 🎓 Certification Spotlight — Get recognized during Arun’s keynote for hitting 100+ Fabric certs. 🎥 Testimonial Videos — Share your Fabric customer stories with global visibility. 📱 Whova Event App — Build your schedule, access slides, network, and join the partner community inside the app. 📘The full KBYG guide is attached below.Join the Fabric Partner Community for this Week's Fabric Engineering Connection Calls
🚀 Excited to share this week’s Fabric Engineering Connection lineup for our Microsoft Fabric partner community! We’ll be joined by Johannes Kebeck, Principal PM Manager, to dive into Fabric Maps — and how partners can bring location intelligence and rich geospatial experiences into their Fabric solutions. 📍 Fabric Engineering Connection – This Week 🌎 Americas & EMEA 📅 Wednesday, February 11 ⏰ 8:00–9:00 am PT 🌏 APAC 📅 Thursday, February 12 ⏰ 1:00–2:00 am UTC (Wednesday, February 11, 5:00–6:00 pm PT) These weekly calls are a chance for partners to: ✅ Hear directly from Fabric engineering ✅ See what’s new and what’s coming ✅ Ask questions and share feedback To participate in these calls, you must be a member of the Fabric Partner Community Teams channel. 👉 Join here: https://aka.ms/JoinFabricPartnerCommunity
Power Query - How Do I Count a Number of Entries Based on Another Column?
Hello! The title might be a little confusing. Here's the situation. I manage uniforms for my team. I am making a SharePoint list and form that an employee will use to request the uniforms. Then, to give me a digestible table that shows me exactly what I need, I have an Excel Power Query pulling the list in. On the form, instead of having a different entry for each polo in each color, each size, and each cut, I have it separated so that you pick cut, sizing, and color separately. Is there a way to have Power Query pull it to show me, for the screenshot example: Female L Red Polo: 2 Female L Blue Polo: 2 Male M Red Polo: 3 Male M Blue Polo: 1 Male M Tan Polo: 2 So on, and so forth. Is this possible? Thank you!
