Power BI
1221 TopicsHow to write a script or any PQ or in Excel to download the zip files from a Webpage
Dear Experts, Greetings! https://www.etsi.org/deliver/etsi_ts/138300_138399/138306/ Could you please help me on how to download the pdf.zip files from above for all the versions? Using a single command in Excel or PQ-option. Thanks in Advance, Br, Anupam146Views1like2CommentsThis week's Fabric Engineering Connection calls - Holiday Cheer Edition
🎉 Holiday Cheer Alert! 🎶 Ready to jingle all the way with the Fabric Partner Community? Join us for our Fabric Engineering Connection - Holiday Cheer Edition! The festivities kick off with a “Name That Tune: Holiday Edition” game—where your competitive spirit could win you fabulous prizes! Bring your brightest “Ho Ho Ho,” your silliest sparkle, and get ready to sleigh the season with us. 🎅✨ Stick around for inspiring presentations from our guest speakers: 🦌Nellie Gustafsson, Principal PM Manager, with updates on Data Science, AI, and Data Agents (Americas & EMEA call only) 🦌Shireen Bahadur, Senior Program Manager, and Ajay Jagannathan, Principal Group PM Manager, sharing “What’s New in Database Mirroring” 📅 Americas & EMEA: Wednesday, December 17, 8–9 am PT 📅 APAC: Thursday, December 18, 1–2 am UTC Show starts on the hour—enthusiasm mandatory, jingle optional! 🔔 To join, become a member of the Fabric Partner Community Teams Channel (if you are not already): https://lnkd.in/g_PRdfjt Let’s deck the halls, spread some cheer, and make this celebration one to remember!37Views0likes0CommentsIn a Day (xIAD) Partner Events Program - Train the Trainer Events (DIAD/FAIAD/RTIAD/CWYDIAD)
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. 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. Currently available on-demand. Inquire at xiadevents@microsoft.com 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. Currently available on-demand. Inquire at mailto:xiadevents@microsoft.com 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. December 22, 2025 - EMEA 9-5 CEST December 23, 2025 - AMERICAS 9-5 CST Sign up at https://aka.ms/CWYDIAD-ttt 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/PartnerEvents4KViews4likes3CommentsBuilding relationships in data model to leverage power pivot - circumventing unique key ID issue
When building relationships between two data tables in the data model of excel, you require a unique ID / key to relate the two datasets. This makes sense but I find it has an issue: It requires you to reduce the entirety of your dataset down to unique ID's in one of your tables so that it can do the 'one to many' relationship build. If you don't have unique ID's / key, the relationship between two tables often doesn't work. Yes you can use an intermediary table with unique ID's to link the two complete tables, but when using that intermediary table I find you are limited in what additional data rows you can bring into the combined power pivot table to provide context to the relationship. Once you start bringing in contextual rows from the separate tables, there ends up being a lot of repeated values for any numerical figure from the other table, which you are trying to aggregate. An example below of the power pivot table result (data from table 1 in blue, from table 2 in green) Product ID (Unique Key) Service Line Sales Amount COGS 169AKY T Shirts $1,000 $7,500 169AKY Sweaters $2,000 $7,500 169AKY Socks $3,000 $7,500 169AKY Turtle necks $4,000 $7,500 169AKY Pants $5,000 $7,500 COGS from table 2 also has the data broken out by Service Line (T-shirts, Sweaters, etc.), but will only show an aggregate COGS value for all service lines for each unique product ID, instead of breaking it out by Service Line. This is because the Service Line column is being inserted into the power pivot table from table 1, it breaks out sales by Service Line. If you insert the Service Line data column into the power pivot from table 2, COGS would be broken out by Service Line, and only an aggregate for sales would be produced. Ideally the power pivot would display sales AND COGS broken out by Service Line (and Product ID). Is there a best practice for building relationships (unique ID's) between data tables: Without reducing the richness / variety of columns and data in your original tables (when creating the unique ID)? Maybe 'group by' function in power query to obtain unique ID's before building the relationship? With retaining the ability to slice and dice the data by different characteristics (assuming they are present in both source tables) and have that detail presented in the power pivot. Thanks for the help! The humble Apprentice127Views0likes4CommentsJoin the Fabric Partner Community for this Week's Fabric Engineering Connection calls!
Are you a Microsoft partner that is interested in data and analytics? After a two-week break for Ignite and Thanksgiving, be sure to join us for this week's Fabric Engineering Connection calls! Yitzhak Kesselman will be presenting on the brand-new Microsoft Fabric IQ, just announced during Ignite, followed by Shuaijun Ye with Environment Best Practices. The Americas & EMEA call will take place Wednesday, December 3, from 8-9 am PT and the APAC call is Thursday, December 4, from 1-2 am UTC/Wednesday, December 3, from 5-6 pm PT. This is your opportunity to learn more, ask questions, and provide feedback. To participate in 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 at the calls!35Views1like0Commentspower query/ dax measure , multiple conditions/ multiple answers
I have loaded multiple tables in power query table of revenue per category: category revenue EM01 86.000 EM02 68.000 EM03 93.000 EM04 87.000 EM05 6.000 EM06 96.000 EM07 87.000 EM08 54.000 table of share per category per accountmanager: employee accountmanager share accountmanager EM01 AM1 75% EM01 AM2 25% EM02 AM1 100% EM03 AM2 100% EM04 AM3 100% EM05 AM2 60% EM05 AM3 40% EM06 AM1 100% EM07 AM1 50% EM07 AM3 50% EM08 AM2 100% Note: in same cases (EM01, EM05, EM07) multiple accountmanagers are in charge for a category. Total of share per category is always 100%. How to organize in power query to connect both tables to get table of revenue per per category per accountmanager? Use measure? Which? Or other solution? Answer (in pivot table) should be: employee AM1 AM2 AM3 total EM01 64.500 21.500 - 86.000 EM02 68.000 - - 68.000 EM03 - 93.000 - 93.000 EM04 - - 87.000 87.000 EM05 - 3.600 2.400 6.000 EM06 96.000 - - 96.000 EM07 43.500 - 43.500 87.000 EM08 - 54.000 - 54.000Solved407Views0likes16CommentsFilter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehow595Views0likes19CommentsHow to highlight duplicated sequential rows
I have a data like below sfn can range from 0~1023, and then again start with 0, slots can range from 0~19 I want to highlight the rows like below:- so, 331.12 is repeated in ROWS(4,5) so highlighted in Yellow, 331.13 is repeated in ROWS(6,7) so highlighted in Yellow and so on. if any Conditional formatting or anyother logic, by which we can highlight these data , would be helpful. Worksheet attached. Br, AnupamSolved134Views0likes3Comments