Need partition in ranking in power query editor or Dataflows in Fabric

Hi Team, I have a CTE in my sql which is giving ranking in a table and below is the code   select *, rank() over(partition by Empstatus,Emprole,Empdept order by empid) as Empid_Rank from EmployeeT...