Power BI course for Not-for-profits (Australian Eastern time zone)
Motive Consulting is excited to launch our new training course Power BI Beginner for Not-for-profits! Over the past few years, we have had the opportunity to create Power BI reports for a variety of not-for-profit organisations. During this time, we noticed a gap in training options available to NFPs, with most existing courses focusing on corporate themes such as sales and profit. Our new course bridges this gap by providing content designed specifically for NFPs. It draws on examples and datasets related to the Australian social service sector, ensuring the training is relevant and practical. As with all of our consulting and training services, we are offering discounted pricing for NFP organisations. Course highlights: 💡 No Power BI experience required 📑 Course manual and exercise files provided 🎓 Led by an experienced Microsoft Certified Trainer 💻 Delivered remotely via Microsoft Teams 🕒 Full day course from 9am to 4pm AEST Course dates: 📆 8 April 📆 21 May 📆 24 June ▶️ For more information, or to book now, visit: https://www.motiveconsulting.com.au/training-services/power-bi-beginner-not-for-profits You can also follow us on LinkedIn at https://www.linkedin.com/company/motive-consulting
Parsing Issue
Dear Experts, I have a Data like below:- From this I have a to create an Output file with the below logic, (sample of an entry in Output file is below):- HARQ ID, can range from 0 ~15, and Each HARQ can be re-transmitted(RV) in the Sequence 0->2->3->1->0->2->3->1...(create data with all the Harq IDs having the RVs in a full cycle and extended(0-2-3-1-0) System frame number have to be consecutive and after 1023 SystemFrameNumber(Column C) repeats it self. Thanks in Advance, Br, Anupam
Cubeset with multiple Period range
Hey All! need help with creating a Cubeset formula! I've market data at region level for multiple period & brand! I want to know the rank of particular Brand in each region on Specific Period. Formula is working for a particular period but not working on a range! How can I use a range/dynamic period in cubeset. =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]})}" ) This is working for particular month but when I want to get data for 3 month like Oct-Dec =CUBESET( "ThisWorkbookDataModel", "EXISTS([Brandmaster].[Brand].children, ([State_Master].[State].[Maharashtra], {[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))", "Set", 2, "{([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[dec-2024]})}" ) I'm getting error on this. Range is working on set expression but while using same in Sort By (Highlighted Part), I'm getting the error. One way around is passing Each Month separately not tried that but I want it to be dynamic using timeline & using Min/Max function to define the range, it could be 2month or 12 month. Pls help me with this. Thanks
Microsoft In a Day (XIAD) Partner Events Program - Train the Trainer Events (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 Program and 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: Fabric Analyst in a Day (FAIAD) Friday, February 14, 2025 | 9:00 AM – 5:00 PM (GMT+01:00) Central European Time Real-Time Intelligence in a Day (RTIAD) Thursday, March 13, 2025 | 9:00 AM – 5:00 PM (GMT-06:00) Central Time Real-Time Intelligence in a Day (RTIAD) Friday, March 14, 2025 | 9:00 AM – 5:00 PM (GMT+01:00) Central European Time 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/PartnerEventsPower Query Combine Worksheet
Dear Experts, I have many sheets(>10) sharing only 2 here as an example. Each sheet has a data summary in the end as below, and I want to merge all the sheets into a Single one with all the below data only:- But when , I merge the sheets, in the Column "A", only Time is there but all the stats are gone and not merged:- And after merge all that needed data is lost, and only Time stamps are there:- What wrong , am I doing here? Br, Anupam
KPI dax logic not giving correct counts but table visual does
Hi Team, I have below dax for the Doors open kpi: Doors Open = VAR _count = CALCULATE( MAX( BMSDoorStoreJoin[CreatedOn] ), BMSDoorStoreJoin[Status] = "Open" ) VAR _siteid = MAX(BMSDoorStoreJoin[SiteId]) RETURN CALCULATE( COUNT( BMSDoorStoreJoin[CreatedOn] ), BMSDoorStoreJoin[Status] = "Open"&& BMSDoorStoreJoin[CreatedOn] = _count && BMSDoorStoreJoin[SiteId] = _siteid ) Now, this returns the value of 1 which is wrong according to filtered SiteId(StoreName). My expected output from this logic is I want to find unique count of Doors Open(Site[Sitecode]) for the max of createdon date. For example, the data below for Sitecode 472 we have Status as closed and we don't have open. So it should retun nil. but in this case it returns 1. My table visual also shows correctly that it has only closed status. When i use my kpi logic in that visual it gives correct count. Please advise! PFA file here BMS Chillers Insights.pbix Thanks in advance! SergeiBaklanJoin 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 call, now offered at two different times! 🎉 The Fabric Engineering Connection call, taking place Wednesday, March 5, from 8-9 am PST, and the APAC Fabric Engineering Connection call, taking place Thursday, March 6, from 1-2 am UTC/Wednesday, March 5, from 5-6 pm PST, will feature presentations from Matthew Hicks on Iceberg Virtualization in OneLake; Diana Tram Nguyen and Andrew Boe on SMB Paths to Azure Solutions Partner Designations & AMM and Azure Innovate Access; and Sanaullah Sanai and Rita ABDELLATIFI on Sustainability Data Solutions in Fabric. 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 can't wait to see you tomorrow/Thursday!Filter context playing up with Calculated column logic in report visual
Hi Sir, I have a calculated column as below: Its working fine in this table level. But when I use this column in a table visual in report its not working correctly and its giving 'Yes' in all rows of the table for same deviceid: FYR, screenshot attached: It should contain only rows where there are warnings(Yes). But when i remove the OpenMinutes,Storetime and Door Time from above table, I get the correct output: My expected output for filtered sitecode 73 and deviceid 2452 is i need below columns along with Store Time, Door Time and OpenMinutes(openstateduration table): Store Time comes from Openstateduration table DateTimeRounded which is linked to Door table DateTimeRounded(Both date columns should match): Door Time will be coming from Createdon date of Openstateduration table which is linked to Door table Createdon(Both date columns should match): Modeling for these tables are: Could you please help me fix this issue? Also, much appreciated if you help me with alternative or better solution like pushing Warning logic to power query or creating better modeling for this issue etc. PFA file here B&M (4).pbix Please feel free to let me know if any issues! Thanks in advance! SergeiBaklan
I cannot import an Excel file from OneDrive using Power Query (“Get Data → From Web”) in Excel
For some time now, OneDrive has not been providing me with the full URL of the Excel file in my personal OneDrive folder. Instead, it now gives me a shortened link, which is not accepted by the “Get Data → From Web” option in Excel. Example of the URL format it used to provide: https://onedrive.live.com/redir.aspx?cid=31XXX007X973ee6b&resid=3XXXXXC973EE6B!49999&parId=3XXXXXC973EE6B!46489&authkey=!ANrZXXXSdDCDJ0 Example of the URL format it now provides: https://1drv.ms/t/c/3XXXXXC973ee6b/EWvuc8kHcMcggDE6wwXXXXXBSTsVubH5dQtJKs7ZY8tlZg?e=PdwXXk With the first type of URL, I only had to replace the text "redir.aspx" or, in some cases, the text "embed" with "download", and I could easily import the Excel content using the “Get Data → From Web” option in Excel. This allowed me to work with it in Power Query without any issues. I should mention that I am using my personal OneDrive account. Could you provide a manual or guide on how to import data from an Excel file located in a personal OneDrive account using the “Get Data → From Web” option in Excel? Is there a way to obtain the full file URL in OneDrive so I can import it as I did before? Is there another way to import files from OneDrive using the shortened URL it now provides? En Español: Desde hace un tiempo, onedrive no me entrega la URL completa del archivo excel en mi carpeta de onedrive personal. Ahora me entrega un link corto el cual no es aceptado por la opción de "Obtener Datos --> De la Web" del excel. URL de ejemplo que entregaba hace un tiempo: https://onedrive.live.com/redir.aspx?cid=31XXX007X973ee6b&resid=3XXXXXC973EE6B!49999&parId=3XXXXXC973EE6B!46489&authkey=!ANrZXXXSdDCDJ0 URL de ejemplo que entrega ahora: https://1drv.ms/t/c/3XXXXXC973ee6b/EWvuc8kHcMcggDE6wwXXXXXBSTsVubH5dQtJKs7ZY8tlZg?e=PdwXXk Con la primera opción de URL, solo debía cambiar la el texto "redir.aspx" o en algunos casos el texto "embed" en la URL por el texto "download" y con eso podía importar sin problemas el contenido del excel a través de la opción "Obtener Datos --> De la Web" del excel para posteriormente trabajarlo con power query Debo indicar que estoy utilizando mi cuenta personal del onedrive ¿Pueden incluir algún manual de como importar datos desde un excel ubicado en ondrive personal utilizando la opción "Obtener Datos --> De la Web" del excel?. ¿Se puede obtener la URL completa del archivo en onedrive para poder importarlo como lo hacía anteriormente? ¿Existe otra forma de importar archivos desde onedrive utilizando la URL corta que entrega ahora?
