After quite a busy period with lots of new releases at MS Build, I think the summer period will be a lot quieter for new releases from the Fabric product team (because of holidays!). It's a pretty good opportunity to: - take a break! - catch up on the features you think are important, but didn't have a chance to explore yet - learn something new What are your plans for the summer period? Anything you want to learn in particular?

https://learn.microsoft.com/en-us/fabric/onelake/create-adls-shortcut#select-a-source based on documentation. ADLS gen2 is listed as an external data source, but OneLake is listed as an internal data source for Fabric. Can anyone better explain the difference in location between these? Also is this something different than Azure Blob storage? (I got to this question trying to understand when to setup a "shortcut" vs "mirror" on data sources). Can anyone add some perspective ? 🤔

Learning Fabric is a marathon, not a sprint. So let's celebrate the small wins we make along the journey. Share any recent wins you've had with Fabric in the comments below! Perhaps this week you: - successfully shortcuted into Amazon S3? - built a Snowflake mirrored database? - learnt some new data modeling techniques? - build your first eventstream to process real-time data? LET'S HEAR ABOUT IT!

For me, the most impressive/exciting feature that has been announced/ previewed over the last week is AI Skills, watch here: https://youtu.be/vlNxydCYx-4?si=ngRt2c7S6fVZZLH1&t=2700 I don't think it's been released yet, they just teased it at the end of the What's Next presentation. Take a look at the video... but to summarise: - AI Skill will be a new fabric item that allows the user to ask natural language questions about data in your Lakehouse. The AI Skill then write a SQL query and performs the query, and returns the results. - These AI Skills can then be embedded into Copilot and you can build your own chatbots with these Skills, and even embed it into a Teams chat. - Imagine being in a Teams meeting and asking your Skill (which is in the meeting) - "Hey what was the Sales figures for the last 12 months...?". - "Hey which tasks got completed in our project management system yesterday and which are delayed?"... etc etc etc. Could be very disruptive! But obviously depends on how good the results are though 😉 What do you think?

Hey everyone, While I was prepping for DP600 exam, I got super confused between RANK and DENSE_RANK functions. They both seemed to rank things, but there was a subtle difference that just wouldn't stick. If you're facing the same struggle, fear not! Let's break it down in simple terms.