Hi Guys, Just wanted to ask about Partitioning with Direct Lake. I already have a very large delta table, roughly 60 million rows. Every hour I am appending data to this table using a notebook. I have partitioned this table using year and month (so roughly 84 partitions). I assume the benefit of partition is that the append is easier and the optimize function doesn't have to join up the 60 million rows but rather the append files inside of the latest year+month combination. However when I go to the Microsoft guide it tells me that I should avoid using partitions if my goal is to use a delta table for a semantic model (which it is): Microsoft Reference: https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-understand-storage#table-partitioning Important If the main purpose of a Delta table is to serve as a data source for semantic models (and secondarily, other query workloads), it's usually better to avoid partitioning in preference for optimizing the load of columns into memory. Questions: 1. Should I avoid using the partition? 2. What examples are there of why we need to partition? Any help will be much appreciated. Thanks

Just wondering how long you guys spent studying for the DP-600? What resources did you use?

Hey everyone, I am currently using a Fabric Trial License (FT1) and I was wondering what is the best License to get given my current consumption. I have attached a screenshot of my Fabric Capacity Metrics and I can see the highest total usage occurred on 1st October @ 10:31. I used 91.27 CU: (Interactive CU: 9.97, Background CU: 81.3) in a 30 second period. This seems to indicate I need a F4 SKU? As 91.27/30 = 3.04.... However, I notice that my background consumption was highest a few minutes later at 83.87 CU in a 30 second period. Whereas my interactive CU was highest on 10th October at 78.48 CU in a 30 second period. The sum of these two highs returns a 162.35 CU, which would indicate I need a F8 SKU? As 162.35/30 = 5.41.. Which SKU do you think I need? Furthermore if I want to reduce my consumption, how would I go about doing this? For background operations when I drill-through at the highest consumption point I see multiple runs of my notebook for different periods. Why? For interactive operations I see a Query which ran 5 minutes before the drill-through time. Why? Any help would be much appreciated.

I'd appreciate your feedback on my resume, which reflects 1.5 years of experience as a Data Consultant. I was accepted by a major company, but the CEO, who didn't interview me, mentioned wanting someone with more experience. I also had an interview with another company, but they offered a lowball deal of about $5 per hour, with 40% taxes on top of that. I've been applying to many positions, but I'm still not getting interviews. I'm using it as part of my cover letter. Dear Hiring Manager xxxx, I am writing to express my interest in the Data Analyst position at xxxx. With experience in data consulting and a history of improving analytics solutions, I believe I can contribute well to your team. In my current role as a Data consultant, I have the opportunity to work closely with clients, gaining an understanding of their unique data requirements, and providing continuous support throughout the project lifecycle. My solid experience in reverse engineering legacy Power BI reports, optimizing data models, and generating enhanced reports to meet evolving business needs has refined my skills in Power BI, SQL, and reverse engineering. Additionally, my grasp in DAX has allowed me to introduce new KPIs and improve analytics, thereby enhancing decision-making processes for clients. Coupled with my Microsoft DP-600 and PL300 certification, these skills equip me with the necessary expertise to excel in this role. Moreover, I am committed to continuous learning and staying updated on best practices, currently exploring Microsoft Azure (DP-203 certification). I am eager to leverage my capabilities to drive impactful insights and solutions for clients. Thank you for considering my application. I am excited about the opportunity to further discuss how my experience and skills align with the needs of your team. Please find my resume attached for your review. Sincerely, xxx Data Consultant

Hi Community, I had previously developed a Power BI report on the Premier League: Premier League Report This report ingests data from two separate web sources: - 24/25 Match Results - 24/25 Fixtures I passed DP-600 back in June but when I attended a presentation delivered by Will to the London Fabric User Group I was inspired to start building in Fabrics. I have tried to outline how using Microsoft Fabrics has improved my analytical solution in the slides attached. - Increased resilience & robustness - Built in Validation & Quality checks - Leveraging Git Integration for enhanced collaboration - Enhanced Analytical Capabilities. Please let me know your thoughts and any suggestions or improvements you might have.