Alternate for PIVOT in Direct Query

Hello All,

I am using the direct query to fetch the data from Azure SQL server into PBI and using the PIVOT in sql query. Query is taking 8  hours to fetch the data.

Please suggest if there is any alternate for PIVOT.

Thanks in advance,