You are working with a warehouse in Fabric that contains a table named 'Products' with columns 'ProductID', 'ProductName', 'Category', and 'Price'. You need to write a SQL query to find the highest priced product in each category. How would you structure this query?